Original post: http://anothermysqldba.blogspot.com/2014/05/mysql-error-1118-42000-mysql-50-to.html
所以,我最近有一個TB的數據庫,我不得不從MySQL 5.0升級到MySQL 5.5。
本博客文章將涉及以下內容:
- SQL_MODE
- innodb_strict_mode
- SLAVE IO_THREAD
在mysql_upgrade過程(其中做了mysqlcheck的),我很快發現了以下錯誤:
ERROR 1118 (42000) at line 23: Row size too large (>
8126). Changing some columns to TEXT or BLOB or using
ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current
row format, BLOB prefix of 768 bytes is stored
inline.
於是我開始,我不得不先檢查幾件事情。
# The master DB was > select @@sql_mode;
…