1 案例1:MySQL性能优化
1.1 问题
练习相关优化选项
启用慢查询日志
查看各种系统变量、状态变量
1.2 步骤
实现此案例需要按照如下步骤进行。
步骤一:mysql性能优化
1)查看服务运行时的参数配置
mysql> show variables\G;
......
*************************** 171. row ***************************
Variable_name: innodb_log_file_size
Value: 50331648
*************************** 172. row ***************************
Variable_name: innodb_log_files_in_group
Value: 2
*************************** 173. row ***************************
Variable_name: innodb_log_group_home_dir
Value: ./
*************************** 174. row ***************************
Variable_name: innodb_log_write_ahead_size
Value: 8192
*************************** 175. row ***************************
Variable_name: innodb_lru_scan_depth
Value: 1024
*************************** 176. row ***************************
Variable_name: innodb_max_dirty_pages_pct
Value: 75.000000
*************************** 177. row ***************************
Variable_name: innodb_max_dirty_pages_pct_lwm
Value: 0.000000
*************************** 178. row ***************************
Variable_name: innodb_max_purge_lag
Value: 0
......
mysql> show variables like "%innodb%";
+------------------------------------------+------------------------+
| Variable_name | Value |
+------------------------------------------+------------------------+
| ignore_builtin_in