In the last episode (Sep 26), zxcv said:
> MySQL status:
>
> Threads: 1 Questions: 1860358 Slow queries: 5 Opens: 2004 Flush
> tables: 1 Open tables: 256 Queries per second avg: 0.524
>
> MySQL show status:
>
> | Table_locks_immediate | 3052077 |
> | Table_locks_waited | 0 |
> | Open_tables | 256 | <-- This???
> | Open_files | 479 |
> | Opened_tables | 2004 |
>
> Any suggestions? Did I run out of file descriptors? Currently some
> sysctl's are:
Try doubling your table_cache from 256 to 512 and see how often you get
that error.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
