----- Original Message -----
> From: "Rick James" <rjames@yahoo-inc.com>
>
> 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql