ɹ.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).
Slide 240
Slide 240 text
ɹ҉తͳଐੑ༩ඇਪ
⾣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’
Slide 241
Slide 241 text
ɹ҉తͳଐੑ༩ඇਪ
⾣ྫɿ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’
҉తͳଐੑ༩Ͱ
ҙਤ͠ͳ͍ʹͳΔ
Slide 242
Slide 242 text
ɹ҉తͳଐੑ༩ඇਪ
⾣ݟͨ͜ͱ͋Γ·ͤΜ͔ʁ
mysql> SELECT cuntomer_name
-> FROM customers
-> WHERE create_at != ‘0000-00-00 00:00:00’
-> AND create_at < NOW();
Slide 243
Slide 243 text
ɹ҉తͳଐੑ༩ඇਪ
⾣ݟͨ͜ͱ͋Γ·ͤΜ͔ʁ
ҙਤ͠ͳ͍ͱ
Ήͳ͘ରԠ͕૿͑Δ
mysql> SELECT cuntomer_name
-> FROM customers
-> WHERE create_at != ‘0000-00-00 00:00:00’
-> AND create_at < NOW();
ɹ҉తͳଐੑ༩ඇਪ
[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)