List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:March 17 2014 8:07am
Subject:Re: SHOW CREATE TABLE suddenly slow on InnoDB?
View as plain text  
Hey Brad. What version are you using? My immediate thought is to check if
innodb_stats_on_metadata is off. If it is on, switch off and check your
timings again.

Regards
On 17 Mar 2014 04:40, "Brad Heller" <brad@stripped> wrote:

> Hey all,
>
> I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE query so I
> can figure out what could possibly have made them suddenly slow down?
>
> mysql> SHOW CREATE TABLE `my_table`;
> ...
> 1 row in set (37.48 sec)
>
> We tend to execute many of these statements concurrently, but it's never
> been a problem until recently. I upgraded the IO subsystem, and our
> statistics indicate that it's not maxing out IO (at least IOPS).
>
> This is problematic because the ORM we're using uses that to figure out the
> structure of our DB...
>
> *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 |
> Skype: brad.heller | @bradhe <http://www.twitter.com/bradhe> |
> @cloudability<http://www.twitter.com/cloudability>
>
> We're hiring! https://cloudability.com/jobs<
> http://www.cloudability.com/jobs>
>

Thread
SHOW CREATE TABLE suddenly slow on InnoDB?Brad Heller17 Mar 2014
  • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Andrew Moore17 Mar 2014
    • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Brad Heller17 Mar 2014
  • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Morgan Tocker17 Mar 2014
    • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Brad Heller17 Mar 2014
      • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Morgan Tocker17 Mar 2014
        • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Brad Heller17 Mar 2014
          • Re: SHOW CREATE TABLE suddenly slow on InnoDB?shawn l.green17 Mar 2014
          • Re: SHOW CREATE TABLE suddenly slow on InnoDB?Morgan Tocker17 Mar 2014