天堂

摘要： 原文链接：http://www.mysqlperformanceblog.com/2012/01/25/how-to-recover-a-single-innodb-table-from-a-full-backup/Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tabl 阅读全文

摘要： 1：数据目录 1 mysql> show global variables like '%datadir'; 3 +---------------+------------------+ 5 | Variable_name | Value | 7 +---------------+------------------+ 9 | datadir | /home/mysqldata/ |11 +---------------+------------------+13 1 row in set (0.00 sec)2：INNODB数据文件。存储INNODB数据,索引<I 阅读全文

摘要： 今天在review 一个SQL的时候，发现即使在列前面有函数操作，查询也能够使用到索引，如下：（OLD）1 mysql> desc SELECT sql_no_cache COUNT(1) FROM Appointment WHERE YEAR(ScheduledDate)=YEAR(NOW()) AND MONTH(ScheduledDate)=MONTH(NOW()); +----+-------------+-------------+-------+---------------+---------------+---------+------+---------+------- 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2012/03/27/innodbs-gap-locks/One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but needs additional precautions to avoid phantom reads and to get a consistent Statement based 阅读全文

摘要： 原文链接：http://www.mysqlperformanceblog.com/2012/09/11/how-to-find-mysql-queries-worth-optimizing/One question I often get is how one can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause the large portion of the load 阅读全文

摘要： #原shell版View Code 1 #!/bin/bash 2 3 # Script Name: mysql_status_check.sh 4 # Description: check mysql servers status 5 # Author: Xinggang Wang - OpsEye.com 6 # Create Date: 2012/3/30 7 8 #获取MySQL所在服务器IP/端口/用户名/密码 9 read -p "Host=" HOST 10 read -p "Port=" PORT 11 read -p "Use 阅读全文