Добрый день.
> > | table_cache | 256 |
> > +---------------+-------+
> >
> > m1# mysql -e "show status like 'Open%'"
> > +---------------+-------+
> > | Variable_name | Value |
> > +---------------+-------+
> > | Open_tables | 256 |
> > | Open_files | 446 |
> > | Open_streams | 0 |
> > | Opened_tables | 6114 |
> > +---------------+-------+
>
> Ok, this is bad :) I should have also asked what your mysqld uptime
> was at this point. 6144 table opens is pretty high even for a couple
> days of uptime, though. Try bumping table_cache up to 512 and see what
> happens. Keep bumping it up until Opened_tables stops increasing.
We have table_cache=1024
Maybe this solve the problem.
>
> /var/db/mysql/my.cnf :
>
> [mysqld]
> set-variable = table_cache=512
>
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
Best regards.
_______________________________________
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
---------------------------------------------------------------------
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
