----- Original Message -----
> From: "Rick James" <rjames@stripped>
>
> 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 want more than a few per sec.
> Opened_files / Uptime -- ditto
> Opened_table_definitions / Uptime -- ditto
Assuming you have anywhere near decent uptime, those are going to be way too flattened to
be of use. Trend monitoring is a necessity - look at Munin or Cacti.
A random thought, though - could the first partition to have been dropped not have been in
active use, so the drop operation had to wait for all other statements to end, and the
other (older?) partitions no longer in use, so could be dropped immediately?
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
