This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

log_warnings=0 does about nothing in my.ini

Hi, MariaDB 10.4.8 installed under Windows as a service "wampmariadb" In the[wampmariadb] section of the my.ini file, there are, among other things:

log_error="J:/wamp/logs/mariadb.log"
;*** MariaDB does not support the log_error_verbosity system variable added in MySQL 5.7.
;log_warnings=0

There are only three lines less in the log file when logs_warning=0 is not commented:

***********************************************************
************* With ;log_warnings=0 commented **************
InnoDB: using atomic writes.
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: 128 out of 128 rollback segments are active.
[Note] InnoDB: Creating shared tablespace for temporary tables
[Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
[Note] InnoDB: 10.4.8 started; log sequence number 141009; transaction id 21
[Note] InnoDB: Loading buffer pool(s) from g:\wwwbases\maria32_104\ib_buffer_pool
---> [Note] Plugin 'FEEDBACK' is disabled.
[Note] InnoDB: Buffer pool(s) load completed at 191007 15:03:15
[Note] Server socket created on IP: '::'.
---> [Note] Reading of all Master_info entries succeeded
---> [Note] Added new Master_info '' to hash table
[Note] wampmariadb: ready for connections.
Version: '10.4.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
[Note] wampmariadb (initiated by: unknown): Normal shutdown
[Note] Event Scheduler: Purging the queue. 0 events
[Note] InnoDB: FTS optimize thread exiting.
[Note] InnoDB: Starting shutdown...
[Note] InnoDB: Dumping buffer pool(s) to g:\wwwbases\maria32_104\ib_buffer_pool
[Note] InnoDB: Buffer pool(s) dump completed at 191007 15:03:55
[Note] InnoDB: Shutdown completed; log sequence number 141018; transaction id 22
[Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
[Note] wampmariadb: Shutdown complete

***********************************************************
****************** With log_warnings=0 ********************
InnoDB: using atomic writes.
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: 128 out of 128 rollback segments are active.
[Note] InnoDB: Creating shared tablespace for temporary tables
[Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
[Note] InnoDB: 10.4.8 started; log sequence number 141018; transaction id 21
[Note] InnoDB: Loading buffer pool(s) from g:\wwwbases\maria32_104\ib_buffer_pool
[Note] InnoDB: Buffer pool(s) load completed at 191007 15:08:45
[Note] Server socket created on IP: '::'.
[Note] wampmariadb: ready for connections.
Version: '10.4.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
[Note] wampmariadb (initiated by: unknown): Normal shutdown
[Note] Event Scheduler: Purging the queue. 0 events
[Note] InnoDB: FTS optimize thread exiting.
[Note] InnoDB: Starting shutdown...
[Note] InnoDB: Dumping buffer pool(s) to g:\wwwbases\maria32_104\ib_buffer_pool
[Note] InnoDB: Buffer pool(s) dump completed at 191007 15:10:13
[Note] InnoDB: Shutdown completed; log sequence number 141027; transaction id 22
[Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
[Note] wampmariadb: Shutdown complete

In addition, all lines in the log file are fully duplicated in the Windows Event Viewer and this is absolutely useless.

- My first question is: How to really reduce unnecessary information in the log file?

- My second question is: How to remove duplicate and unnecessary entries in the Windows Event Viewer? Thank you.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.