…what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What…temporary…MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug to be happening. In…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…in MariaDB 5.5 and not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL…does not actually mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL…Using where; Rowid-ordered scan; Using temporary; Using…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the… at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does …in set (0.00 sec) As result this means single run away select can effectively cause downtime if you use backup solution which does…
Post: What does Using filesort mean in MySQL?
March 5, 2009 By 27 Comments
…you “what does Using filesort mean in EXPLAIN,” what would you say? I have asked this question in …in memory, so it gets sorted on disk.” Unfortunately, this is not the same thing. First of all, this is Using temporary. Secondly, temporary… How MySQL executes ORDER BY. You can also read about it in …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been using before does…MySQL 5.1 with no problems in most cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… couldn’t be rolled back”, which is interesting.) But does that mean it’s safe for replication? There is one good way…, what‘s logged — not what executes on the master — is what‘s important. In summary, I still don’t see any way to use temporary tables with MySQL statement…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…temporary tables which are created on disk. innodb_buffer_pool_size This is very important variable to tune if you’re using…mean…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…Using temporary | +—-+————-+——-+——+—————+——+———+——+———+—————–+ 1 row in set (0.01 sec) As you can see I’m using ORDER BY NULL clause as otherwise MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…meaning of the output, so it’s clear what…::DBI, which does $dbh->ping …I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ |…used to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive operation. In…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
…in memory in all cases (and dictionary table does too). Second – the rows are relatively short in…in fact it is quite expected – This is MyISAM table which is accessed via index, which means to retrieve each row MySQL…: 1439943 Extra: Using temporary; Using filesort *************************** 2. row …
