摘要：1.schema层面变更 ALTER DATABASE XXXX_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 2.表层面变更 ALTER TABLE XXXXX_TBL CONVERT TO CHARACTER SET utf8mb4 C 阅读全文

摘要：参数大全 https://blog.csdn.net/zhou920786312/article/details/123354503 自用备份单个表结构 mysqldump -unt -proot --host=localhost -B xxxx_db --tables xxx_tbl --no-d 阅读全文

摘要：计算脏页比例 select VARIABLE_VALUE into @a from performance_schema.global_status where VARIABLE_NAME = 'Innodb_buffer_pool_pages_dirty'; select VARIABLE_VAL 阅读全文