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 <vegivamp@stripped>
> ----- 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
Phone: +86 13918046970
Email & Gtalk: ylouis83@stripped
Personal Blog: http://www.vmcd.org