基础命令 查看mysql配置 show variables like '%innodb_buffer_pool%' 修改mysql配置 set global innodb_buffer_pool_size = 值 优化查询速度 set global innodb_buffer_pool_size = 536870912 优化插入和更新速度 set global innodb_flush_log_at_trx_commit = 2; set global sync_binlog=1000;