What are the VARIABLES values of
open_files_limit
table_open_cache
table_definition_cache
How partitions in this table? How many tables in your system?
> -Original Message-
> From: louis liu [mailto:yloui...@gmail.com]
> Sent: Friday, May 11, 2012 1:35 AM
> To: mysql@lists.mysql.com
open_files_limit =3
table_open_cache =4096
table_definition_cache =256
How partitions in this table?
14 partitions
How many tables in your system ?
about 390 tables
cheers
2012/5/11 Rick James
> What are the VARIABLES values of
> open_files_limit
> table_open_cache
> table_definitio
If you have 14 partitions in each of 390 tables, and if you have most of the
tables 'active', then you are possibly thrashing in the table_open_cache.
Compute (SHOW STATUS):
Opened_tables / Uptime -- don't want more than a few per sec.
Opened_files / Uptime -- ditto
Opened_table_definitions / Upt
- Original Message -
> From: "Rick James"
>
> If you have 14 partitions in each of 390 tables, and if you have most
> of the tables 'active', then you are possibly thrashing in the
> table_open_cache.
A distinct possibility.
> Compute (SHOW STATUS):
> Opened_tables / Uptime -- don't wan
not actually , first partition to have been dropped is no longer in use
,we dropped partition from old -> new
2012/5/14 Johan De Meersman
> - Original Message -
> > From: "Rick James"
> >
> > If you have 14 partitions in each of 390 tables, and if you have most
> > of the tables '
Note that in many (too many) cases, _all_ partitions are opened, even if only
one is really needed.
> -Original Message-
> From: louis liu [mailto:yloui...@gmail.com]
> Sent: Monday, May 14, 2012 7:02 AM
> To: Johan De Meersman
> Cc: mysql@lists.mysql.com; Rick James
>