Hi Brad,
> We actually only have about 60 tables in that database. I've tried increasing
> the cache and open tables limits and get the same behaviour.
Hmm.. Shawn’s guesses are probably better than mine then.
> A few other tests I've tried:
>
> 1. Stand up a new machine, dump just the schema
Hello Brad,
On 3/17/2014 5:50 PM, Brad Heller wrote:
Hey Morgan,
We actually only have about 60 tables in that database. I've tried
increasing the cache and open tables limits and get the same behavior.
mysql> select @@table_definition_cache, @@table_open_cache,
@@innodb_file_per_table, @@inno
Hey Morgan,
We actually only have about 60 tables in that database. I've tried
increasing the cache and open tables limits and get the same behavior.
mysql> select @@table_definition_cache, @@table_open_cache,
@@innodb_file_per_table, @@innodb_open_files;
+--+-
Hi Brad,
> That sounds right. Here's the process list (scrubbed) and the show engine
> innodb status. Notice that all of the SHOW CREATE TABLE aren't for hte same
> table, just got cleaned up that way.
It shouldn't matter if they are for the same or different - in 5.5 there is one
table open cac
Hey Morgan,
That sounds right. Here's the process list (scrubbed) and the show engine
innodb status. Notice that all of the SHOW CREATE TABLE aren't for hte same
table, just got cleaned up that way.
https://gist.github.com/bradhe/c9f00eaf93ac588b8339
We have the defaults for table_definition_cac
Hi Brad,
> 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, b
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 giganti
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" wrote:
> Hey all,
>
> I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE quer
On 13 Oct 2003 at 16:59, Adam Clauss wrote:
> Well the issue wasn't so much with my program at runtime, but at
> design time (now). What I am doing is hardcoding the string that
> creates the table into the program. Program then calls SHOW CREATE
> TABLE and compares the two strings to see if th
un SHOW CREATE TABLE
If (create != str)
recreate table
Adam Clauss
[EMAIL PROTECTED]
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 13, 2003 3:15 PM
> To: Adam Clauss; [EMAIL PROTECTED]
> Subject: Re: SHOW CREATE
At 14:48 -0500 10/13/03, Adam Clauss wrote:
I'm currently writing a program that will make use of the SHOW CREATE TABLE
statement to verify that existing tables are correct (if not, it drops them
and recreates). Why is it though that the SHOW CREATE TABLE statement
returns the answer on multiple l
Date |Tue, 28 Aug 2001 23:43:16 +0200
>From |"Martin Jeremic" <[EMAIL PROTECTED]>
Hello!
MJ> This is really stupid, but I can remember how to save results of "SHOW
MJ> CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
MJ> running mysql 23.41 on Win2k.
MJ> Thanks in ad
Version 3.23.20
On Tue, 31 Jul 2001, Ansgar Becker wrote:
> since which version was the "show create table" syntax introduced?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
13 matches
Mail list logo
