List:General Discussion« Previous MessageNext Message »
From:Brad Heller Date:March 17 2014 8:36am
Subject:Re: SHOW CREATE TABLE suddenly slow on InnoDB?
View as plain text  
Hey Andrew,

I'm on 5.5.27. Good thought. Just flipped that setting off and getting the
same results. It pretty clearly seems to be InnoDB: If I create a HEAP
table, I don't get this behavior.

FWIW, I have (and always have had) innodb_file_per_table enabled, but my
tablespace file is still gigantic (56GB)?

*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>


On Mon, Mar 17, 2014 at 1:07 AM, Andrew Moore <eroomydna@stripped> wrote:

> 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