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
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> |
> We're hiring! https://cloudability.com/jobs<