close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I have installed xampp and mysql is not geting start showing: mysql_error.log, its details are given below

Thread began 5/31/2017 11:17 am by anonymous | Last modified 5/31/2017 6:00 pm by Ray Borduin | 3985 views | 1 replies |

anonymous

I have installed xampp and mysql is not geting start showing: mysql_error.log, its details are given below

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-06-01 06:07:01 11a0 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-06-01 6:07:01 4512 [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-06-01 6:07:01 4512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-01 6:07:01 4512 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 6:07:01 4512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 6:07:01 4512 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-01 6:07:01 4512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 6:07:01 4512 [Note] InnoDB: Using generic crc32 instructions
2017-06-01 6:07:01 4512 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-01 6:07:01 4512 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 6:07:01 4512 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 6:07:05 4512 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 6:07:05 4512 [Note] InnoDB: Waiting for purge to start
2017-06-01 6:07:05 4512 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835037
2017-06-01 6:07:05 10064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-01 6:07:05 4512 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-01 6:07:05 4512 [Note] Server socket created on IP: '::'.
2017-06-01 6:07:05 4512 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2017-06-01 6:07:05 4512 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-06-01 6:07:05 4512 [ERROR] Aborting

2017-06-01 06:07:14 2eb4 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-06-01 6:07:14 11956 [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-06-01 6:07:15 11956 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-01 6:07:15 11956 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 6:07:15 11956 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 6:07:15 11956 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-01 6:07:15 11956 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 6:07:15 11956 [Note] InnoDB: Using generic crc32 instructions
2017-06-01 6:07:15 11956 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-01 6:07:15 11956 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 6:07:15 11956 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 6:07:16 11956 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 6:07:16 11956 [Note] InnoDB: Waiting for purge to start
2017-06-01 6:07:16 11956 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835541
2017-06-01 6:07:16 11792 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-01 6:07:16 11956 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-01 6:07:16 11956 [Note] Server socket created on IP: '::'.
2017-06-01 6:07:16 11956 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2017-06-01 6:07:16 11956 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-06-01 6:07:16 11956 [ERROR] Aborting

2017-06-01 06:07:23 138c 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-06-01 6:07:23 5004 [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-06-01 6:07:23 5004 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-01 6:07:23 5004 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 6:07:23 5004 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 6:07:23 5004 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-01 6:07:23 5004 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 6:07:23 5004 [Note] InnoDB: Using generic crc32 instructions
2017-06-01 6:07:23 5004 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-01 6:07:23 5004 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 6:07:23 5004 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 6:07:24 5004 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 6:07:24 5004 [Note] InnoDB: Waiting for purge to start
2017-06-01 6:07:24 5004 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835551
2017-06-01 6:07:24 9740 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-01 6:07:24 5004 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-01 6:07:24 5004 [Note] Server socket created on IP: '::'.
2017-06-01 6:07:24 5004 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2017-06-01 6:07:24 5004 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-06-01 6:07:24 5004 [ERROR] Aborting

2017-06-01 06:08:28 25f0 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-06-01 6:08:28 9712 [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-06-01 6:08:28 9712 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-01 6:08:28 9712 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 6:08:28 9712 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 6:08:28 9712 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-01 6:08:28 9712 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 6:08:28 9712 [Note] InnoDB: Using generic crc32 instructions
2017-06-01 6:08:28 9712 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-01 6:08:28 9712 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 6:08:28 9712 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 6:08:29 9712 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 6:08:29 9712 [Note] InnoDB: Waiting for purge to start
2017-06-01 6:08:29 9712 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835561
2017-06-01 6:08:29 8424 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-01 6:08:29 9712 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-01 6:08:29 9712 [Note] Server socket created on IP: '::'.
2017-06-01 6:08:29 9712 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2017-06-01 6:08:29 9712 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-06-01 6:08:29 9712 [ERROR] Aborting

Sign in to reply to this post

Ray BorduinWebAssist

Your dump has the same set of errors repeated. The full list is:


2017-06-01 6:07:01 4512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-01 6:07:01 4512 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 6:07:01 4512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 6:07:01 4512 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-01 6:07:01 4512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 6:07:01 4512 [Note] InnoDB: Using generic crc32 instructions
2017-06-01 6:07:01 4512 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-01 6:07:01 4512 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 6:07:01 4512 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 6:07:05 4512 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 6:07:05 4512 [Note] InnoDB: Waiting for purge to start
2017-06-01 6:07:05 4512 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835037
2017-06-01 6:07:05 10064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-01 6:07:05 4512 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-01 6:07:05 4512 [Note] Server socket created on IP: '::'.
2017-06-01 6:07:05 4512 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2017-06-01 6:07:05 4512 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-06-01 6:07:05 4512 [ERROR] Aborting

2017-06-01 06:07:14 2eb4 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-06-01 6:07:14 11956 [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.

I'd go through it line by line and google what each means.

I'm not a server configuration expert, so I can't really make heads or tails of this. I'd find a xampp forum to post this to.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...