----- Original Message ----- > From: "Rick James" <[email protected]> > > 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
