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;