login into MySQL:
1 |
mysql -u user -p |
Execute commands:
1 2 |
set global interactive_timeout = 60; set global wait_timeout = 60; |
and check:
1 |
show global variables like '%timeout%'; |
then go to :
phpmyadmin -> Privileges -> Select user
And change the fields:
MAX QUERIES PER HOUR = 30000
MAX UPDATES PER HOUR = 20000
MAX CONNECTIONS PER HOUR = 5000
MAX USER_CONNECTIONS = 25
Finally restart mysql:
1 |
service mysqld restart |