Permalänk

MYSQL problem i XAMPP

Hej,

mitt EXAMPP program har alltid fungerat tills jag försökte starta på morgonen, när jag startar apache fungerar den utmärkt men MYSQL vägrar starta, får denna felmeddelande:

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

hur fixar jag mitt MYSQL?

tack

Permalänk

2019-08-28 1:10:24 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-08-28 1:10:24 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-08-28 1:10:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:10:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:10:24 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:10:24 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:10:24 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:10:24 0 [Note] InnoDB: 10.3.16 started; log sequence number 0; transaction id 7
2019-08-28 1:10:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:10:24 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:11:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:11:18 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:11:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:11:18 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:11:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:11:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:11:18 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:11:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:11:18 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:11:18 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:11:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:11:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:11:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:11:19 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:11:19 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:11:19 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:11:19 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:11:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:11:19 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:11:19
2019-08-28 1:11:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:11:19 0 [Note] Server socket created on IP: '::'.

Permalänk
Medlem

Hej

Ingen mysql expert, men verkar att det är detta som är fel .:

2019-08-28 1:11:19 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
Denna filen brukar skapas om varje gång servr avslutas eller startas. Men vid en crash eller liknande kvarstår den.

Ta en backup på den filen, kopiera den till desktop eller whatever, sen ta den bort från xammp folder. Sen försöker du starta MYSQL igen.

Kolla vad som händer då.

Visa signatur

Bosna u <3

I7-6700K :-: 16gb DDR4 :-: ASUS 1080TI :-: MSI Gaming Carbon :-: NH-U14S :-: FD R5 :-: Seasonic X 760W

Permalänk
Skrivet av zeleni:

Hej

Ingen mysql expert, men verkar att det är detta som är fel .:

2019-08-28 1:11:19 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
Denna filen brukar skapas om varje gång servr avslutas eller startas. Men vid en crash eller liknande kvarstår den.

Ta en backup på den filen, kopiera den till desktop eller whatever, sen ta den bort från xammp folder. Sen försöker du starta MYSQL igen.

Kolla vad som händer då.

Hej jag gjorde det, inget hände. Jag försöker nu ändra lösen på msql för att sedan ange samma I convig. Men var ser jag lösen på MySQL?

Permalänk

Okej jag provide att byla lösen men det funkade inte heller, någon som vet vad problemet är jag inte kan starta MYSQL?

Igår funkade den utmärkt

Permalänk

2019-08-26 5:13:33 0 [Note] Server socket created on IP: '::'.
2019-08-28 0:52:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 0:52:02 0 [Note] InnoDB: Uses event mutexes
2019-08-28 0:52:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 0:52:02 0 [Note] InnoDB: Number of pools: 1
2019-08-28 0:52:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 0:52:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 0:52:02 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 0:52:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 0:52:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 0:52:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 0:52:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 0:52:06 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 0:52:06 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 0:52:06 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 0:52:06 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 0:52:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 0:52:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 0:52:06 0 [Note] Server socket created on IP: '::'.
2019-08-28 0:53:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 0:53:55 0 [Note] InnoDB: Uses event mutexes
2019-08-28 0:53:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 0:53:55 0 [Note] InnoDB: Number of pools: 1
2019-08-28 0:53:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 0:53:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 0:53:55 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 0:53:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 0:53:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 0:53:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 0:53:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 0:53:55 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 0:53:55 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 0:53:55 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 0:53:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 0:53:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 0:53:55 0 [Note] Server socket created on IP: '::'.
2019-08-28 0:55:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 0:55:57 0 [Note] InnoDB: Uses event mutexes
2019-08-28 0:55:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 0:55:57 0 [Note] InnoDB: Number of pools: 1
2019-08-28 0:55:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 0:55:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 0:55:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 0:55:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 0:56:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 0:56:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 0:56:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 0:56:06 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 0:56:06 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 0:56:06 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 0:56:06 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 0:56:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 0:56:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 0:56:06 0 [Note] Server socket created on IP: '::'.
2019-08-28 0:57:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 0:57:59 0 [Note] InnoDB: Uses event mutexes
2019-08-28 0:57:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 0:57:59 0 [Note] InnoDB: Number of pools: 1
2019-08-28 0:57:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 0:57:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 0:57:59 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 0:57:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 0:57:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 0:57:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 0:57:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 0:57:59 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 0:57:59 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 0:57:59 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 0:58:00 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 0:58:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 0:58:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 0:58:00 0 [Note] Server socket created on IP: '::'.
2019-08-28 0:58:00 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 0:58:00
2019-08-28 1:00:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:00:17 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:00:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:00:17 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:00:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:00:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:00:17 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:00:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 1:00:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:00:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:00:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:00:18 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:00:18 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:00:18 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:00:18 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 1:00:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:00:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:00:18 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:00:18 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:00:18
2019-08-28 1:04:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:04:06 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:04:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:04:06 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:04:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:04:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:04:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:04:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 1:04:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:04:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:04:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:04:07 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:04:07 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:04:07 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:04:07 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 1:04:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:04:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:04:07 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:04:07 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:04:07
2019-08-28 1:06:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:06:26 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:06:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:06:26 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:06:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:06:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:06:26 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:06:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 1:06:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:06:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:06:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:06:27 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:06:27 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:06:27 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:06:27 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 1:06:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:06:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:06:27 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:06:27 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:06:27
2019-08-28 1:06:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:06:29 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:06:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:06:29 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:06:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:06:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:06:29 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:06:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2941234
2019-08-28 1:06:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:06:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:06:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:06:29 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:06:29 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:06:29 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:06:29 0 [Note] InnoDB: 10.3.16 started; log sequence number 2941243; transaction id 3703
2019-08-28 1:06:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:06:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:06:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:06:29
2019-08-28 1:06:29 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:10:24 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-08-28 1:10:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:10:24 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:10:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:10:24 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:10:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:10:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:10:24 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:10:24 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2019-08-28 1:10:24 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibdata1' size is now 10 MB.
2019-08-28 1:10:24 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-08-28 1:10:24 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2019-08-28 1:10:24 0 [Note] InnoDB: Renaming log file C:\Xampp\mysql\data\ib_logfile101 to C:\Xampp\mysql\data\ib_logfile0
2019-08-28 1:10:24 0 [Note] InnoDB: New log files created, LSN=45786
2019-08-28 1:10:24 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-08-28 1:10:24 0 [Note] InnoDB: Doublewrite buffer created
2019-08-28 1:10:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:10:24 0 [Note] InnoDB: Creating foreign key constraint system tables.
2019-08-28 1:10:24 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-08-28 1:10:24 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-08-28 1:10:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:10:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:10:24 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:10:24 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:10:24 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:10:24 0 [Note] InnoDB: 10.3.16 started; log sequence number 0; transaction id 7
2019-08-28 1:10:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:10:24 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:11:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:11:18 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:11:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:11:18 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:11:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:11:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:11:18 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:11:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:11:18 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:11:18 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:11:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:11:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:11:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:11:19 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:11:19 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:11:19 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:11:19 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:11:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:11:19 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:11:19
2019-08-28 1:11:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:11:19 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:15:28 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-08-28 1:15:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:15:28 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:15:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:15:28 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:15:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:15:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:15:28 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:15:28 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2019-08-28 1:15:28 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibdata1' size is now 10 MB.
2019-08-28 1:15:28 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-08-28 1:15:28 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2019-08-28 1:15:28 0 [Note] InnoDB: Renaming log file C:\Xampp\mysql\data\ib_logfile101 to C:\Xampp\mysql\data\ib_logfile0
2019-08-28 1:15:28 0 [Note] InnoDB: New log files created, LSN=45786
2019-08-28 1:15:28 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-08-28 1:15:29 0 [Note] InnoDB: Doublewrite buffer created
2019-08-28 1:15:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:15:29 0 [Note] InnoDB: Creating foreign key constraint system tables.
2019-08-28 1:15:29 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-08-28 1:15:29 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-08-28 1:15:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:15:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:15:29 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:15:29 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:15:29 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:15:29 0 [Note] InnoDB: 10.3.16 started; log sequence number 0; transaction id 7
2019-08-28 1:15:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:15:29 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:16:37 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-08-28 1:16:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:16:37 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:16:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:16:37 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:16:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:16:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:16:37 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:16:37 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2019-08-28 1:16:37 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibdata1' size is now 10 MB.
2019-08-28 1:16:37 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-08-28 1:16:37 0 [Note] InnoDB: Setting log file C:\Xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2019-08-28 1:16:37 0 [Note] InnoDB: Renaming log file C:\Xampp\mysql\data\ib_logfile101 to C:\Xampp\mysql\data\ib_logfile0
2019-08-28 1:16:37 0 [Note] InnoDB: New log files created, LSN=45786
2019-08-28 1:16:37 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-08-28 1:16:37 0 [Note] InnoDB: Doublewrite buffer created
2019-08-28 1:16:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:16:37 0 [Note] InnoDB: Creating foreign key constraint system tables.
2019-08-28 1:16:37 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-08-28 1:16:37 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-08-28 1:16:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:16:37 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:16:37 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:16:37 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:16:37 0 [Note] InnoDB: 10.3.16 started; log sequence number 0; transaction id 7
2019-08-28 1:16:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:16:37 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:21:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:21:59 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:21:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:21:59 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:21:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:21:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:21:59 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:21:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:22:00 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:22:00 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:22:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:22:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:22:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:22:00 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:22:00 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:22:00 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:22:01 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:22:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:22:01 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:22:01
2019-08-28 1:22:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:22:01 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:30:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:30:37 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:30:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:30:37 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:30:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:30:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:30:37 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:30:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:30:37 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:30:37 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:30:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:30:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:30:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:30:38 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:30:38 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:30:38 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:30:38 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:30:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:30:38 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:30:38
2019-08-28 1:30:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:30:38 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:31:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:31:04 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:31:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:31:04 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:31:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:31:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:31:04 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:31:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:31:04 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:31:05 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:31:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:31:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:31:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:31:05 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:31:05 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:31:05 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:31:05 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:31:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:31:05 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:31:05
2019-08-28 1:31:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:31:05 0 [Note] Server socket created on IP: '::'.
2019-08-28 1:33:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-28 1:33:24 0 [Note] InnoDB: Uses event mutexes
2019-08-28 1:33:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-28 1:33:24 0 [Note] InnoDB: Number of pools: 1
2019-08-28 1:33:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-28 1:33:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-28 1:33:24 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-28 1:33:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-08-28 1:33:24 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-08-28 1:33:24 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-08-28 1:33:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-28 1:33:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-28 1:33:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-28 1:33:25 0 [Note] InnoDB: Setting file 'C:\Xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-28 1:33:25 0 [Note] InnoDB: File 'C:\Xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-28 1:33:25 0 [Note] InnoDB: Waiting for purge to start
2019-08-28 1:33:25 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
2019-08-28 1:33:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\Xampp\mysql\data\ib_buffer_pool
2019-08-28 1:33:25 0 [Note] InnoDB: Buffer pool(s) load completed at 190828 1:33:25
2019-08-28 1:33:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-28 1:33:25 0 [Note] Server socket created on IP: '::'.