max_user_connections

  • Hello friend,

    Sometimes I notice the following error message, and it seems to me that it is caused by the multiple connections that 404 Solutions makes to the Databases.

    [02-Jul-2024 13:12:38 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987
    [02-Jul-2024 13:12:38 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987
    [02-Jul-2024 13:12:42 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987
    [02-Jul-2024 13:12:42 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987
    [02-Jul-2024 13:12:42 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987
    [02-Jul-2024 13:12:44 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User yosiga_NljdIjoq already has more than ‘max_user_connections’ active connections in /home2/yosiga/public_html/wp-includes/class-wpdb.php on line 1987

    This doesn’t happen all the time, but it does sometimes. It would be interesting to know from your point of view what we can do, perhaps it is due to some configuration in the 404 solutions plugin.

    Best regards
    Luis

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

Viewing 1 replies (of 1 total)
  • Plugin Author Aaron

    (@aaron13100)

    Hey,

    I guess you think it’s linked to 404 Solution because you don’t see the error message when 404 Solution is disabled or not installed? Is that correct? I guess you think it’s linked to 404 Solution because you don’t see the error message when 404 Solution is disabled or not installed? Is that correct?

    I’ve never really considered that before. As far as I know, the default “max_user_connections” setting is 0, which mean unlimited connections. Can you run

    SHOW VARIABLES LIKE 'max_user_connections';

    to see what yours is set to? Is it set by a hosting provider, perhaps? If you’re on shared hosting I’d be interested to know which provider and what the value is set to, because it means others will have the same restrictions. If it is shared and if you want to, you could request that they increase it or set it to 0 because it’s causing issues for your wordpress installation. If you’re on dedicated hosting, I think you can change the setting by modifying the MySQL configuration file (my.cnf or my.ini) and adding or updating the following line:

    max_user_connections = [desired_value]

    If there’s a specific reason that you can tell it’s caused by the 404 Solution connections, it would be helpful to know which queries are running or how you know specifically that’s it’s due to this speicific plugin’s connections and not something else.

    I’m not sure how I might limit the number of connections, as I’ve never considered it before.

    regards

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.