tencent cloud

alter table table_name row_format = DYNAMIC;

show table status like 'table_name'\\G;

mysql> show table status like 'table_name'\\G;
*************************** 1. row ***************************
        Name: table_name
      Engine: InnoDB
     Version: 10
  Row_format: Dynamic
        Rows: 5
        ......
1 row in set (0.00 sec)

show variables like '%lower_case_table_names%';

lower_case_table_names = 1

[$Mysql_Dir]/bin/mysqladmin -u root -p shutdown
[$Mysql_Dir]/bin/safe_mysqld &

show variables like '%lower_case_table_names%';

mysql> show variables like '%lower_case_table_names%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+
1 row in set (0.00 sec)

set global max_allowed_packet = 4*1024*1024;

show global variables like '%max_allowed_packet%';

mysql> show global variables like '%max_allowed_packet%';
+------------------------+---------+
| Variable_name          | Value   |
+------------------------+---------+
| max_allowed_packet     | 4194304 |
+------------------------+---------+
1 row in set (0.00 sec)

set global connect_timeout = 10;

show global variables like '%connect_timeout%';

mysql> show global variables like '%connect_timeout%';
+------------------------+---------+
| Variable_name          | Value   |
+------------------------+---------+
| connect_timeout        | 10      |
+------------------------+---------+
1 row in set (0.00 sec)