发布时间：2014-06-27 16:10:44
140627 15:51:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.140627 15:44:34 mysqld_safe Starting mysqld daemon with databases from /app/mysql/data/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist140627 15:44:34 [ERROR] Can't open the mysql.plugi.........【阅读全文】
发布时间：2014-06-26 16:04:23
0 MySQL Binlog(异常)——mysqlbinlog: unknown variable 'default-character-set=utf8'在使用mysqlbinlog分析日志时，报错：/usr/local/mysql/bin/mysqlbinlog: unknown variable 'default-character-set=utf8'原因分析：产生这个问题的原因是因为我在my.cnf中的client选项组中添加了： .........【阅读全文】
发布时间：2014-06-19 11:40:29
长假归来，发现MySQL资料库不能启动，log中下：130120 9:47:16 InnoDB: Started; log sequence number 0 4266237178130120 9:47:16 [Note] Event Scheduler: Loaded 0 events130120 9:47:16 [Note] /usr/libexec/mysqld: ready for connections.Version: '5.1.52' socket: '/var/lib/my.........【阅读全文】
发布时间：2014-05-28 11:29:06
mysqlduup 和single-transaction 和master-data这两个参数配合着使用。即： mysqldump --single-transaction --master-data=2 一、single-transaction 官方解释，如下： .........【阅读全文】
发布时间：2014-05-28 11:17:15
SELECT COUNT(a.price),a.price ,SUM(a.price) FROM chronicle.GAIA_MST_PURCHASE_ITEM_DATA a LEFT JOIN chronicle.GAIA_PURCHASE_IOS_HISTORY b on b.purchase_item_data_id=a.purchase_item_data_id .........【阅读全文】
