now it's started again.
Loging in throug ssh takes about 30 seconds instead 2 seconds.
top:
top - 22:31:17 up 1 day, 6:49, 5 users, load average: 13.50, 13.25, 11.97
Tasks: 211 total, 5 running, 206 sleeping, 0 stopped, 0 zombie
Cpu(s): 60.1% us, 15.8% sy, 0.0% ni, 18.2% id, 4.0% wa, 0.3% hi, 1.6% si
Mem: 1028036k total, 967512k used, 60524k free, 160152k buffers
Swap: 2104432k total, 2716k used, 2101716k free, 357656k cached
gaia:/home/ilya # lsof | grep mysql -c
48386
connected to mysql from second try:
gaia:/home/ilya # mysql -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server during query
gaia:/home/ilya # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 88989 to server version: 4.1.13-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
There is connection's limit reached that's why he is dropped mysql connection.
So variables now have that values:
mysql> show status like 'Th%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 22 |
| Threads_connected | 23 |
| Threads_created | 43 |
| Threads_running | 3 |
+-------------------+-------+
4 rows in set (0.08 sec)
mysql> show global variables like 'wait%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show status like 'open_t%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Open_tables | 499 |
+---------------+-------+
1 row in set (0.08 sec)
mysql> show global variables like 'max_connection%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 100 |
+-----------------+-------+
1 row in set (0.03 sec)
And new files with data (under havy load):
lsof | grep mysql:
http://www.uxoft.ru/files/lsf2
Full current report:
http://www.uxoft.ru/files/report2.txt
ps ax | grep mysql (i think i'll be helpful):
http://www.uxoft.ru/files/psout2