Jump to content

XAMPP - MySQL shutdown unexpectedly


ramiwahdan

Recommended Posts

When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working:

12:19:12 PM [mysql] Attempting to start MySQL app...
12:19:12 PM [mysql] Status change detected: running
12:19:13 PM [mysql] Status change detected: stopped
12:19:13 PM [mysql] Error: MySQL shutdown unexpectedly.
12:19:13 PM [mysql] This may be due to a blocked port, missing dependencies,
12:19:13 PM [mysql] improper privileges, a crash, or a shutdown by another method
12:19:13 PM [mysql] Press the Logs button to view error logs and check
12:19:13 PM [mysql] the Windows Event Viewer for more clues
12:19:13 PM [mysql] If you need more help, copy and post this
12:19:13 PM [mysql] entire log window on the forums

Here is the contents of the error log:

error log:

InnoDB: using atomic writes.
2020-03-17  2:25:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17  2:25:06 0 [Note] InnoDB: Uses event mutexes
2020-03-17  2:25:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17  2:25:06 0 [Note] InnoDB: Number of pools: 1
2020-03-17  2:25:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17  2:25:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17  2:25:06 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17  2:25:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1442641
2020-03-17  2:25:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17  2:25:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-17  2:25:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17  2:25:06 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17  2:25:06 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17  2:25:06 0 [Note] InnoDB: Waiting for purge to start
2020-03-17  2:25:07 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442650; transaction id 5151
2020-03-17  2:25:07 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17  2:25:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17  2:25:07 0 [Note] InnoDB: Buffer pool(s) load completed at 200317  2:25:07
2020-03-17  2:25:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-03-17 11:30:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:30:50 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:30:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:30:50 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:30:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:30:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:30:50 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:30:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1442659
2020-03-17 11:30:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:30:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-17 11:30:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:30:51 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:30:51 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:30:51 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:30:51 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442668; transaction id 5151
2020-03-17 11:30:51 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:30:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:30:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:30:51
2020-03-17 11:30:51 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-03-17 11:34:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:34:35 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:34:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:34:35 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:34:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:34:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:34:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:34:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:34:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:34:35 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:34:35 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:34:35 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:34:35 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442677; transaction id 5151
2020-03-17 11:34:35 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:34:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:34:35 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:34:35 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:34:35
InnoDB: using atomic writes.
2020-03-17 11:34:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:34:41 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:34:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:34:41 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:34:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:34:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:34:41 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:34:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:34:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:34:41 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:34:41 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:34:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:34:41 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442686; transaction id 5151
2020-03-17 11:34:41 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:34:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:34:41 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:34:41 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:34:41
InnoDB: using atomic writes.
2020-03-17 11:34:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:34:59 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:34:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:34:59 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:34:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:34:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:34:59 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:34:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:34:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:34:59 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:34:59 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:34:59 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:34:59 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442695; transaction id 5151
2020-03-17 11:34:59 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:34:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:34:59 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:34:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:34:59
InnoDB: using atomic writes.
2020-03-17 11:35:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:35:19 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:35:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:35:19 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:35:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:35:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:35:19 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:35:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:35:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:35:19 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:35:19 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:35:19 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:35:19 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442704; transaction id 5151
2020-03-17 11:35:19 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:35:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:35:19 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:35:19 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:35:19
InnoDB: using atomic writes.
2020-03-17 11:35:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:35:38 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:35:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:35:38 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:35:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:35:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:35:38 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:35:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:35:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:35:38 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:35:38 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:35:38 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:35:38 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442713; transaction id 5151
2020-03-17 11:35:38 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:35:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:35:38 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:35:38 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:35:38
InnoDB: using atomic writes.
2020-03-17 11:35:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:35:40 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:35:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:35:40 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:35:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:35:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:35:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:35:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:35:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:35:40 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:35:40 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:35:40 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:35:40 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442722; transaction id 5151
2020-03-17 11:35:40 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:35:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:35:40 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:35:40 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:35:40
InnoDB: using atomic writes.
2020-03-17 11:36:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:36:43 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:36:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:36:43 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:36:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:36:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:36:43 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:36:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:36:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:36:43 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:36:43 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:36:43 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:36:43 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442731; transaction id 5151
2020-03-17 11:36:43 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:36:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:36:43 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:36:43 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:36:43
InnoDB: using atomic writes.
2020-03-17 11:37:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:37:38 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:37:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:37:38 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:37:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:37:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:37:38 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:37:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:37:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:37:39 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:37:39 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:37:39 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:37:39 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442740; transaction id 5151
2020-03-17 11:37:39 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:37:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:37:39 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:37:39
2020-03-17 11:37:39 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-03-17 11:38:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:38:26 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:38:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:38:26 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:38:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:38:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:38:26 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:38:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:38:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:38:26 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:38:26 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:38:26 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:38:26 0 [Note] InnoDB: 10.4.11 started; log sequence number 1442749; transaction id 5151
2020-03-17 11:38:26 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:38:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:38:26 0 [Note] Server socket created on IP: '::'.
2020-03-17 11:38:26 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:38:26
InnoDB: using atomic writes.
2020-03-17 11:42:40 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-03-17 11:42:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:42:40 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:42:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:42:40 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:42:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:42:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:42:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:42:40 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-03-17 11:42:40 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibdata1' size is now 10 MB.
2020-03-17 11:42:40 0 [Note] InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2020-03-17 11:42:40 0 [Note] InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2020-03-17 11:42:40 0 [Note] InnoDB: Renaming log file E:\xampp\mysql\data\ib_logfile101 to E:\xampp\mysql\data\ib_logfile0
2020-03-17 11:42:40 0 [Note] InnoDB: New log files created, LSN=11452
2020-03-17 11:42:40 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-03-17 11:42:40 0 [Note] InnoDB: Doublewrite buffer created
2020-03-17 11:42:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:42:40 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-03-17 11:42:40 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-03-17 11:42:40 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-03-17 11:42:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:42:40 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:42:40 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:42:40 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:42:40 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-03-17 11:42:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:42:40 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-03-17 11:42:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-17 11:42:48 0 [Note] InnoDB: Uses event mutexes
2020-03-17 11:42:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-17 11:42:48 0 [Note] InnoDB: Number of pools: 1
2020-03-17 11:42:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-17 11:42:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-17 11:42:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:42:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-17 11:42:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-17 11:42:48 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-17 11:42:48 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-17 11:42:48 0 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:42:48 0 [Note] InnoDB: 10.4.11 started; log sequence number 47055; transaction id 9
2020-03-17 11:42:48 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-03-17 11:42:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:42:48 0 [Note] InnoDB: Buffer pool(s) load completed at 200317 11:42:48
2020-03-17 11:42:48 0 [Note] Server socket created on IP: '::'.

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.