…a single query takes most of the total response time of the server: that’s typical of a hot spot and this query is a…a new status, you will need to alter the table, which may be difficult if the table…MySQL 3rd edition is a very good book. The online documentation is also a…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… failover and a bunch of other benefits (non-blocking ALTER TABLE, for example). …a lot. Warming up a system so it’s actually responsive can take hours. As a…a long time. To measure how much this really matters, I did some tests for a… used — it could be MySQL Proxy or a TCP sniffer or anything else…
Post: Small things are better
October 8, 2006 By 15 Comments
…, smaller tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables small…, but if alter table takes several days do you really can afford having no box to fall back to for such a long time ? On other…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…Long Queries – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time…_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many tutorials out … how to measure replication lag – MySQL Toolkit has a great tool for real latency …
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…A long running query – Run an ANALYZE TABLE on a table accessed by the long running query So first we need a long running query against table…a write query on InnoDB the rollback process could take even more time…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…takes a lot of discipline and so do not work well for a lot of installations, especially as MySQL…tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb tables…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…MySQL has triggers which can make updates very different. Also there is no way to tell you how ALTER table… take long time In MySQL 5.0 with addition of greedy join the problem on looking at too many table join…is frequent approach to take number of rows estimated from each row in a join and multiply …
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
…time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql> alter table… long blob gets some 50 times smaller 
Also note this less than 1MB blob takes … – allocation happens in 16K pages for a first few pages and when space …
Comment: Is your server's performance about to degrade?
May 24, 2010 By 13 Comments
…. It took me quite a long time to find that DROP/ALTER table on InnoDB tables freezes the whole innodb engine for a few seconds. It’s shorter with small buffer pool, but for 40GB it takes about 2 seconds and the load doesn’t matter. Just look at bugs http://bugs.mysql.com/bug…
Post: Another ingenious piece of Sun Marketing
March 20, 2009 By 20 Comments
… the a large stretch. I would hope Sun/MySQL would tone it down and actually spend time on making things to scale inside MySQL… for replication needs, ALTER TABLE or any long running queries. Do not take it as me saying T5440 is never good for MySQL. It may work quite well for some cases, for example when a…
