mysql is not starting after installing the mysql service

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

mysql is not starting after installing the mysql service

Postby amersufi7 » 22. October 2017 20:21

2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2017-10-23 00:56:42 ea0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-10-23 0:56:42 3744 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-10-23 0:56:42 3744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-23 0:56:42 3744 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-23 0:56:42 3744 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-23 0:56:42 3744 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-23 0:56:42 3744 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-23 0:56:42 3744 [Note] InnoDB: Using generic crc32 instructions
2017-10-23 0:56:42 3744 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-23 0:56:42 3744 [Note] InnoDB: Completed initialization of buffer pool
2017-10-23 0:56:42 3744 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-23 0:56:42 3744 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-23 0:56:42 3744 [Note] InnoDB: Waiting for purge to start
2017-10-23 0:56:42 3744 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835037
2017-10-23 0:56:42 5020 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-23 0:56:42 3744 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-23 0:56:42 3744 [Note] Server socket created on IP: '::'.
2017-10-23 0:56:42 3744 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-23 0:56:51 1036 [Note] mysql\bin\mysqld.exe: Normal shutdown

2017-10-23 0:56:51 1036 [Note] Event Scheduler: Purging the queue. 0 events
2017-10-23 0:56:51 7732 [Note] InnoDB: FTS optimize thread exiting.
2017-10-23 0:56:51 1036 [Note] InnoDB: Starting shutdown...
2017-10-23 0:56:52 1036 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-10-23 0:56:54 1036 [Note] InnoDB: Shutdown completed; log sequence number 1835047
2017-10-23 0:56:54 1036 [Note] mysql\bin\mysqld.exe: Shutdown complete

2017-10-23 00:57:09 748 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-10-23 0:57:09 1864 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-10-23 0:57:09 1864 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-23 0:57:09 1864 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-23 0:57:09 1864 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-23 0:57:09 1864 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-23 0:57:09 1864 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-23 0:57:09 1864 [Note] InnoDB: Using generic crc32 instructions
2017-10-23 0:57:09 1864 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-23 0:57:09 1864 [Note] InnoDB: Completed initialization of buffer pool
2017-10-23 0:57:09 1864 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-23 0:57:10 1864 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-23 0:57:10 1864 [Note] InnoDB: Waiting for purge to start
2017-10-23 0:57:10 1864 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835047
2017-10-23 0:57:10 7896 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-23 0:57:10 1864 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-23 0:57:10 1864 [Note] Server socket created on IP: '::'.
2017-10-23 0:57:10 1864 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
amersufi7
 
Posts: 1
Joined: 22. October 2017 20:16
XAMPP version: 3.2.2
Operating System: win 10

Re: mysql is not starting after installing the mysql service

Postby Altrea » 22. October 2017 21:49

amersufi7 wrote:2017-10-23 0:57:10 1864 [Note] Server socket created on IP: '::'.
2017-10-23 0:57:10 1864 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

MariaDB has started successfully at 0:57:10
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: 8959
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 46 guests