如何在mariadb错误日志中禁用note log?

axr492tv  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(209)

我使用的是centos 7.3和mariadb 10.3。
当我 cat /var/log/mariadb-error.log ,我发现了很多 note 具体如下:

2018-10-16 15:07:30 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-10-16 15:07:30 0 [Note] InnoDB: Waiting for purge to start
2018-10-16 15:07:30 0 [Note] InnoDB: 10.3.10 started; log sequence number 1630842; transaction id 21
2018-10-16 15:07:30 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-10-16 15:07:30 0 [Note] InnoDB: Buffer pool(s) load completed at 181016 15:07:30
2018-10-16 15:07:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-16 15:07:30 0 [Warning] 'proxies_priv' entry '@% root@localhost.localdomain' ignored in --skip-name-resolve mode.
2018-10-16 15:07:30 0 [Note] Reading of all Master_info entries succeded
2018-10-16 15:07:30 0 [Note] Added new Master_info '' to hash table
2018-10-16 15:07:30 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.10-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 0  MariaDB Server

我有以下问题:
1.如何禁用 [Note] 零件,其实我只需要 [Error] ?
2.日志文件的结尾是 port: 0 MariaDB Server ,因为端口应该是3306,所以有问题吗。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题