List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 3 2014 11:17am
Subject:Re: SHOW FULL COLUMNS QUERIES hogging my CPU
View as plain text  
----- Original Message -----
> From: "Johan De Meersman" <vegivamp@stripped>
> Subject: Re: SHOW FULL COLUMNS QUERIES hogging my CPU
> 
> In any case, this is nothing that can be fixed on the database level.

I may or may not have to swallow that :-p

I've been hammering a munin plugin that graphs schema sizes (yay capacity management); and
obviously it's dragged down by an information_schema query. I stumbled upon this, which
may or may not be helpful for your situation, too:
http://www.mysqlperformanceblog.com/2011/12/23/solving-information_schema-slowness/

No guarantees, but it doesn't seem to have any significant downsides.


-- 
Unhappiness is discouraged and will be corrected with kitten pictures.
Thread
SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey2 Jun 2014
  • Re: SHOW FULL COLUMNS QUERIES hogging my CPUReindl Harald2 Jun 2014
    • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey2 Jun 2014
      • Re: SHOW FULL COLUMNS QUERIES hogging my CPUMichael Dykman2 Jun 2014
        • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey2 Jun 2014
      • Re: SHOW FULL COLUMNS QUERIES hogging my CPUSinger Wang2 Jun 2014
        • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey2 Jun 2014
          • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey2 Jun 2014
            • Re: SHOW FULL COLUMNS QUERIES hogging my CPUMorgan Tocker2 Jun 2014
              • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey3 Jun 2014
          • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJohan De Meersman2 Jun 2014
            • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJohan De Meersman3 Jun 2014
              • Re: SHOW FULL COLUMNS QUERIES hogging my CPUJatin Davey3 Jun 2014