Re: Please help with slow easy query

[Ilya Cheburaev]

>your query can't be cached, because the base table has got long varchar and TEXT fields.

Thanks for caching info. I'll fix this.

>>do note that tables can consume multiple descriptors (in case of MyISAM), as well as client connections are using them too.
I found that MyIsam usualy use 2 descriptors for 1 table but why lsof | grep mysql -c show 132852? and why linux allow to open so many descriptors if mysql limited by fs-max with 65536 and by ulimit -n with 16384 can't understand this one.

>show us
>uptime?
>show global status like 'open%'
>show global variables like 'open_files%';


After today restart of Mysql and Apache
Load Average became good (less then 1.00)
but before it was near 10.00

now:
gaia:/home/ilya # uptime
1:27pm up 21:46, 3 users, load average: 0.74, 0.69, 1.02

Mysql uptime were something about 10 hours.

show global variables like 'open_files%';

Variable_name Value
open_files_limit 16384

Global not work with 4.1 (so i hope show status will show info for all connections too):

show status like 'open%';

Variable_name Value
Open_files 757
Open_streams 0
Open_tables 394
Opened_tables 454

But this information for now (after restart) tonight i'll check this variables again (under havy load) i think it'll be a different