📎 AI Summary:
The thread discusses multiple logs from MySQL's InnoDB storage engine, showing its startup, crash recovery, and buffer pool initialization over several dates in December 2022, which seem to indicate normal operation with no errors. The original poster shares detailed log excerpts to seek guidance or clarification about these logs, while a subsequent user criticizes the lack of context or specific issues in the logs and urges for more detailed information to assist effectively. Overall, the sentiment is that more detailed explanation or questions are needed to provide meaningful assistance.

brijeshh

New Member
Joined
Dec 22, 2022
Messages
1
Thread Author #1
2022-12-17 12:13:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-17 12:13:59 0 [Note] InnoDB: Uses event mutexes
2022-12-17 12:13:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-17 12:13:59 0 [Note] InnoDB: Number of pools: 1
2022-12-17 12:13:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-17 12:13:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-17 12:13:59 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-17 12:13:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-12-17 12:13:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-17 12:13:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-17 12:13:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-17 12:13:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-17 12:13:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-17 12:13:59 0 [Note] InnoDB: Waiting for purge to start
2022-12-17 12:14:00 0 [Note] InnoDB: 10.4.27 started; log sequence number 300297; transaction id 170
2022-12-17 12:14:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-17 12:14:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-17 12:14:00 0 [Note] Server socket created on IP: '::'.
2022-12-19 12:16:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-19 12:16:51 0 [Note] InnoDB: Uses event mutexes
2022-12-19 12:16:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-19 12:16:51 0 [Note] InnoDB: Number of pools: 1
2022-12-19 12:16:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-19 12:16:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-19 12:16:51 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-19 12:16:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=305845
2022-12-19 12:16:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-19 12:16:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-19 12:16:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-19 12:16:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-19 12:16:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-19 12:16:51 0 [Note] InnoDB: Waiting for purge to start
2022-12-19 12:16:51 0 [Note] InnoDB: 10.4.27 started; log sequence number 305854; transaction id 208
2022-12-19 12:16:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-19 12:16:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-19 12:16:51 0 [Note] InnoDB: Buffer pool(s) load completed at 221219 12:16:51
2022-12-19 12:16:51 0 [Note] Server socket created on IP: '::'.
2022-12-20 12:58:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-20 12:58:15 0 [Note] InnoDB: Uses event mutexes
2022-12-20 12:58:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-20 12:58:15 0 [Note] InnoDB: Number of pools: 1
2022-12-20 12:58:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-20 12:58:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-20 12:58:15 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-20 12:58:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=313073
2022-12-20 12:58:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-20 12:58:15 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-20 12:58:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-20 12:58:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-20 12:58:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-20 12:58:15 0 [Note] InnoDB: Waiting for purge to start
2022-12-20 12:58:15 0 [Note] InnoDB: 10.4.27 started; log sequence number 313082; transaction id 235
2022-12-20 12:58:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-20 12:58:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-20 12:58:15 0 [Note] InnoDB: Buffer pool(s) load completed at 221220 12:58:15
2022-12-20 12:58:15 0 [Note] Server socket created on IP: '::'.
2022-12-20 12:58:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-20 12:58:20 0 [Note] InnoDB: Uses event mutexes
2022-12-20 12:58:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-20 12:58:20 0 [Note] InnoDB: Number of pools: 1
2022-12-20 12:58:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-20 12:58:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-20 12:58:20 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-20 12:58:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=313073
2022-12-20 12:58:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-20 12:58:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-20 12:58:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-20 12:58:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-20 12:58:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-20 12:58:20 0 [Note] InnoDB: Waiting for purge to start
2022-12-20 12:58:20 0 [Note] InnoDB: 10.4.27 started; log sequence number 313082; transaction id 235
2022-12-20 12:58:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-20 12:58:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-20 12:58:20 0 [Note] Server socket created on IP: '::'.
2022-12-22 11:25:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-22 11:25:47 0 [Note] InnoDB: Uses event mutexes
2022-12-22 11:25:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-22 11:25:47 0 [Note] InnoDB: Number of pools: 1
2022-12-22 11:25:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-22 11:25:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-22 11:25:47 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-22 11:25:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=347122
2022-12-22 11:25:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-22 11:25:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-22 11:25:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-22 11:25:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-22 11:25:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-22 11:25:47 0 [Note] InnoDB: Waiting for purge to start
2022-12-22 11:25:47 0 [Note] InnoDB: 10.4.27 started; log sequence number 347131; transaction id 344
2022-12-22 11:25:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-22 11:25:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-22 11:25:47 0 [Note] InnoDB: Buffer pool(s) load completed at 221222 11:25:47
2022-12-22 11:25:47 0 [Note] Server socket created on IP: '::'.
2022-12-22 16:45:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-22 16:45:46 0 [Note] InnoDB: Uses event mutexes
2022-12-22 16:45:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-22 16:45:46 0 [Note] InnoDB: Number of pools: 1
2022-12-22 16:45:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-22 16:45:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-22 16:45:46 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-22 16:45:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=347122
2022-12-22 16:45:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-22 16:45:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-22 16:45:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-22 16:45:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-22 16:45:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-22 16:45:46 0 [Note] InnoDB: Waiting for purge to start
2022-12-22 16:45:46 0 [Note] InnoDB: 10.4.27 started; log sequence number 347131; transaction id 344
2022-12-22 16:45:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-22 16:45:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-22 16:45:46 0 [Note] InnoDB: Buffer pool(s) load completed at 221222 16:45:46
2022-12-22 16:45:46 0 [Note] Server socket created on IP: '::'.
2022-12-22 16:46:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-22 16:46:10 0 [Note] InnoDB: Uses event mutexes
2022-12-22 16:46:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-22 16:46:10 0 [Note] InnoDB: Number of pools: 1
2022-12-22 16:46:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-22 16:46:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-22 16:46:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-22 16:46:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=347156
2022-12-22 16:46:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-22 16:46:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-22 16:46:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-22 16:46:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-22 16:46:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-22 16:46:10 0 [Note] InnoDB: Waiting for purge to start
2022-12-22 16:46:10 0 [Note] InnoDB: 10.4.27 started; log sequence number 347165; transaction id 344
2022-12-22 16:46:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-22 16:46:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-22 16:46:10 0 [Note] Server socket created on IP: '::'.
2022-12-22 16:46:10 0 [Note] InnoDB: Buffer pool(s) load completed at 221222 16:46:10
2022-12-22 16:48:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-22 16:48:39 0 [Note] InnoDB: Uses event mutexes
2022-12-22 16:48:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-22 16:48:39 0 [Note] InnoDB: Number of pools: 1
2022-12-22 16:48:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-22 16:48:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-22 16:48:39 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-22 16:48:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=347174
2022-12-22 16:48:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-22 16:48:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-22 16:48:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-22 16:48:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-22 16:48:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-22 16:48:39 0 [Note] InnoDB: Waiting for purge to start
2022-12-22 16:48:39 0 [Note] InnoDB: 10.4.27 started; log sequence number 347183; transaction id 344
2022-12-22 16:48:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-22 16:48:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-22 16:48:39 0 [Note] Server socket created on IP: '::'.
2022-12-22 16:50:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-22 16:50:58 0 [Note] InnoDB: Uses event mutexes
2022-12-22 16:50:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-22 16:50:58 0 [Note] InnoDB: Number of pools: 1
2022-12-22 16:50:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-22 16:50:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-12-22 16:50:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-22 16:50:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=347192
2022-12-22 16:50:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-12-22 16:50:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-22 16:50:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-22 16:50:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-22 16:50:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-12-22 16:50:58 0 [Note] InnoDB: Waiting for purge to start
2022-12-22 16:50:59 0 [Note] InnoDB: 10.4.27 started; log sequence number 347201; transaction id 344
2022-12-22 16:50:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-22 16:50:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-22 16:50:59 0 [Note] Server socket created on IP: '::'.
 

Solution
Dumping a log and not providing any detail is not really helpful. Plus there are no errors in the log dump, so I suggest providing more detail.

Neemobeer

Windows Forum Team
Staff member
Joined
Jul 4, 2015
Messages
8,995
Dumping a log and not providing any detail is not really helpful. Plus there are no errors in the log dump, so I suggest providing more detail.
 

Solution