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
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 ope
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
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 de
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
t;Brad Heller" 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`;
>>
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 exec
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
Sorry for another email. But this is just to expand on what SHawn said..I
could also have created an index and then referenced the column.
So without a primary key. I can create the parent , then create the child
and the index .
mysql> create TABLE parent ( id int(16) , name varchar(128))ENGINE=
Thanks shawn for your reply. Your simplification of the innodb status
message and this post which I just read (http://lists.mysql.com/mysql/221900
)
tells me what I am doing wrong.
I need the referenced column to be indexed. I guess one way of ensuring that
is to declare it as a primary key .
So
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql> show innodb status;
+---
using readline 5.0
Thanks for your help
Hari
mysql> show create TABLE parent;
++-+
| Tab
| |
+---+---+-+--+--+--+
| b | enum('А','Б') | YES | | NULL | | <-- Ok
+---+---+-+--+--+--+
show create table t1;
show create table t2;
++
| t
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
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 they are the same. If not, it drops and recr
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 mul
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 lines? Why not just one line? And
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
This is really stupid, but I can remember how to save results of "SHOW
CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
running mysql 23.41 on Win2k.
Thanks in advance
--
Martin Jeremic
mail
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 ma
Hi,
since which version was the "show create table" syntax introduced?
I'm planning to implement it in MySQL-Front for the database-export-options,
but I have to check the version first.
Greetings,
Ansgar Becker
-
fair enough.
thanks!
Rob
- Original Message -
From: "Andrew Schmidt" <[EMAIL PROTECTED]>
To: "Rob Agar" <[EMAIL PROTECTED]>; "Mailinglist MySQL COM"
<[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 7:02 PM
Subject: Re: does show create
I believe SHOW CREATE TABLE was added in 3.23.20...
http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html
http://www.mysql.com/doc/N/e/News-3.23.20.html
On Wed, 6 Jun 2001, Rob Agar wrote:
> hi!
>
> Does SHOW CREATE TABLE x actually work? When I try it I just get error
> 1064
6, 2001 11:48 AM
Subject: does show create table work?
> hi!
>
> Does SHOW CREATE TABLE x actually work? When I try it I just get error
> 1064 (you have an error in your sql syntax near 'CREATE TABLE x')
>
> (version 3.22.32 on linux)
>
> ta,
> Rob Agar
>
hi!
Does SHOW CREATE TABLE x actually work? When I try it I just get error
1064 (you have an error in your sql syntax near 'CREATE TABLE x')
(version 3.22.32 on linux)
ta,
Rob Agar
-
Before posting, please chec
26 matches
Mail list logo
