{"id":836,"date":"2024-06-29T06:17:34","date_gmt":"2024-06-29T06:17:34","guid":{"rendered":"https:\/\/linuxresellerwebhosting.in\/blog\/?p=836"},"modified":"2024-06-29T06:28:38","modified_gmt":"2024-06-29T06:28:38","slug":"fix-mysqli_sql_exception-too-many-connections","status":"publish","type":"post","link":"https:\/\/linuxresellerwebhosting.in\/blog\/fix-mysqli_sql_exception-too-many-connections\/","title":{"rendered":"Fix: mysqli_sql_exception too many connections"},"content":{"rendered":"

Here in this article you will know how to fix mysqli_sql_exception too many connections in cpanel<\/p>\n

Error mysqli_sql_exception too many connections<\/h2>\n

You may receive errors like the following on your website, or\u00a0when trying to access MySQL from the command line or phpMyAdmin.<\/p>\n

mysqli_connect(): (08004\/1040): Too many connections<\/pre>\n
mysqli_real_connect(): (HY000\/1040): Too many connections<\/pre>\n
PHP Warning: mysqli::__construct(): (08004\/1040): Too many connections in<\/pre>\n
mysqli_sql_exception too many connections<\/pre>\n
When a MySQL server is initially installed, it will have\u00a0150<\/strong>\u00a0as the default value for maximum permitted number of simultaneous client connections. This value can be adjusted further in servers.<\/p>\n
\"mysqli_sql_exception<\/p>\n
An additional admin connection is also possible to monitor these client connections.\u00a0This extra connection is reserved for use by accounts that have CONNECTION_ADMIN\u00a0or SUPER user\u00a0privilege.<\/p>\n
The number of connections is defined by \u2018max_connections\u2019<\/strong> value.\u00a0When the number of client connections exceed this value, MySQL shows \u2018Too many connections\u2019 error.<\/p>\n
This can happen in multiple scenarios, and the fix for the error would vary with the actual cause. Here, we\u2019ll see the various causes that trigger\u00a0MySQL \u2018Too many connections\u2019 error.<\/p>\n
Your MySQL database only allows so many connections at the same time. If you connect to MySQL via PHP, then you generally open a new connection every time a page on your site loads. So if you’ve got too much traffic to your site this can cause this issue.<\/p>\n
General procedure and fix,<\/p>\n
The default max_connections<\/code> setting for MySQL is 151<\/code>. For some servers, this setting may need adjusting. This article provides the procedure to adjust this setting.<\/p>\n
Access the server’s command line as the ‘root’ user via SSH or “Terminal” in WHM.
\nCheck the current max_connections setting.<\/p>\n
[root@server ~]cPs# mysql -e \"show variables like 'max_connections';\"\r\n+-----------------+-------+\r\n| Variable_name | Value |\r\n+-----------------+-------+\r\n| max_connections | 100 |\r\n+-----------------+-------+<\/pre>\n
Open \/etc\/my.cnf in your preferred text editor.
\nLocate the max_connections entry or add the entry to the end of the file if one doesn’t exist.<\/p>\n
max_connections=151<\/pre>\n
Set the max_connections value to the desired value.
\nSave the changes and exit the text editor.
\nRestart the MySQL service.<\/p>\n
\/usr\/local\/cpanel\/scripts\/restartsrv_mysql<\/pre>\n
Verify that the max_connections setting has been updated.<\/p>\n
[root@server ~]cPs# mysql -e \"show variables like 'max_connections';\"\r\n+-----------------+-------+\r\n| Variable_name | Value |\r\n+-----------------+-------+\r\n| max_connections | 150 |\r\n+-----------------+-------+<\/pre>\n
 <\/p>\n
If the mails are not delivering and in queue , you don’t know how to delete pending mail in Exim queue click here.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Here in this article you will know how to fix mysqli_sql_exception too many connections in cpanel Error mysqli_sql_exception too many<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[1],"tags":[],"class_list":["post-836","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/posts\/836","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/comments?post=836"}],"version-history":[{"count":8,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/posts\/836\/revisions"}],"predecessor-version":[{"id":845,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/posts\/836\/revisions\/845"}],"wp:attachment":[{"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/media?parent=836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/categories?post=836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxresellerwebhosting.in\/blog\/wp-json\/wp\/v2\/tags?post=836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}