摘要:
原文链接: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/ 阅读全文
摘要:
今天群里一朋友爆出这么一个错误(show slave status)Last_Error: Column 0 of table 'mydb.t' cannot be converted from type 'mediumint' to type 'int(10) unsigned'环境是master-slave,原表的字段类型是'mediumint',发现用尽后想扩充数据类型,改成INT类型,先在slave上把字段类型修改到int,再把APP切换到SALVE,再修改MASTER。这也是大表DDL的常见操作流程。分析一下slave 阅读全文
摘要:
表结构:mysql> desc PLUGINDATA;+--------------+--------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+--------------+--------------+------+-----+---------+-------+| PLUGINDATAID | bigint(20) | NO | PRI | NULL | || PLUGINKEY | varchar(... 阅读全文
摘要:
原文链接: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 阅读全文