随笔分类 - MySQL_Trouble_Shooting
摘要：1. 检查my.cnf，看看有没有密码......靠这也算一条啊2. 如果能够重启，首先使用–skip-grant-tables参数重启，然后改密码，再去掉–skip-grant-tables参数重启, 注意–skip-grant-tables的安全问题http://code.openark.org...
阅读全文
摘要：重启MySQL时遇到下边错误InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different sizeInnoDB: 1152 pages (rounded down to MB)InnoDB: than specified in the .cnf file 1216 pages!找到原因是因为给mysql添加数据文件没有正确配置引起，查看一下当前数据文件的大小l# ll -h /usr/local/mysql/data/-rw-rw---- 1 mysql mysql 18M Mar 5 03:01 ibdata
阅读全文
摘要：Labels:MySQL,MySQL_Problem_Solving 今天一早突然系统突然报慢，查了一下是以下语句：6177700 username ip db——name Query 549 Copying to tmp table SELECT ....................原因如下：Copyingto tmp table on disk The tempor...
阅读全文
摘要：1. Monitor:mysql -uroot -ppassword databaseName -e "show full processlist" | grep -v Sleepmysql -uroot -ppassword databaseName -e "show full processlist" | grep -v Sleep | sort -k6rn >sort.tmp //...
阅读全文
摘要：# NOTE: depending on your version of MySQL ## This example is for mysql 5.4Shell> for x in var=`cat mysql.log |grep Connect |awk '{print $2}' |cut -d: -f3`; do echo ${var:2:50} >> out.txt; doneI now have all of the connection ids for the database I want to benchmark. From here I nee
阅读全文
