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. ⾣࣮ߦ݁Ռ
Please use —explicit_defaults_for_timestamp server option (see documentation for more details). ͍ΘΏΔθϩλΠϜελϯϓ ‘0000-00-00 00:00:00’ ҉తͳଐੑ༩Ͱ ҙਤ͠ͳ͍ʹͳΔ
show variables like 'explicit_defaults_for_timestamp'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | explicit_defaults_for_timestamp | ON | +---------------------------------+-------+ 1 row in set (0.00 sec)