[手游项目2]-19-EError=1118, Reason=Row size too large (> 8126)

 show GLOBAL VARIABLES LIKE '%file_format%';
 
 set GLOBAL innodb_file_format = 'Barracuda';
 set GLOBAL innodb_file_format_max = 'Barracuda';
 
 show GLOBAL VARIABLES LIKE '%file_format%';

http://blog.51cto.com/douya/1894891

ALTER TABLE player_table ROW_FORMAT = COMPRESSED;

https://blog.csdn.net/lsjseu/article/details/51887991

mysql -u root -p
show databases;
use game_cq
1.
show variables like '%per_table%';
确定
innodb_file_per_table | ON
如不是以下修改
set GLOBAL innodb_file_per_table = 1; 

2.
show GLOBAL VARIABLES LIKE '%file_format%';
确定
+--------------------------+-----------+
| innodb_file_format       | Barracuda |
| innodb_file_format_check | ON        |
| innodb_file_format_max   | Barracuda |
+--------------------------+-----------+
如不是以下修改
set GLOBAL innodb_file_format = 'Barracuda';
set GLOBAL innodb_file_format_max = 'Barracuda';

3.
show table status like 'player_table';
如不是COMPRESSED 修改行格式，注意如果前二步不对可能修改不成功
ALTER TABLE player_table ROW_FORMAT = COMPRESSED;