Solving table overflow problems

  • lnpower

    (@lnpower)


    2 years ago

    Thank you for attention. The site I am promoting has problems with the operation of plugins, as well as the visual display of some pages. Stack => PHP, WordPress, Elementor. I am attaching the error.log. There is an opinion that the problem is that a certain plugin overloads the system due to join requests to databases.
    If you need specific elements of the site, I can send you everything you need.
    Link to error.log :
    https://fex.net/ru/s/tysefma

    Links to a self-written plugin, maybe the problem is there: https://fex.net/ru/s/rk5nzxc

    • This topic was modified 2 years ago by lnpower.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator James Huff

    (@macmanx)

    2 years ago

    Please attempt to deactivate all plugins and switch to the default Twenty Twenty-Three theme. If the problem goes away, re-activate them one by one to identify the source of the problem.

    If you can install plugins, install Health Check. On the troubleshooting tab, you can click the button to deactivate all plugins and change the theme for you while you’re still logged in without affecting normal visitors to your site.

    Thread Starter lnpower

    (@lnpower)

    2 years ago

    I installed health check, it suggested 3 fixes that did not affect the result, I also gradually turned on the plugins and changed the theme, turning off the plugins did not affect the result, turning off the theme led to turning off the self-written plugin that stores the columns for forming the page https://mainecoonkittenus.com/ru/furry_group/kotyata/ with which I have a problem, here is a description of the global problem from the log, since this is hosting, I don’t have all the rights to change, only the SQL_BIG_SELECTS command, but it didn’t help

    “

    These error messages indicate a problem with database queries on your WordPress site. They all mention that queries select more rows than allowed by the MAX_JOIN_SIZE setting in MySQL. The MAX_JOIN_SIZE parameter limits the maximum number of rows that can be processed as a result of a table join (JOIN) in a SQL query to prevent accidentally generating queries that could overload the server. The messages advise using SET SQL_BIG_SELECTS=1 or increasing MAX_JOIN_SIZE if the query is acceptable. SQL_BIG_SELECTS is a server option that allows you to run “big” queries with a potentially huge number of connections.

    “

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Solving table overflow problems’ is closed to new replies.