MySQL Forums
Forum List  »  Performance

Re: Please help with slow easy query
Posted by: Ilya Cheburaev
Date: April 22, 2009 07:02AM

Aftab Khan Wrote:
-------------------------------------------------------
> show us
> uptime?
> show global status like 'open%'
> show global variables like 'open_files%';

Now it's slow again.. (Strange because it's too early for havy load) but.
Files still opens slow (have to wait 2 - 5 sec before opening any file in os like through MC or VI)

SHOW STATUS LIKE 'open%':

Variable_name Value
Open_files 808
Open_streams 0
Open_tables 439
Opened_tables 499

gaia:/home/ilya # uptime
5:15pm up 1 day 1:33, 3 users, load average: 11.41, 8.94, 7.99
gaia:/home/ilya # lsof | grep mysql -c
29400
I'll not restart server so i'll be able to check anything else.

May be there is some kind of OS (SUSE 9) limits with FileSystem?

Options: ReplyQuote


Subject
Views
Written By
Posted
4979
April 21, 2009 11:58PM
2305
April 22, 2009 02:10AM
Re: Please help with slow easy query
2269
April 22, 2009 07:02AM
2301
April 22, 2009 09:37AM
2252
April 23, 2009 12:16AM
2148
April 23, 2009 02:20AM
2131
April 25, 2009 04:34PM
2144
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.