摘要：原文地址：http://www.mysqlperformanceblog.com/2013/03/14/mysql-5-6-10-optimizer-limitations-index-condition-pushdown/While preparingthe webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the s 阅读全文

摘要：原文地址：http://www.mysqlperformanceblog.com/2013/02/01/implications-of-metadata-locking-changes-in-mysql-5-5/While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2010/12/09/thinking-about-running-optimize-on-your-innodb-table-stop/Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so usin 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2011/11/29/innodb-vs-mysql-index-counts/I had a customer recently who a few strange errors in their mysqld.err log:最近在一个客户的错误日志里面发现一些奇怪的错误[ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/03/23/best-kept-mysqldump-secret/Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entire 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/12/21/be-productive-with-the-mysql-command-line/Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice to know a few tips that can really make your work easier.即使你 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2013/01/21/fun-with-the-mysql-pager-command/Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager.The most common usage of pager is to set it to a Unix pager such as less. 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2013/02/11/unexpected-problem-with-triggers-and-mysqldump/Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edi 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/03/21/troubleshooting-mysql-memory-usage/ 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/11/28/replication-of-the-now-function-also-time-travel/Notice the result of the NOW() function in the following query. The query was run on a real database server and I didn’t change the clock of the server or change anything in the database configuratio 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/11/19/concatenating-myisam-files/（读完这篇文章，我很开心的笑了，原来MYSQL还能这么玩，作者你真牛逼，我服你了）Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/02/17/the-relationship-between-innodb-log-checkpointing-and-dirty-buffer-pool-pages/This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it ha 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/10/08/measuring-the-amount-of-writes-in-innodb-redo-logs/Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the redo logs. You can find a detailed explanation in this post.选择合适的I 阅读全文

摘要：原文链接：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/ 阅读全文

摘要：原文链接：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 ?有很大一部分客 阅读全文