1
resposta

Problema com MySQL

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-05-03 01:41:48 d48 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-05-03 1:41:48 3400 [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-05-03 1:41:48 3400 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-03 1:41:48 3400 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-03 1:41:48 3400 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-05-03 1:41:48 3400 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2017-05-03 1:41:48 3400 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-05-03 1:41:48 3400 [Note] InnoDB: Using generic crc32 instructions 2017-05-03 1:41:48 3400 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2017-05-03 1:41:48 3400 [Note] InnoDB: Completed initialization of buffer pool 2017-05-03 1:41:48 3400 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-03 1:41:49 3400 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-03 1:41:49 3400 [Note] InnoDB: Waiting for purge to start 2017-05-03 1:41:49 3400 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835037 2017-05-03 1:41:49 8948 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-03 1:41:50 3400 [Note] Plugin 'FEEDBACK' is disabled. 2017-05-03 1:41:50 3400 [Note] Server socket created on IP: '::'. 2017-05-03 1:41:50 3400 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2017-05-03 1:41:50 3400 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2017-05-03 1:41:50 3400 [ERROR] Aborting

2017-05-03 13:18:44 1cac 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-05-03 13:18:44 7340 [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-05-03 13:18:44 7340 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-03 13:18:44 7340 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-03 13:18:44 7340 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-05-03 13:18:44 7340 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2017-05-03 13:18:44 7340 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-05-03 13:18:44 7340 [Note] InnoDB: Using generic crc32 instructions 2017-05-03 13:18:44 7340 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2017-05-03 13:18:44 7340 [Note] InnoDB: Completed initialization of buffer pool 2017-05-03 13:18:44 7340 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-03 13:18:48 7340 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-03 13:18:48 7340 [Note] InnoDB: Waiting for purge to start 2017-05-03 13:18:48 7340 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835541 2017-05-03 13:18:48 1100 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-03 13:18:48 7340 [Note] Plugin 'FEEDBACK' is disabled. 2017-05-03 13:18:49 7340 [Note] Server socket created on IP: '::'. 2017-05-03 13:18:49 7340 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2017-05-03 13:18:49 7340 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2017-05-03 13:18:49 7340 [ERROR] Aborting

2017-05-03 13:23:55 e48 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-05-03 13:23:55 3656 [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-05-03 13:23:55 3656 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-03 13:23:55 3656 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-03 13:23:55 3656 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-05-03 13:23:55 3656 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2017-05-03 13:23:55 3656 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-05-03 13:23:55 3656 [Note] InnoDB: Using generic crc32 instructions 2017-05-03 13:23:55 3656 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2017-05-03 13:23:55 3656 [Note] InnoDB: Completed initialization of buffer pool 2017-05-03 13:23:56 3656 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-03 13:23:57 3656 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-03 13:23:57 3656 [Note] InnoDB: Waiting for purge to start 2017-05-03 13:23:57 3656 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835551 2017-05-03 13:23:57 1848 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-03 13:23:57 3656 [Note] Plugin 'FEEDBACK' is disabled. 2017-05-03 13:23:57 3656 [Note] Server socket created on IP: '::'. 2017-05-03 13:23:57 3656 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2017-05-03 13:23:57 3656 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2017-05-03 13:23:57 3656 [ERROR] Aborting

2017-05-03 13:25:47 18ec 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-05-03 13:25:47 6380 [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-05-03 13:25:47 6380 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-03 13:25:47 6380 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-03 13:25:47 6380 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-05-03 13:25:47 6380 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2017-05-03 13:25:47 6380 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-05-03 13:25:47 6380 [Note] InnoDB: Using generic crc32 instructions 2017-05-03 13:25:47 6380 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2017-05-03 13:25:47 6380 [Note] InnoDB: Completed initialization of buffer pool 2017-05-03 13:25:47 6380 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-03 13:25:47 6380 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-03 13:25:47 6380 [Note] InnoDB: Waiting for purge to start 2017-05-03 13:25:47 6380 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835561 2017-05-03 13:25:48 3424 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-03 13:25:48 6380 [Note] Plugin 'FEEDBACK' is disabled. 2017-05-03 13:25:48 6380 [Note] Server socket created on IP: '::'. 2017-05-03 13:25:48 6380 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2017-05-03 13:25:48 6380 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2017-05-03 13:25:48 6380 [ERROR] Aborting

o mysql não executa

1 resposta

Vc tem duas hipóteses, ou vc descobre qual aplicação ta usando essa porta com o comando: netstat –ano | more , e termina, ou vc reinstala o servidor Mysql em outra porta.