List:General Discussion« Previous MessageNext Message »
From:Rick James Date:May 14 2012 9:00pm
Subject:RE: drop partitions
View as plain text  
Note that in many (too many) cases, _all_ partitions are opened, even if only one is
really needed.

> -----Original Message-----
> From: louis liu [mailto:ylouis83@stripped]
> Sent: Monday, May 14, 2012 7:02 AM
> To: Johan De Meersman
> Cc: mysql@stripped; Rick James
> Subject: Re: drop partitions
> 
> 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