天堂

摘要： 原文链接：http://www.mysqlperformanceblog.com/2011/09/02/understand-innodb-spin-waits-win-a-percona-live-ticket/It’s Friday again (so soon!) and time for our TGIF contest, to give away a free ticket to Percona Live London. Before we do that, though, just what in the world does this output from SHOW INNOD 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/Peter wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post actually kind of talks about a lot of things and then doesn’t tell you how to choose a 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2011/12/16/statement-based-replication-with-stored-functions-triggers-and-events/Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it as a PITR recovery. Here we will see what is the beh 阅读全文

摘要： 很老的一篇博文了，07年的原文链接：http://www.mysqlperformanceblog.com/2007/05/09/how-to-estimate-time-it-takes-innodb-to-recover/ 阅读全文

摘要： 在实际工作中，数据文件被RM -RF掉的情况比较少见，常见的是DROP TABLE ，TRUNCATE TABLE，DELETE FROM TABLE WHERE 1=1;如果遇到了RM掉数据文件时，千万不要慌张，HOLD住，停止所有的操作，保留现场。下面的方法可以找回丢失的数据文件。1：创建测试表，写入数据mysql> create table tt(a int) engine=myisam;Query OK, 0 rows affected (0.13 sec) mysql> insert into tt values(10),(20),(30);Query OK, 3 row 阅读全文

摘要： 原文链接：http://www.mysqlops.com/2012/09/27/mysql%e4%b8%adlike%e8%af%ad%e5%8f%a5%e5%8f%8a%e7%9b%b8%e5%85%b3%e4%bc%98%e5%8c%96%e5%99%a8tips.html背景 MySQL中在对某个字段做包含匹配时可以用like。先看这个结构和结果CREATE TABLE `tb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) DEFAULT NULL, `title` varchar(128) NOT NULL, 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2012/06/06/read_buffer_size-can-break-your-replication/There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allow 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2012/07/24/new-variable-slave_max_allowed_packet-for-slave-servers/One month ago I wrote about how a big read_buffer_size could break the replication. The bug is not solved but now there is an official workaround to ease this problem using a new configuration 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2009/01/12/should-you-move-from-myisam-to-innodb/There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on MyISAM is preferred ?有很大一部分客 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2007/12/09/be-careful-rotating-mysql-logs/If you enable logging of all queries as “slow queries” using thepatchor MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G or more which 阅读全文