Mysql报错[Warning] TIMESTAMP with implicit DEFAULT value is deprecated和Buffered warning: Changed limit...

最新推荐文章于 2023-10-13 09:44:38 发布

weixin_30692143

最新推荐文章于 2023-10-13 09:44:38 发布

阅读量1k

点赞数

原文链接：http://www.cnblogs.com/ccielife/p/10763123.html

版权

报错
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
则解决。

转载于:https://www.cnblogs.com/ccielife/p/10763123.html