List:General Discussion« Previous MessageNext Message »
From:Andrey Kotrekhov Date:March 25 2002 9:08am
Subject:Re: FreeBSD+MySQL
View as plain text  
Добрый день.

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

    Best regards.
_______________________________________
	Andrey Kotrekhov kota@stripped
	ISP Alkar Teleport
	тел. +380 562 34-00-44

Thread
FreeBSD+MySQLOzette Brown22 Mar
  • Re: FreeBSD+MySQLAndrey Kotrekhov22 Mar
    • Re: FreeBSD+MySQLOzette Brown22 Mar
      • Re: FreeBSD+MySQLDan Nelson22 Mar
    • Re: FreeBSD+MySQLOzette Brown22 Mar
      • Re: FreeBSD+MySQLDan Nelson22 Mar
        • Re: FreeBSD+MySQLAndrey Kotrekhov25 Mar