Edit History

In phpMyAdmin go to the SQL tab and run these:

SHOW VARIABLES LIKE 'max_connections'; SHOW GLOBAL STATUS LIKE 'Threads_connected'; SHOW GLOBAL STATUS LIKE 'Max_used_connections';

o max_connections = your current configured limit
o Threads_connected = how many are connected right now
o Max_used_connections = the highest number of connections used since last restart

If max used is much lower than the limit, you don’t need to raise it. For many PrestaShop shops, setting the limit to about 200 is a good balance if the server has enough memory.

To change the value permanently you would edit the MySQL configuration (ask your host if you don’t have access).

If your max used is much lower than the limit, you don’t need to raise it. For many PrestaShop shops, a limit around 200 works fine as long as the server has enough memory.

To change it temporarily:

SET GLOBAL max_connections = 200;

To make it permanent, add this line under [mysqld] in your mysql config file:

max_connections = 200

Then restart mysql.

In phpMyAdmin go to the SQL tab and run these:

SHOW VARIABLES LIKE 'max_connections'; SHOW GLOBAL STATUS LIKE 'Threads_connected'; SHOW GLOBAL STATUS LIKE 'Max_used_connections';

o max_connections = your current configured limit
o Threads_connected = how many are connected right now
o Max_used_connections = the highest number of connections used since last restart

If max used is much lower than the limit, you don’t need to raise it. For many PrestaShop shops, setting the limit to about 200 is a good balance if the server has enough memory.

To change the value permanently you would edit the MySQL configuration (ask your host if you don’t have access).