Hi there,
In MySQL 8, how can you figure out if an entry in the mysql.user table is a
role or a user?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and
Hello list,
I come here with a case I can say very strange.
I explain, we have a db server with mysql version 5.5.49 on debian
jessie. Some
days ago, our workflow allowed us to purge a large table from one of our
db
servers. By large I mean a table which had 350GB in size.
To purge that table
a huge amount of
archiving by moving data to archiving servers and deleting from main
server.
We would like to however run optimize table in order to reclaim some
of the disk space , but we are facing the following issues :
- Running optimize on the full table not possible due to lack
Am 02.07.2016 um 16:49 schrieb Martin Mueller:
I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it
does not respond to queries, and the command to drop it does not execute. The
database seems to be OK in other respects. What can I do to get rid of the
table? Would
I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it
does not respond to queries, and the command to drop it does not execute. The
database seems to be OK in other respects. What can I do to get rid of the
table? Would it be safe just to remove the two .frm and .ibd
Hi!
I use mysql/innodb tables on aws services
in a small table (about 2M records) I changed some columns datatypes from
unsigned int to decimal and from float to decimal
I didn't change anything about primary key or other indexes
after the change (done without troubles), all my queries
in InnoDB. There are around 4400 tables in a
database. Lots of tables are partitioned by yearweek and having more than
50 partitions.
How to reproduce the issue:
1) We have a script to monitor table schema and create partitions. While
running it, we found running 'SHOW CREATE TABLE xxx
Hello Michael,
On 1/6/2016 12:51 PM, Michael Vaughan wrote:
If you execute the script below, you will get the following error:
'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist"
delimiter //
CREATE TABLE Test(
id int not null primary key auto_incre
If you execute the script below, you will get the following error:
'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist"
delimiter //
CREATE TABLE Test(
id int not null primary key auto_increment,
name varchar(255)
)//
CREATE TRIGGER TEST_TRIGGER
BEFOR
On 2015/08/12 09:42, Johan De Meersman wrote:
- Original Message -
>From: "Richard Reina"
>Subject: table desin question
>
>Would this be the best way to design the schema and would it be best to
>make the client ID and technician ID the same as the user ID as
- Original Message -
> From: "Richard Reina"
> Subject: table desin question
>
> Would this be the best way to design the schema and would it be best to
> make the client ID and technician ID the same as the user ID as they relate
> to the same person?
se user ID as the primary key for all?
For example:
TABLE: user
| ID | first_name| last_name| email |phone| password |
TABLE client
|ID | billing_add | b_city | b_st | b_zip | pmnt_mthd | cc_no|
TABLE Techician
|ID | type | years_of_exp | current | zone |
Would this be the b
details.What would the look up table
look like?
Thanks
2015-07-29 9:38 GMT-05:00 :
> > one table with a long ENUM column that contains repairs that
> > could be attributed to any appliance or different repair tables
> > for each appliance.
>
> The first would stick you with extending
Hi Richard,
On 7/29/2015 10:19 AM, Richard Reina wrote:
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appl
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or different repair tables for each appliance.
Al
I have a very large table (~50GB) and periodically rows are purged
from it and I want to run OPTIMIZE TABLE to recover the space. But I
do not have enough space to run it. If I do run it the server hangs
and must be killed and restarted and the table is damaged and must be
repaired. I do this with
low queries: 99 Opens: 607644 Flush
> tables: 3 Open tables: 64 Queries per second avg: 0.474
>
>
> my user-table looks like this:
>
> mysql> select host,user,password f
8
UNIX socket:/var/lib/mysql/mysql.sock
Uptime: 223 days 22 hours 38 min 49 sec
Threads: 1 Questions: 9178423 Slow queries: 99 Opens: 607644 Flush tables:
3 Open tables: 64 Queries per second avg: 0.474
my user-table looks like this:
mysql> select host,user,pa
> From: Lucio Chiappetti
>
> On Tue, 7 Apr 2015, shawn l.green wrote:
>
>> The advantage to using temporary tables is that they can have indexes on
>> them. You can create the indexes when you create the table or you can ALTER
>> the table later to add them.
>
On Tue, 7 Apr 2015, shawn l.green wrote:
Temporary tables are going to become your very good friends.
yes I do use temporary tables a lot
The advantage to using temporary tables is that they can have indexes on
them. You can create the indexes when you create the table or you can
ALTER the
On 4/7/2015 4:12 PM, Rajeev Prasad wrote:
hello Masters,
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in
a way, so that user can fire more SQL searches on this result
W dniu 07.04.2015 o 22:12, Rajeev Prasad pisze:
1million plus row in a table.
user runs a search, gets some results.
MySQL comes with query-cache, once you run your SELECT statement the
results are kept in memory. Try it by running big query and then rerun
it, the second time it will take
hello Masters,
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in
a way, so that user can fire more SQL searches on this result. How is this
done? I want this to go atleast
en adding new milestones.
<<<<<<<<
Less trouble if there is also a table of milestones: upon each change
(UPDATE?) find out whether in the milestone table there is such a
milestone that OLD.metric < milestone AND milestone <= NEW.metric. If
there are more, I suppose you want
- Original Message -
> From: "Phil"
> Subject: Capturing milestone data in a table
> user_credits where metric1 > $mile and (metric1 - lastupdate) < $mile)
That second where condition is bad. Rewrite it as metric1 < ($mile +
lastupdate). Better yet,
Hi mysql experts,
I feel like I'm missing something.
I'm trying to capture 'milestone' data when users pass certain metrics or
scores. The score data is held on the user_credits table and changes daily.
Currently just over 3M users on the table and their scores can range fr
Hi,
On 10/12/2014 10:09, Johan De Meersman wrote:
Hm. Typo3 is a CMS; I take it the integration you're speaking of is
specific to their support environment, and not part of the CMS?
Correct, TYPO3 is a CMS (also FOSS GPL2+) and the integration is indeed
not part of the CMS. See my other repl
Hi,
On 10/12/2014 09:02, Johan De Meersman wrote:
- Original Message -
From: "Jigal van Hemert"
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicat
- Original Message -
> From: "Johan De Meersman"
> Sent: Wednesday, 10 December, 2014 09:02:45
> Subject: Re: forum vs email [was: Re: table-for-column]
> Hmm. That sounds interesting, I'll have a look. I don't suppose the software
> is
> availabl
- Original Message -
> From: "Jigal van Hemert"
> Subject: Re: forum vs email [was: Re: table-for-column]
>
> On typo3.org there used to be mailing lists only in a distant past.
> Later on newsgroups were set up which communicate with the mailing lists
>
I have been a resident of this list for a very long time. In the early
days, this was the only place to get reliable information about what was
then a relatively obscure database system. Now, local and online bookstores
have shelves full of books, many of them authored by list regulars. We have
exp
Hi,
On 05/12/2014 20:54, Jan Steinman wrote:
From: Johan De Meersman
I've long wanted to - but never quite got around to - write a forum that
integrated a mailing list. Bar mail clients that don't handle list threads
well, it really doesn't seem such a difficult task.
There actually seem to
- Original Message -
> From: "Jan Steinman"
> Subject: Re: forum vs email [was: Re: table-for-column]
> There actually seem to be a lot of these around. I'm on several that send me
> email when there are new forum postings.
Yes, that bit is pretty standard
g bothered by going
through a webbrowser--but I suspect that others prefer not to have an e-mail
client, and prefer to have the freedom to use small, sophisticated gadgets
instead of bigger gadgets that sit on the table, or take most of a lap.
--
MySQL General Mailing List
For list archives: http
> From: Johan De Meersman
>
> I've long wanted to - but never quite got around to - write a forum that
> integrated a mailing list. Bar mail clients that don't handle list threads
> well, it really doesn't seem such a difficult task.
There actually seem to be a lot of these around. I'm on seve
On 2014-12-04 9:56 PM, shawn l.green wrote:
On 12/1/2014 6:09 AM, Johan De Meersman wrote:
- Original Message -
From: "peter brawley"
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of
ours
I mentioned are seeing more vol
- Original Message -
> From: "Shawn Green"
> Subject: Re: table-for-column
>
> My problem is a lack of time. I can monitor the mailing lists or the
> forums but rarely both while still doing my regular job of handling the
> official service requests.
I&#
On 12/1/2014 6:09 AM, Johan De Meersman wrote:
- Original Message -
From: "peter brawley"
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of ours
I mentioned are seeing more volume, while this list and all MySQL fora
are s
- Original Message -
> From: "peter brawley"
> Subject: Re: table-for-column
> I wonder if anyone knows why sites like Stack Overflow and those of ours
> I mentioned are seeing more volume, while this list and all MySQL fora
> are seeing much, much less.
T
On 2014-11-27 9:31 AM, h...@tbbs.net wrote:
2014/11/26 20:06 -0600, Peter Brawley
Why do you call it a hack, you get outta bed on the wrong side?
2014/11/27 14:08 +0100, Johan De Meersman
Doesn't really belong on the list; but I'd love to hear reasonable arguments
why that
concepts, but it's better to understand
> the difference.
The GUI resulted in:
| links | CREATE TABLE `links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`feed_id` int(11) NOT NULL DEFAULT '0',
`link` varchar(767) NOT NULL,
`status` int(11) NOT N
On 14-11-17 01:42 AM, thufir wrote:
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The workbench GUI came up with:
ALTER TABLE `rome_aggregator
On 14-11-17 01:42 AM, thufir wrote:
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The workbench GUI came up with:
ALTER TABLE `rome_aggregator
Hi,
This is an example:
ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid)
REFERENCES customers (custid)
ON DELETE CASCADE
ON UPDATE NO ACTION;
(take from the GUI tool Database Workbench, avoids having to know the syntax
;) )
With regards,
Martijn Tonies
Upscene
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The feed_id field in links should, in fact, be constrained by the foreign
key of feeds with a RESTRICT
On 10/15/2014 11:30 AM, a.sm...@ukgrid.net wrote:
Quoting william drescher :
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in memory
table.
Is this what you are after?
http://dev.mysql.com/doc/refman/5.5/en/replic
Quoting william drescher :
I read the manual forwards and backwards but I can't figure out how
to set it up to replicate everything except the in memory table.
Is this what you are after?
http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_replicate-i
Am 15.10.2014 um 16:33 schrieb william drescher:
Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a memory
table. I have replication running to a remote computer for a hot backup.
I read the manual forwards and backwards but I can't figure out h
Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a
memory table. I have replication running to a remote computer
for a hot backup.
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything excep
Are both instances running the same MySQL version and release? Are they
MASTER and SLAVE, actively replicating? Are the InnoDB configurations
currently running on both servers the same?
--
*WB*
2014-09-06 6:00 GMT-03:00 Ajay Garg :
> Sorry, forgot to specify the engine.
> The table r
Hello Martin,
On 9/7/2014 7:42 PM, Martin Mueller wrote:
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column.
Could one use that for ad hoc and manual annotation of that table? And if so,
could one change its length? Or are there better ways of producing table
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column.
Could one use that for ad hoc and manual annotation of that table? And if so,
could one change its length? Or are there better ways of producing table notes
that are kept with the database, as opposed to Everno
Sorry, forgot to specify the engine.
The table runs on InnoDB backend.
Also, changed the subject to be more specific.
On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote:
> Hi all.
>
>
> We are facing a very strange scenario.
>
> We have two mysql-instances running on the same
when i used mysql as the keystone's backend in openstack ,i found that the
'token' table saved 29 millions record (using myisam as engine,the size of
token.MYD is 100G) and have 4 new token save per second. That result to the
slow query of a token .since of inserting new token
Hi,
I want to access data from an InnoDB table. I know that I can do this using
the corresponding handler and ha_rnd_next() or ha_index_next().
My problem is that the original MySQL code is outperforming my
implementation even on simple projection queries, even though I use the same
functions
Hi Chris,
> -Original Message-
> From: Chris Knipe [mailto:sav...@savage.za.org]
> Sent: Thursday, 24 July 2014 19:18
> To: mysql@lists.mysql.com
> Subject: Avoiding table scans...
>
> mysql> SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
> 78168ea0a9b
>
>
> Try this
>
> SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
> ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
> WHERE ArtNumber>2118806)
>
>
+---+---+
| ArtNumber | MessageID
|
Il 24/07/14 11:57, Chris Knipe ha scritto:
> On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman
> wrote:
>> - Original Message -
>>> From: "Chris Knipe"
>>> To: mysql@lists.mysql.com
>>> Sent: Thursday, 24 July, 2014 11:17:50 AM
&
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Chris Knipe"
>> To: mysql@lists.mysql.com
>> Sent: Thursday, 24 July, 2014 11:17:50 AM
>> Subject: Avoiding table scans...
>>
>> mysql>
- Original Message -
> From: "Chris Knipe"
> To: mysql@lists.mysql.com
> Sent: Thursday, 24 July, 2014 11:17:50 AM
> Subject: Avoiding table scans...
>
> mysql> SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
> 78168ea0a9b3b513a1f2d39b559b406e WH
in set (22.78 sec)
mysql> EXPLAIN SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber > '2118806';
++-+--+---+-
--+-+-+--+--
es MySQL for
all it's examples and explains that it does so because MySQL is a free and
open source version of SQL that's easy to install. But maybe you're right
and they do depart into other syntaxes of SQL. I just don't know where they
got that 'first, second, third, etc'
Hi Tim,
> -Original Message-
> From: Tim Dunphy [mailto:bluethu...@gmail.com]
> Sent: Sunday, 29 June 2014 10:09
> To: Jesper Wisborg Krogh
> Cc: mysql@lists.mysql.com
> Subject: Re: alter table modify syntax error
>
> >
> > The syntax "sixth"
M, Jesper Wisborg Krogh
wrote:
> Hi Tim,
>
> > -Original Message-
> > From: Tim Dunphy [mailto:bluethu...@gmail.com]
> > Sent: Sunday, 29 June 2014 03:45
> > Cc: mysql@lists.mysql.com
> > Subject: Re: alter table modify syntax error
> >
> > Hey guys
Hi Tim,
> -Original Message-
> From: Tim Dunphy [mailto:bluethu...@gmail.com]
> Sent: Sunday, 29 June 2014 03:45
> Cc: mysql@lists.mysql.com
> Subject: Re: alter table modify syntax error
>
> Hey guys,
>
> Sorry to hit you with one more. But I'm tryi
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional
statement in a column move based on what you all just taught me:
mysql> alter table modify column color varchar(10) sixth;
But I am getting this error:
ERROR 1064 (42000): You have an error in your SQL synta
Cool guys, that did it..
ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;
For some reason the book I'm following doesn't specify that you have to
note the data type in moves! This helped. and thanks again.
Tim
On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen
wr
On 28-06-2014 19:11, Tim Dunphy wrote:
Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql> describe car_table;
+-+--+--+-+-++
| Field | Typ
Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql> describe car_table;
+-+--+--+-+-++
| Field | Type | Null | Key | Default
Hi!
On Fri, Jun 13, 2014 at 3:59 AM, yoku ts. wrote:
> Hi,
>
> Would you try STRAIGHT_JOIN?
>
> mysql56> ALTER TABLE masik DROP KEY idx_test, ADD KEY idx_test(szam, id);
> Query OK, 0 rows affected (0.08 sec)
> Records: 0 Duplicates: 0 Warnings: 0
>
> mysql56>
Hi,
Would you try STRAIGHT_JOIN?
mysql56> ALTER TABLE masik DROP KEY idx_test, ADD KEY idx_test(szam, id);
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql56> EXPLAIN SELECT e.id FROM masik m STRAIGHT_JOIN egyik e ON e.id=
m.id WHERE e.duma= 'aa
er by and check the output.
Thank you, I know, without order no problem:
(root@localhost) [test]> explain select e.id from egyik e,masik m
where e.id=m.id and e.duma='aaa';
+--+-+---+--+---+---+-+---+--+-
s some time
sorting the result set. Also, create a temporary table with the rows
prevously. This is the reason.
Regards,
Antonio.
Hi!
I have two tables:
CREATE TABLE `egyik` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`duma` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `e_idx` (`duma`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `egyik` VALUES (1,'aaa'),(2,'bbb&#
Hi
Run mysql_upgrade command at OS shell
DK Sent from Phone
> On 28-May-2014, at 1:40 pm, "Lentes, Bernd"
> wrote:
>
> Hi,
>
> we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
> access one particular table.
> Automysqlba
- Original Message -
> From: "Bernd Lentes"
> To: mysql@lists.mysql.com
> Sent: Wednesday, 28 May, 2014 10:10:33 AM
> Subject: access problem for a particular table
>
> we just migrated from 5.0 to 5.5. Nearly everything went well. But we can
Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command
denied to user 'backup'@'localhost' for table 'cond_instances' when
I APOLOGIZE for unwilling spamming this list!
i switched to plain text, and the formatting is still messed up when i paste
from sublime.
Background information:
i have a 35 GB sized table which is causing performance issue, which is why i
decided to add partitioning by month using the
Excuse me , and thanks for the heads up.
I know a couple of things, but table partitioning isn't one of them.
i have a 35 GB sized table which is causing performance issues, my research
came across partitioning, which is what i tried and failed with today.
i tried altering the table,
Hi there,
Le 23/05/2014 21:06, Roland RoLaNd a écrit :
> [...]
Ouch
This post is somewhat ... unreadable !
Please format !
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I know a couple of things, but table partitioning isn't one of them. i have a
35 GB sized table which is causing performance issues, my research came across
partitioning, which is what i tried and failed with today. i tried altering the
table, that kept going for 2 hours with absolute
On Thu, May 15, 2014 at 11:01 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Larry Martell"
>> Subject: Re: Performance boost by splitting up large table?
>>
>> This table is queried based on requests from the users. There are 10
- Original Message -
> From: "Larry Martell"
> Subject: Re: Performance boost by splitting up large table?
>
> This table is queried based on requests from the users. There are 10
> different lookup columns they can specify, and they can provide any or
That
t; Hard to say more without actual use cases, of course, but it's well worth
> looking into as it requires no other changes in application or schema.
This table is queried based on requests from the users. There are 10
different lookup columns they can specify, and they can provide any or
all
You've already had some good advice, but there's something much more simpler
that will also give you a significant boost: a covering index.
Simply put, the engine is smart enough to not bother with row lookups if
everything you asked for is already in the index it was using. You'll need to
kee
On 5/14/2014 3:45 PM, shawn l.green wrote:
Hello Bruce,
On 5/14/2014 2:11 PM, Bruce Ferrell wrote:
OK, put away the flamethrowers, I KNOW it's dumb.
I've been asked for the upteenth time is this possible and if so under
what conditions?
So I pose the question to the community, is it? Under
Hello Bruce,
On 5/14/2014 2:11 PM, Bruce Ferrell wrote:
OK, put away the flamethrowers, I KNOW it's dumb.
I've been asked for the upteenth time is this possible and if so under
what conditions?
So I pose the question to the community, is it? Under what conditions?
Is it reliable or not?
Are t
As far as I know, the only way this is possible is if your entire
database is formatted as MyISAM. In that case, multiple MySQL
processes, each started with external-locking enabled, may safely
share a data folder. The contention will almost certainly kill you as
far as performance goes.. and i
OK, put away the flamethrowers, I KNOW it's dumb.
I've been asked for the upteenth time is this possible and if so under what
conditions?
So I pose the question to the community, is it? Under what conditions? Is it
reliable or not?
Are there authoritative references to support the answers?
Hi Larry,
On May 14, 2014, at 5:05 AM, Larry Martell wrote:
> We have a table with 254 columns in it. 80% of the time, a very small
> subset of these columns are queried. The other columns are rarely, if
> ever, queried. (But they could be at any time, so we do need to
> maintain t
Hi,
You could split the table into two and can avoid code changes by creating a
view which matches what code is looking for.
I think loading few fields vs 254 into memory will make a difference but if
your select statement only have specific fields you want and not the whole
row (and also given
We have a table with 254 columns in it. 80% of the time, a very small
subset of these columns are queried. The other columns are rarely, if
ever, queried. (But they could be at any time, so we do need to
maintain them.). Would I expect to get a marked performance boost if I
split my table up into
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
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 fil
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
1 - 100 of 9313 matches
Mail list logo
