Recommend 10 special effects involving parameters (collection)

First you need to check the current time zone of mysql, use the time_zone parameter mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | CST | | time_zone | SYS

1. Modify the time zone of MySQL, involving the parameter time_zone

##Introduction: First you need to check the current time zone of MySQL, use the time_zone parameter

2. mysql storage engine optimization parameters

Introduction: MySQL configuration parameter optimization This article comes from Dawson’s study notes, copyright belongs to http://wubx.net/ All MyISAM storage engine optimization involves the following parameters: Key_buffery_size Concurrent_insert = 2 | WAAYS Bulk_insert_buffer_size=8M Myisam_recover_options=FORCE Myisam_recover_threads=1 Myisam_

3. Modify the time zone of MySQL, involving the parameter time_zone_MySQL

##Introduction: Modify the time zone of MySQL , involving the parameter time_zone

4.

Mysql optimization--skip-name-resolve_MySQL

Introduction: the same IDC, There is a DNS server inside the IDC, and reverse resolution is performed on each server's IP, but no reverse resolution is performed on the intranet IP. Therefore, after using skip-name-resolve, the response to mysqlslap request using the intranet address is half as fast. Parameters involved - -skip-name-resolve ,--skip-host-c

[Related Q&A recommendations]:

The above is the detailed content of Recommend 10 special effects involving parameters (collection). For more information, please follow other related articles on the PHP Chinese website!