List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:May 14 2012 1:14pm
Subject:Re: drop partitions
View as plain text  
----- 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
drop partitionslouis liu11 May
  • RE: drop partitionsRick James11 May
    • Re: drop partitionslouis liu11 May
  • RE: drop partitionsRick James11 May
    • Re: drop partitionsJohan De Meersman14 May
      • Re: drop partitionslouis liu14 May
        • RE: drop partitionsRick James14 May