Xamp MySQL stop automatically

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Xamp MySQL stop automatically

Postby kajalthakur » 14. March 2021 08:32

InnoDB: using atomic writes.
2021-02-22 10:07:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-22 10:07:31 0 [Note] InnoDB: Uses event mutexes
2021-02-22 10:07:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-22 10:07:31 0 [Note] InnoDB: Number of pools: 1
2021-02-22 10:07:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-22 10:07:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-22 10:07:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-22 10:07:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-02-22 10:07:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-22 10:07:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-22 10:07:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-22 10:07:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-22 10:07:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-22 10:07:32 0 [Note] InnoDB: 10.4.17 started; log sequence number 300297; transaction id 170
2021-02-22 10:07:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-22 10:07:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-22 10:07:32 0 [Note] InnoDB: Buffer pool(s) load completed at 210222 10:07:32
2021-02-22 10:07:32 0 [Note] Server socket created on IP: '::'.
2021-02-23 10:38:57 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 14% 57% 84% 95% 100% (0.0 seconds); tables to flush: 2 1 0
(0.1 seconds);
2021-02-23 10:38:57 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-02-23 10:38:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-23 10:38:57 0 [Note] InnoDB: Uses event mutexes
2021-02-23 10:38:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-23 10:38:57 0 [Note] InnoDB: Number of pools: 1
2021-02-23 10:38:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-23 10:38:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-23 10:38:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-23 10:38:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=309664
2021-02-23 10:38:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-23 10:38:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-23 10:38:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-23 10:38:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-23 10:38:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-23 10:38:58 0 [Note] InnoDB: Waiting for purge to start
2021-02-23 10:38:58 0 [Note] InnoDB: 10.4.17 started; log sequence number 309673; transaction id 210
2021-02-23 10:38:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-23 10:38:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-23 10:38:58 0 [Note] InnoDB: Buffer pool(s) load completed at 210223 10:38:58
2021-02-23 10:38:58 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-02-25 9:42:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-25 9:42:32 0 [Note] InnoDB: Uses event mutexes
2021-02-25 9:42:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-25 9:42:32 0 [Note] InnoDB: Number of pools: 1
2021-02-25 9:42:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-25 9:42:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-25 9:42:32 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-25 9:42:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=318675
2021-02-25 9:42:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-25 9:42:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-25 9:42:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-25 9:42:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-25 9:42:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-25 9:42:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 318684; transaction id 260
2021-02-25 9:42:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-25 9:42:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-25 9:42:33 0 [Note] InnoDB: Buffer pool(s) load completed at 210225 9:42:33
2021-02-25 9:42:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-02-26 10:09:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-26 10:09:22 0 [Note] InnoDB: Uses event mutexes
2021-02-26 10:09:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-26 10:09:22 0 [Note] InnoDB: Number of pools: 1
2021-02-26 10:09:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-26 10:09:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-26 10:09:22 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-26 10:09:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=339648
2021-02-26 10:09:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-26 10:09:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-26 10:09:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-26 10:09:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-26 10:09:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-26 10:09:23 0 [Note] InnoDB: Waiting for purge to start
2021-02-26 10:09:23 0 [Note] InnoDB: 10.4.17 started; log sequence number 339657; transaction id 361
2021-02-26 10:09:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-26 10:09:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-26 10:09:23 0 [Note] InnoDB: Buffer pool(s) load completed at 210226 10:09:23
2021-02-26 10:09:23 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-02-28 20:03:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-28 20:03:31 0 [Note] InnoDB: Uses event mutexes
2021-02-28 20:03:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-28 20:03:31 0 [Note] InnoDB: Number of pools: 1
2021-02-28 20:03:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-28 20:03:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-28 20:03:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-28 20:03:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=340846
2021-02-28 20:03:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-28 20:03:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-28 20:03:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-28 20:03:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-28 20:03:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-28 20:03:31 0 [Note] InnoDB: Waiting for purge to start
2021-02-28 20:03:31 0 [Note] InnoDB: 10.4.17 started; log sequence number 340855; transaction id 388
2021-02-28 20:03:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-28 20:03:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-28 20:03:31 0 [Note] InnoDB: Buffer pool(s) load completed at 210228 20:03:31
2021-02-28 20:03:31 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-01 9:46:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-01 9:46:12 0 [Note] InnoDB: Uses event mutexes
2021-03-01 9:46:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-01 9:46:12 0 [Note] InnoDB: Number of pools: 1
2021-03-01 9:46:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-01 9:46:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-01 9:46:12 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-01 9:46:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=349432
2021-03-01 9:46:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-01 9:46:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-01 9:46:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-01 9:46:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-01 9:46:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-01 9:46:13 0 [Note] InnoDB: 10.4.17 started; log sequence number 349441; transaction id 435
2021-03-01 9:46:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-01 9:46:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-01 9:46:13 0 [Note] InnoDB: Buffer pool(s) load completed at 210301 9:46:13
2021-03-01 9:46:13 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-02 10:04:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-02 10:04:05 0 [Note] InnoDB: Uses event mutexes
2021-03-02 10:04:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-02 10:04:05 0 [Note] InnoDB: Number of pools: 1
2021-03-02 10:04:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-02 10:04:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-02 10:04:05 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-02 10:04:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=362004
2021-03-02 10:04:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-02 10:04:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-02 10:04:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-02 10:04:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-02 10:04:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-02 10:04:06 0 [Note] InnoDB: 10.4.17 started; log sequence number 362013; transaction id 514
2021-03-02 10:04:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-02 10:04:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-02 10:04:06 0 [Note] InnoDB: Buffer pool(s) load completed at 210302 10:04:06
2021-03-02 10:04:06 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-02 15:29:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-02 15:29:32 0 [Note] InnoDB: Uses event mutexes
2021-03-02 15:29:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-02 15:29:32 0 [Note] InnoDB: Number of pools: 1
2021-03-02 15:29:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-02 15:29:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-02 15:29:32 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-02 15:29:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=372330
2021-03-02 15:29:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-02 15:29:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-02 15:29:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-02 15:29:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-02 15:29:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-02 15:29:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 372339; transaction id 578
2021-03-02 15:29:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-02 15:29:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-02 15:29:33 0 [Note] InnoDB: Buffer pool(s) load completed at 210302 15:29:33
2021-03-02 15:29:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-03 9:56:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-03 9:56:30 0 [Note] InnoDB: Uses event mutexes
2021-03-03 9:56:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-03 9:56:30 0 [Note] InnoDB: Number of pools: 1
2021-03-03 9:56:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-03 9:56:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-03 9:56:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-03 9:56:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=374909
2021-03-03 9:56:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-03 9:56:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-03 9:56:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-03 9:56:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-03 9:56:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-03 9:56:31 0 [Note] InnoDB: 10.4.17 started; log sequence number 374918; transaction id 609
2021-03-03 9:56:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-03 9:56:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-03 9:56:31 0 [Note] InnoDB: Buffer pool(s) load completed at 210303 9:56:31
2021-03-03 9:56:31 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-04 17:31:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-04 17:31:06 0 [Note] InnoDB: Uses event mutexes
2021-03-04 17:31:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-04 17:31:06 0 [Note] InnoDB: Number of pools: 1
2021-03-04 17:31:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-04 17:31:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-04 17:31:06 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-04 17:31:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=407771
2021-03-04 17:31:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-04 17:31:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-04 17:31:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-04 17:31:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-04 17:31:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-04 17:31:07 0 [Note] InnoDB: 10.4.17 started; log sequence number 407780; transaction id 737
2021-03-04 17:31:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-04 17:31:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-04 17:31:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210304 17:31:07
2021-03-04 17:31:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-04 20:03:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-04 20:03:50 0 [Note] InnoDB: Uses event mutexes
2021-03-04 20:03:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-04 20:03:50 0 [Note] InnoDB: Number of pools: 1
2021-03-04 20:03:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-04 20:03:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-04 20:03:50 0 [Note] InnoDB: Completed initialization of buffer pool
InnoDB: using atomic writes.
2021-03-04 20:03:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-04 20:03:53 0 [Note] InnoDB: Uses event mutexes
2021-03-04 20:03:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-04 20:03:53 0 [Note] InnoDB: Number of pools: 1
2021-03-04 20:03:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-04 20:03:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-04 20:03:53 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-04 20:03:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=461413
2021-03-04 20:03:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-04 20:03:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-04 20:03:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-04 20:03:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-04 20:03:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-04 20:03:53 0 [Note] InnoDB: 10.4.17 started; log sequence number 461422; transaction id 956
2021-03-04 20:03:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-04 20:03:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-04 20:03:53 0 [Note] InnoDB: Buffer pool(s) load completed at 210304 20:03:53
2021-03-04 20:03:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-04 20:24:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-04 20:24:02 0 [Note] InnoDB: Uses event mutexes
2021-03-04 20:24:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-04 20:24:02 0 [Note] InnoDB: Number of pools: 1
2021-03-04 20:24:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-04 20:24:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-04 20:24:02 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-04 20:24:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=461431
2021-03-04 20:24:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-04 20:24:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-04 20:24:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-04 20:24:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-04 20:24:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-04 20:24:03 0 [Note] InnoDB: 10.4.17 started; log sequence number 461440; transaction id 956
2021-03-04 20:24:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-04 20:24:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-04 20:24:03 0 [Note] InnoDB: Buffer pool(s) load completed at 210304 20:24:03
2021-03-04 20:24:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-05 10:30:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-05 10:30:04 0 [Note] InnoDB: Uses event mutexes
2021-03-05 10:30:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-05 10:30:04 0 [Note] InnoDB: Number of pools: 1
2021-03-05 10:30:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-05 10:30:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-05 10:30:04 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-05 10:30:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=535173
2021-03-05 10:30:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-05 10:30:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-05 10:30:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-05 10:30:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-05 10:30:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-05 10:30:04 0 [Note] InnoDB: 10.4.17 started; log sequence number 535182; transaction id 1165
2021-03-05 10:30:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-05 10:30:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-05 10:30:04 0 [Note] InnoDB: Buffer pool(s) load completed at 210305 10:30:04
2021-03-05 10:30:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-05 17:09:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-05 17:09:39 0 [Note] InnoDB: Uses event mutexes
2021-03-05 17:09:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-05 17:09:39 0 [Note] InnoDB: Number of pools: 1
2021-03-05 17:09:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-05 17:09:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-05 17:09:39 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-05 17:09:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=547736
2021-03-05 17:09:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-05 17:09:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-05 17:09:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-05 17:09:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-05 17:09:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-05 17:09:40 0 [Note] InnoDB: 10.4.17 started; log sequence number 547745; transaction id 1250
2021-03-05 17:09:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-05 17:09:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-05 17:09:40 0 [Note] InnoDB: Buffer pool(s) load completed at 210305 17:09:40
2021-03-05 17:09:40 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-06 20:09:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-06 20:09:01 0 [Note] InnoDB: Uses event mutexes
2021-03-06 20:09:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-06 20:09:01 0 [Note] InnoDB: Number of pools: 1
2021-03-06 20:09:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-06 20:09:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-06 20:09:01 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-06 20:09:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=696730
2021-03-06 20:09:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-06 20:09:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-06 20:09:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-06 20:09:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-06 20:09:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-06 20:09:01 0 [Note] InnoDB: 10.4.17 started; log sequence number 696739; transaction id 1374
2021-03-06 20:09:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-06 20:09:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-06 20:09:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210306 20:09:01
2021-03-06 20:09:01 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-07 15:18:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-07 15:18:19 0 [Note] InnoDB: Uses event mutexes
2021-03-07 15:18:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-07 15:18:19 0 [Note] InnoDB: Number of pools: 1
2021-03-07 15:18:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-07 15:18:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-07 15:18:20 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-07 15:18:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=700620
2021-03-07 15:18:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-07 15:18:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-07 15:18:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-07 15:18:22 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-07 15:18:22 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-07 15:18:22 0 [Note] InnoDB: 10.4.17 started; log sequence number 700629; transaction id 1408
2021-03-07 15:18:22 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-07 15:18:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-07 15:18:22 0 [Note] InnoDB: Buffer pool(s) load completed at 210307 15:18:22
2021-03-07 15:18:22 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-07 19:18:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-07 19:18:05 0 [Note] InnoDB: Uses event mutexes
2021-03-07 19:18:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-07 19:18:05 0 [Note] InnoDB: Number of pools: 1
2021-03-07 19:18:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-07 19:18:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-07 19:18:05 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-07 19:18:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=822638
2021-03-07 19:18:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-07 19:18:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-07 19:18:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-07 19:18:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-07 19:18:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-07 19:18:06 0 [Note] InnoDB: Waiting for purge to start
2021-03-07 19:18:06 0 [Note] InnoDB: 10.4.17 started; log sequence number 822647; transaction id 1493
2021-03-07 19:18:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-07 19:18:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-07 19:18:06 0 [Note] InnoDB: Buffer pool(s) load completed at 210307 19:18:06
2021-03-07 19:18:06 0 [Note] Server socket created on IP: '::'.
2021-03-14 12:26:46 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it

***WARNING: .\mysql\db could not be opened: Error: 126
2021-03-14 12:26:46 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 11% 33% 44% 77% 100% (0.6 seconds); tables to flush: 1 0
(0.3 seconds);
2021-03-14 12:26:46 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-03-14 12:26:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-14 12:26:47 0 [Note] InnoDB: Uses event mutexes
2021-03-14 12:26:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-14 12:26:47 0 [Note] InnoDB: Number of pools: 1
2021-03-14 12:26:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-14 12:26:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-14 12:26:47 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-14 12:26:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=829640
2021-03-14 12:26:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-14 12:26:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-14 12:26:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-14 12:26:52 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-14 12:26:52 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-14 12:26:52 0 [Note] InnoDB: Waiting for purge to start
2021-03-14 12:26:52 0 [Note] InnoDB: Waiting for purge to start
2021-03-14 12:26:52 0 [Note] InnoDB: Waiting for purge to start
2021-03-14 12:26:52 0 [Note] InnoDB: 10.4.17 started; log sequence number 829649; transaction id 1561
2021-03-14 12:26:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-14 12:26:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-14 12:26:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210314 12:26:52
2021-03-14 12:26:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-14 12:34:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-14 12:34:01 0 [Note] InnoDB: Uses event mutexes
2021-03-14 12:34:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-14 12:34:01 0 [Note] InnoDB: Number of pools: 1
2021-03-14 12:34:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-14 12:34:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-14 12:34:01 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-14 12:34:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-14 12:34:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-14 12:34:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-14 12:34:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-14 12:34:06 0 [Note] InnoDB: 10.4.17 started; log sequence number 829667; transaction id 1561
2021-03-14 12:34:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-14 12:34:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-14 12:34:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210314 12:34:07
2021-03-14 12:34:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-03-14 12:49:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-14 12:49:37 0 [Note] InnoDB: Uses event mutexes
2021-03-14 12:49:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-14 12:49:37 0 [Note] InnoDB: Number of pools: 1
2021-03-14 12:49:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-14 12:49:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-14 12:49:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-14 12:49:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-14 12:49:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-14 12:49:41 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-14 12:49:41 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-14 12:49:41 0 [Note] InnoDB: Waiting for purge to start
2021-03-14 12:49:41 0 [Note] InnoDB: Waiting for purge to start
2021-03-14 12:49:41 0 [Note] InnoDB: 10.4.17 started; log sequence number 829676; transaction id 1561
2021-03-14 12:49:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-14 12:49:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-14 12:49:42 0 [Note] InnoDB: Buffer pool(s) load completed at 210314 12:49:42
2021-03-14 12:49:42 0 [Note] Server socket created on IP: '::'.


This is the complete log its showing.....Guide me with the help.
kajalthakur
 
Posts: 1
Joined: 14. March 2021 08:29
XAMPP version: 3.2.4
Operating System: Windows

Re: Xamp MySQL stop automatically

Postby Altrea » 14. March 2021 09:43

Hi,

your log does not contain any helpful messages.
Please try to start MariaDB in the following way and report back, what you get as response:

  • Open your XAMPP control panel
  • click the Shell Button. If you get asked to create the file for the first time, confirm this.
  • Execute the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 169 guests