List:General Discussion« Previous MessageNext Message »
From:louis liu Date:May 14 2012 2:01pm
Subject:Re: drop partitions
View as plain text  
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

Thread
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