Re: Please help with slow easy query
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?
Subject
Views
Written By
Posted
4979
April 21, 2009 11:58PM
2305
April 22, 2009 02:10AM
2387
April 22, 2009 03:27AM
Re: Please help with slow easy query
2269
April 22, 2009 07:02AM
2301
April 22, 2009 09:37AM
2273
April 22, 2009 10:31AM
2425
April 22, 2009 12:22PM
2252
April 23, 2009 12:16AM
2087
April 23, 2009 03:27AM
2148
April 23, 2009 02:20AM
2923
April 23, 2009 03:25AM
2326
April 24, 2009 07:18AM
2182
April 25, 2009 01:42PM
2131
April 25, 2009 04:34PM
2296
April 27, 2009 09:28AM
2144
April 27, 2009 09:47PM
2041
April 28, 2009 09:16AM
2277
April 28, 2009 09:34AM
2167
April 29, 2009 09:44AM
2682
April 30, 2009 02:07PM
2132
April 30, 2009 10:54PM
2215
May 01, 2009 11:30AM
2118
May 01, 2009 09:52PM
2131
May 04, 2009 12:46PM
2351
April 22, 2009 10:46AM
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.