Mysql报错[Warning] TIMESTAMP with implicit DEFAULT value is deprecated和Buffered warning: Changed limits
报错
2019-04-24 12:06:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-04-24 12:06:46 0 [Note] /usr/sbin/mysqld (mysqld 5.6.43) starting as process 3924 ...
2019-04-24 12:06:46 3924 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2019-04-24 12:06:46 3924 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
方法1
编辑/etc/security/limits.conf，加上下面2行
mysql hard nofile 65535
mysql soft nofile 65535
编辑/usr/lib/systemd/system/mysqld.service,加上下面1行
LimitNOFILE=65535
然后
systemctl daemon-reload
systemctl restart mysqld.service
进入mysql操作
mysql> show variables like '%file%';
如有| open_files_limit | 65535
则解决。
方法2（若方法1未能解决）
mkdir /etc/systemd/system/mysqld.service.d
touch limits.conf
加上
[Service]
LimitNOFILE = 65535
然后
systemctl daemon-reload
systemctl restart mysqld
进入mysql操作
mysql> show variables like '%file%';
如有| open_files_limit | 65535
则解决。
