>Can you send us the output of the "lsof | grep mysql" as that is too high but not that this will catch up more then just files open by mysql.
There is all opened tables for each mysql process in system (like 500 tables
~ 21506 lines)
lsof | grep mysql:
http://www.uxoft.ru/files/lsf
Full current report:
http://www.uxoft.ru/files/report.txt
ps ax | grep mysql (i think i'll be helpful):
http://www.uxoft.ru/files/psout
>uptime? I mean mysql uptime :)
ok =)
current info(restarted again loaded low-medium):
MySQL 4.1.13-standard-l uptime 0 1:49:15 Wed Apr 22 20:37:59 2009
>mysql> show global status like 'open_t%'; # want to see how quickly it reaches to the limit
>mysql> show global variables like 'max_connection%';
>mysql> show global status like 'Th%';
>mysql> show global variables like 'wait%';
mysql> show status like 'Th%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 17 |
| Threads_connected | 3 |
| Threads_created | 20 |
| Threads_running | 1 |
+-------------------+-------+
4 rows in set (0.00 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 | 367 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show global variables like 'max_connection%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 100 |
+-----------------+-------+
1 row in set (0.00 sec)
Thank's a lot!