+---------------+---------------------+1 row in set (0.00 sec)
[root@localhost mysql]# tailf /var/log/mysqld.log
2017-08-07T12:32:54.258884Z 0 [Note] IPv6 is available.
2017-08-07T12:32:54.258892Z 0 [Note] - '::' resolves to '::';
2017-08-07T12:32:54.258908Z 0 [Note] Server socket created on IP: '::'.
2017-08-07T12:32:54.259622Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-08-07T12:32:54.260814Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170807 8:32:54
2017-08-07T12:32:54.266749Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2017-08-07T12:32:54.266772Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-08-07T12:32:54.266774Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-08-07T12:32:54.318211Z 0 [Note] End of list of non-natively partitioned tables
以上就是MySQL中error_log介绍的详细内容,更多请关注php中文网其它相关文章!
学习教程快速掌握从入门到精通的SQL知识。
……