全部博文(87)
发布时间:2014-05-23 10:12:45
pt-query-digest处理MySQL的慢查询日志和存储历史审查趋势分析到query_review_history表。 Query-Digest-UI一个非常简单和直接的工具,浏览和统计Mysql慢查询,基于AJAX的Web界面。......【阅读全文】
发布时间:2014-05-22 10:12:12
http://www.zrwm.com/?p=7654InnoDB: Error: Table “mysql”.”innodb_table_stats” not found.MySQL 5.6的ibdata1表空间包含了5个InnoDB基础表,如下:mysql> select table_name from information_schema.tables where table_schema='mysql' and engine='InnoDB';+----------------------+| table_name .........【阅读全文】
发布时间:2014-05-20 15:06:08
#No.14 ##################################################################################check mysqlusersmysql -uroot -peoqkr -e "select CONCAT(user,'@',host),password from mysql.user order by user,host;" #!/bin/bashecho checking db ....for ip in `cat ip_db.txt`doecho $ip.........【阅读全文】
发布时间:2014-05-19 17:13:04
mysql> show slave status;+----------------------------------+---------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+------------.........【阅读全文】