ɹ.Z42-5VOFS -------- Recommendations ----------------------------- General recommendations: Enable the slow query log to troubleshoot bad queries Set thread_cache_size to 4 as a starting value Variables to adjust: query_cache_size (>= 8M) thread_cache_size (start at 4) innodb_file_per_table=ON innodb_buffer_pool_size (>= 12G) if possible. innodb_log_file_size should be equals to 1/4 of buffer pool size (=128M) if possible. ⾣࣮ߦ݁Ռ
ɹ҉తͳଐੑ༩ඇਪ ⾣UJNFTUBNQܕ [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use —explicit_defaults_for_timestamp server option (see documentation for more details).
ɹ҉తͳଐੑ༩ඇਪ ⾣UJNFTUBNQܕ [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use —explicit_defaults_for_timestamp server option (see documentation for more details). ͍ΘΏΔθϩλΠϜελϯϓ ‘0000-00-00 00:00:00’
ɹ҉తͳଐੑ༩ඇਪ ⾣ྫɿUJNFTUBNQܕ [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use —explicit_defaults_for_timestamp server option (see documentation for more details). ͍ΘΏΔθϩλΠϜελϯϓ ‘0000-00-00 00:00:00’ ҉తͳଐੑ༩Ͱ ҙਤ͠ͳ͍ʹͳΔ
ɹ҉తͳଐੑ༩ඇਪ [mysqld] # timestampܕͷ҉తͳσϑΥϧτ explicit_defaults_for_timestamp = ON ⾣ઃఆ ⾣֬ೝ mysql> show variables like 'explicit_defaults_for_timestamp'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | explicit_defaults_for_timestamp | ON | +---------------------------------+-------+ 1 row in set (0.00 sec)