Xampp Innodb

Posted on  by admin
  1. Xampp Innodb_buffer_pool_size
  2. Xampp Mysql Innodb Error
I've noticed some posts where it turns out the users having problems have their TimeTrex tables set up in MySQL as MyISAM instead of the preferred InnoDB. Innodb

InnoDB Log Files. A common configuration change which can prevent MySQL from starting involves the InnoDB log file size. The InnoDB log file is the ‘redo’ or recovery log for the InnoDB storage engine. It contains transactions which have been committed to a MySQL table, but which have not yet been written to disk. 2017-02-25 12: Note InnoDB: Mutexes and rwlocks use Windows interlocked functions 2017-02-25 12: Note InnoDB: Uses event mutexes 2017-02-25 12: Note InnoDB: Compressed tables use zlib 1.2.3 2017-02-25 12: Note InnoDB: Number of pools: 1 2017-02-25 12: Note InnoDB: Using generic crc32. XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. InnoDB stores its tables and indexes in a single tablespace., which by default consist of the 3 files ibdata1, iblogfile0, and iblogfile1. For restoring a database you would also need these files. It is a combination of two files. The FRM file is the table definition.


I had this problem and it turns out that XAMPP (at least the windows version) had InnoDB disabled by default. Before being able to convert to InnoDB I had to enable it within the my.cnf file and restart MySQL.
The my.cnf file is located in the mysqlbin folder within the xampp install folder. You need to find the following:

Xampp Innodb_buffer_pool_size

You need to comment-out skip-innodb and uncomment the other relevant lines, so you end up with something like the following:

Code: Select all

Xampp Mysql Innodb Error

Of course, your specific paths may be different than mine.
Anyway, it took me a while to figure out what was going on so I decided to post this in case it helps anyone else out. I have a feeling if I made the above changes before installing TimeTrex, all the tables would have been created as InnoDB to begin with.
Posted by: Gonzalo none
Date: August 11, 2019 05:49AM

13:33:35 [mysql] Error: MySQL shutdown unexpectedly.
13:33:35 [mysql] This may be due to a blocked port, missing dependencies,
13:33:35 [mysql] improper privileges, a crash, or a shutdown by another method.
13:33:35 [mysql] Press the Logs button to view error logs and check
13:33:35 [mysql] the Windows Event Viewer for more clues
13:33:35 [mysql] If you need more help, copy and post this
13:33:35 [mysql] entire log window on the forums
Please help.(My english not very good.)
I dont know how to fix this. The UAC is disabled. I have the xampp installed on D:
Please help I don't know what to do.
I tried a lot of thing, but it didn't work.
The mysql_error.log:
2019-08-07 13:20:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 13:20:32 0 [Note] InnoDB: Uses event mutexes
2019-08-07 13:20:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 13:20:32 0 [Note] InnoDB: Number of pools: 1
2019-08-07 13:20:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 13:20:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 13:20:32 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 13:20:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791378
2019-08-07 13:20:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 13:20:33 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 13:20:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 13:20:33 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 13:20:33 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 13:20:33 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 13:20:33 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791387; transaction id 163
2019-08-07 13:20:33 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 13:20:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 13:20:33 0 [Note] Server socket created on IP: '::'.
2019-08-07 13:20:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 13:20:42 0 [Note] InnoDB: Uses event mutexes
2019-08-07 13:20:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 13:20:42 0 [Note] InnoDB: Number of pools: 1
2019-08-07 13:20:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 13:20:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 13:20:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 13:20:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791396
2019-08-07 13:20:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 13:20:42 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 13:20:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 13:20:42 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 13:20:42 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 13:20:42 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 13:20:42 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791405; transaction id 163
2019-08-07 13:20:42 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 13:20:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 13:20:42 0 [Note] Server socket created on IP: '::'.
2019-08-07 13:20:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 13:20:49 0 [Note] InnoDB: Uses event mutexes
2019-08-07 13:20:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 13:20:49 0 [Note] InnoDB: Number of pools: 1
2019-08-07 13:20:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 13:20:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 13:20:49 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 13:20:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791414
2019-08-07 13:20:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 13:20:49 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 13:20:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 13:20:49 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 13:20:49 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 13:20:49 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 13:20:49 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791423; transaction id 163
2019-08-07 13:20:49 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 13:20:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 13:20:49 0 [Note] Server socket created on IP: '::'.
2019-08-07 14:04:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 14:04:53 0 [Note] InnoDB: Uses event mutexes
2019-08-07 14:04:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 14:04:53 0 [Note] InnoDB: Number of pools: 1
2019-08-07 14:04:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 14:04:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 14:04:53 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 14:04:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1818713
2019-08-07 14:04:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 14:04:54 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 14:04:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 14:04:54 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 14:04:54 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 14:04:54 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 14:04:54 0 [Note] InnoDB: 10.3.16 started; log sequence number 1818722; transaction id 231
2019-08-07 14:04:54 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 14:04:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 14:04:54 0 [Note] Server socket created on IP: '::'.
2019-08-07 14:07:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 14:07:54 0 [Note] InnoDB: Uses event mutexes
2019-08-07 14:07:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 14:07:54 0 [Note] InnoDB: Number of pools: 1
2019-08-07 14:07:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 14:07:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 14:07:54 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 14:07:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1818731
2019-08-07 14:07:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 14:07:55 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 14:07:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 14:07:55 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 14:07:55 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 14:07:55 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 14:07:55 0 [Note] InnoDB: 10.3.16 started; log sequence number 1818740; transaction id 231
2019-08-07 14:07:55 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 14:07:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 14:07:55 0 [Note] Server socket created on IP: '::'.
2019-08-07 19:06:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 19:06:08 0 [Note] InnoDB: Uses event mutexes
2019-08-07 19:06:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 19:06:08 0 [Note] InnoDB: Number of pools: 1
2019-08-07 19:06:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 19:06:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 19:06:08 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 19:06:08 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1827006
2019-08-07 19:06:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 19:06:09 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-07 19:06:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 19:06:09 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 19:06:09 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-07 19:06:09 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 19:06:09 0 [Note] InnoDB: 10.3.16 started; log sequence number 1827015; transaction id 274
2019-08-07 19:06:09 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-07 19:06:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 19:06:09 0 [Note] InnoDB: Buffer pool(s) load completed at 190807 19:06:09
2019-08-07 19:06:09 0 [Note] Server socket created on IP: '::'.
2019-08-08 11:27:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-08 11:27:26 0 [Note] InnoDB: Uses event mutexes
2019-08-08 11:27:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-08 11:27:26 0 [Note] InnoDB: Number of pools: 1
2019-08-08 11:27:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-08 11:27:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-08 11:27:26 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-08 11:27:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4725002
2019-08-08 11:27:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-08 11:27:27 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-08 11:27:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-08 11:27:27 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-08 11:27:27 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-08 11:27:27 0 [Note] InnoDB: Waiting for purge to start
2019-08-08 11:27:27 0 [Note] InnoDB: 10.3.16 started; log sequence number 4725011; transaction id 18086
2019-08-08 11:27:27 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-08 11:27:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-08 11:27:27 0 [Note] Server socket created on IP: '::'.
2019-08-11 13:20:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-11 13:20:13 0 [Note] InnoDB: Uses event mutexes
2019-08-11 13:20:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-11 13:20:13 0 [Note] InnoDB: Number of pools: 1
2019-08-11 13:20:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-11 13:20:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-11 13:20:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-11 13:20:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4832907
2019-08-11 13:20:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-11 13:20:14 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-11 13:20:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-11 13:20:14 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-11 13:20:14 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-11 13:20:14 0 [Note] InnoDB: Waiting for purge to start
2019-08-11 13:20:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 4832916; transaction id 18404
2019-08-11 13:20:15 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-11 13:20:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-11 13:20:15 0 [Note] Server socket created on IP: '::'.
2019-08-11 13:26:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-11 13:26:05 0 [Note] InnoDB: Uses event mutexes
2019-08-11 13:26:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-11 13:26:05 0 [Note] InnoDB: Number of pools: 1
2019-08-11 13:26:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-11 13:26:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-11 13:26:05 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-11 13:26:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4832907
2019-08-11 13:26:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-11 13:26:06 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-11 13:26:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-11 13:26:06 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-11 13:26:06 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-11 13:26:06 0 [Note] InnoDB: Waiting for purge to start
2019-08-11 13:26:06 0 [Note] InnoDB: 10.3.16 started; log sequence number 4832916; transaction id 18404
2019-08-11 13:26:06 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-11 13:26:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-11 13:26:06 0 [Note] Server socket created on IP: '::'.
2019-08-11 13:27:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-11 13:27:58 0 [Note] InnoDB: Uses event mutexes
2019-08-11 13:27:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-11 13:27:58 0 [Note] InnoDB: Number of pools: 1
2019-08-11 13:27:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-11 13:27:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-11 13:27:58 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-11 13:27:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4832907
2019-08-11 13:27:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-11 13:27:59 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-11 13:27:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-11 13:27:59 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-11 13:27:59 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-11 13:27:59 0 [Note] InnoDB: Waiting for purge to start
2019-08-11 13:28:00 0 [Note] InnoDB: 10.3.16 started; log sequence number 4832916; transaction id 18404
2019-08-11 13:28:00 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-11 13:28:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-11 13:28:00 0 [Note] Server socket created on IP: '::'.
2019-08-11 13:30:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-11 13:30:40 0 [Note] InnoDB: Uses event mutexes
2019-08-11 13:30:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-11 13:30:40 0 [Note] InnoDB: Number of pools: 1
2019-08-11 13:30:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-11 13:30:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-11 13:30:40 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-11 13:30:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4832907
2019-08-11 13:30:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-11 13:30:41 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-11 13:30:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-11 13:30:41 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-11 13:30:41 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-11 13:30:41 0 [Note] InnoDB: Waiting for purge to start
2019-08-11 13:30:41 0 [Note] InnoDB: 10.3.16 started; log sequence number 4832916; transaction id 18404
2019-08-11 13:30:41 0 [Note] InnoDB: Loading buffer pool(s) from D:xamppmysqldataib_buffer_pool
2019-08-11 13:30:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-11 13:30:41 0 [Note] Server socket created on IP: '::'.
2019-08-11 13:33:33 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-08-11 13:33:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-11 13:33:33 0 [Note] InnoDB: Uses event mutexes
2019-08-11 13:33:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-11 13:33:33 0 [Note] InnoDB: Number of pools: 1
2019-08-11 13:33:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-11 13:33:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-11 13:33:33 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-11 13:33:33 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2019-08-11 13:33:33 0 [Note] InnoDB: File 'D:xamppmysqldataibdata1' size is now 10 MB.
2019-08-11 13:33:33 0 [Note] InnoDB: Setting log file D:xamppmysqldataib_logfile101 size to 5242880 bytes
2019-08-11 13:33:33 0 [Note] InnoDB: Setting log file D:xamppmysqldataib_logfile1 size to 5242880 bytes
2019-08-11 13:33:34 0 [Note] InnoDB: Renaming log file D:xamppmysqldataib_logfile101 to D:xamppmysqldataib_logfile0
2019-08-11 13:33:34 0 [Note] InnoDB: New log files created, LSN=45786
2019-08-11 13:33:34 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-08-11 13:33:34 0 [Note] InnoDB: Doublewrite buffer created
2019-08-11 13:33:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-11 13:33:34 0 [Note] InnoDB: Creating foreign key constraint system tables.
2019-08-11 13:33:35 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-08-11 13:33:35 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-08-11 13:33:35 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'
2019-08-11 13:33:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-11 13:33:35 0 [Note] InnoDB: Setting file 'D:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-11 13:33:35 0 [Note] InnoDB: File 'D:xamppmysqldataibtmp1' size is now 12 MB.
2019-08-11 13:33:35 0 [Note] InnoDB: Waiting for purge to start
2019-08-11 13:33:35 0 [Note] InnoDB: 10.3.16 started; log sequence number 0; transaction id 7
2019-08-11 13:33:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-11 13:33:35 0 [Note] Server socket created on IP: '::'.

Options:Reply•Quote

Written By

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.