mysql error when click [Top Statistics]

[Lock Down]

Lost connection to MySQL server during query Error Number : 2013

Your mysql is timing out. Could be too many connections or one of those wonderful mods that has a malformed sql statement. If this is your vps/dedi you can optimize mysql by changing timeouts and connections.

to start try:

mysql> show variables like "%timeout%";
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| connect_timeout | 5 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| interactive_timeout | 28800 |
| net_read_timeout | 100 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| wait_timeout | 28800 |
+--------------------------+-------+

mysql> SET @@NET_READ_TIMEOUT=200;

mysql> SET @@connect_timeout=30;

mysql> show variables like "%timeout%";

Expand