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
dnelson@stripped
