MySQL Forums
Forum List  »  Performance

Re: Please help with slow easy query
Posted by: Ilya Cheburaev
Date: April 22, 2009 12:22PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4980
April 21, 2009 11:58PM
2305
April 22, 2009 02:10AM
2301
April 22, 2009 09:37AM
Re: Please help with slow easy query
2425
April 22, 2009 12:22PM
2252
April 23, 2009 12:16AM
2148
April 23, 2009 02:20AM
2131
April 25, 2009 04:34PM
2145
April 27, 2009 09:47PM
2167
April 29, 2009 09:44AM
2132
April 30, 2009 10:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.