MySQL startet nicht mehr, XAMPP startet

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL startet nicht mehr, XAMPP startet

Postby Franz47 » 25. October 2017 14:00

Seit einiger Zeit verwendete ich Wordpress an XAMPP auf meinen Win 7 64b PC. Seit heute startet MySQL nicht mehr und dadurch kann Wordpress auch keine Verbindung mehr zum Mysql-server aufbauen
Kann ich was tun, um das wieder zum Laufen zu bringen?
Bin dankbar für einen Tip
Franz47


Der mysql_error.log seit 8.10.2017

2017-10-08 21:50:21 37a0 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-08 21:50:21 14240 [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-08 21:50:21 14240 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-08 21:50:21 14240 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-08 21:50:21 14240 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-08 21:50:21 14240 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-08 21:50:21 14240 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-08 21:50:21 14240 [Note] InnoDB: Using generic crc32 instructions
2017-10-08 21:50:21 14240 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-08 21:50:21 14240 [Note] InnoDB: Completed initialization of buffer pool
2017-10-08 21:50:21 14240 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-08 21:50:22 14240 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-08 21:50:22 14240 [Note] InnoDB: Waiting for purge to start
2017-10-08 21:50:22 14240 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835037
2017-10-08 21:50:22 8044 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-08 21:50:22 14240 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-08 21:50:22 14240 [Note] Server socket created on IP: '::'.
2017-10-08 21:50:22 14240 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-08 21:51:32 36c8 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-08 21:51:32 14024 [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-08 21:51:32 14024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-08 21:51:32 14024 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-08 21:51:32 14024 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-08 21:51:32 14024 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-08 21:51:32 14024 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-08 21:51:32 14024 [Note] InnoDB: Using generic crc32 instructions
2017-10-08 21:51:32 14024 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-08 21:51:32 14024 [Note] InnoDB: Completed initialization of buffer pool
2017-10-08 21:51:32 14024 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-08 21:51:32 14024 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 1835047 in the ib_logfiles!
2017-10-08 21:51:33 14024 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-08 21:51:34 14024 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-08 21:51:34 14024 [Note] InnoDB: Waiting for purge to start
2017-10-08 21:51:34 14024 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835047
2017-10-08 21:51:34 14564 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-08 21:51:34 14024 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-08 21:51:34 14024 [Note] Server socket created on IP: '::'.
2017-10-08 21:51:34 14024 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-21 20:44:06 3ae0 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-21 20:44:06 15072 [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-21 20:44:06 15072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-21 20:44:06 15072 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-21 20:44:06 15072 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-21 20:44:06 15072 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-21 20:44:06 15072 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-21 20:44:06 15072 [Note] InnoDB: Using generic crc32 instructions
2017-10-21 20:44:06 15072 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-21 20:44:06 15072 [Note] InnoDB: Completed initialization of buffer pool
2017-10-21 20:44:06 15072 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-21 20:44:06 15072 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 3869621 in the ib_logfiles!
2017-10-21 20:44:07 15072 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-21 20:44:09 15072 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-21 20:44:09 15072 [Note] InnoDB: Waiting for purge to start
2017-10-21 20:44:09 15072 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 3869621
2017-10-21 20:44:09 15200 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-21 20:44:09 15072 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-21 20:44:09 15072 [Note] Server socket created on IP: '::'.
2017-10-21 20:44:09 15072 [ERROR] mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired
2017-10-21 20:44:09 15072 [Warning] Checking table: '.\mysql\user'
2017-10-21 20:44:09 15072 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
2017-10-21 20:44:09 15072 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2017-10-21 20:44:09 15072 [Warning] Checking table: '.\mysql\db'
2017-10-21 20:44:09 15072 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
2017-10-21 20:44:10 15072 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-21 21:49:50 380c 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-21 21:49:50 14348 [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-21 21:49:50 14348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-21 21:49:50 14348 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-21 21:49:50 14348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-21 21:49:50 14348 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-21 21:49:50 14348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-21 21:49:50 14348 [Note] InnoDB: Using generic crc32 instructions
2017-10-21 21:49:50 14348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-21 21:49:50 14348 [Note] InnoDB: Completed initialization of buffer pool
2017-10-21 21:49:50 14348 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-21 21:49:50 14348 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 6099443 in the ib_logfiles!
2017-10-21 21:49:50 14348 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-21 21:49:51 14348 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-21 21:49:51 14348 [Note] InnoDB: Waiting for purge to start
2017-10-21 21:49:51 14348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 6099443
2017-10-21 21:49:51 11732 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-21 21:49:51 14348 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-21 21:49:51 14348 [Note] Server socket created on IP: '::'.
2017-10-21 21:49:51 14348 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-22 09:08:12 16c0 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-22 9:08:12 5824 [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-22 9:08:12 5824 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-22 9:08:12 5824 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-22 9:08:12 5824 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-22 9:08:12 5824 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-22 9:08:12 5824 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-22 9:08:12 5824 [Note] InnoDB: Using generic crc32 instructions
2017-10-22 9:08:12 5824 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-22 9:08:12 5824 [Note] InnoDB: Completed initialization of buffer pool
2017-10-22 9:08:12 5824 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-22 9:08:12 5824 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 6833087 in the ib_logfiles!
2017-10-22 9:08:12 5824 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-22 9:08:12 5824 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-22 9:08:12 5824 [Note] InnoDB: Waiting for purge to start
2017-10-22 9:08:12 5824 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 6833087
2017-10-22 9:08:12 12888 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-22 9:08:13 5824 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-22 9:08:13 5824 [Note] Server socket created on IP: '::'.
2017-10-22 9:08:13 5824 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-23 14:10:10 18b8 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 14:10:10 6328 [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 14:10:10 6328 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-23 14:10:10 6328 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-23 14:10:10 6328 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-23 14:10:10 6328 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-23 14:10:10 6328 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-23 14:10:10 6328 [Note] InnoDB: Using generic crc32 instructions
2017-10-23 14:10:10 6328 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-23 14:10:10 6328 [Note] InnoDB: Completed initialization of buffer pool
2017-10-23 14:10:10 6328 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-23 14:10:10 6328 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 13102610 in the ib_logfiles!
2017-10-23 14:10:11 6328 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-23 14:10:12 6328 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-23 14:10:12 6328 [Note] InnoDB: Waiting for purge to start
2017-10-23 14:10:12 6328 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 13102610
2017-10-23 14:10:12 4824 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-23 14:10:12 6328 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-23 14:10:12 6328 [Note] Server socket created on IP: '::'.
2017-10-23 14:10:13 6328 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:25 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:26 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:26 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:26 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:26 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-10-23 15:45:26 10768 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2017-10-23 22:10:08 1258 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 22:10:08 4696 [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 22:10:08 4696 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-23 22:10:08 4696 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-23 22:10:08 4696 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-23 22:10:08 4696 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-23 22:10:08 4696 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-23 22:10:08 4696 [Note] InnoDB: Using generic crc32 instructions
2017-10-23 22:10:08 4696 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-23 22:10:08 4696 [Note] InnoDB: Completed initialization of buffer pool
2017-10-23 22:10:09 4696 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-23 22:10:09 4696 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 20249463 in the ib_logfiles!
2017-10-23 22:10:09 4696 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-23 22:10:12 4696 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-23 22:10:12 4696 [Note] InnoDB: Waiting for purge to start
2017-10-23 22:10:12 4696 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 20249463
2017-10-23 22:10:12 5244 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-23 22:10:12 4696 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-23 22:10:12 4696 [Note] Server socket created on IP: '::'.
2017-10-23 22:10:12 4696 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-24 14:30:13 fe8 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-24 14:30:13 4072 [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-24 14:30:13 4072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-24 14:30:13 4072 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-24 14:30:13 4072 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-24 14:30:13 4072 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-24 14:30:13 4072 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-24 14:30:13 4072 [Note] InnoDB: Using generic crc32 instructions
2017-10-24 14:30:13 4072 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-24 14:30:13 4072 [Note] InnoDB: Completed initialization of buffer pool
2017-10-24 14:30:13 4072 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-24 14:30:13 4072 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 20249473 in the ib_logfiles!
2017-10-24 14:30:14 4072 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-24 14:30:15 4072 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-24 14:30:15 4072 [Note] InnoDB: Waiting for purge to start
2017-10-24 14:30:15 4072 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 20249473
2017-10-24 14:30:15 12328 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-24 14:30:15 4072 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-24 14:30:16 4072 [Note] Server socket created on IP: '::'.
2017-10-24 14:30:16 4072 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-10-24 16:10:10 10312 [ERROR] mysqld.exe: Table '.\bitnami_wordpress\wp_oqey_gallery' is marked as crashed and should be repaired
2017-10-24 16:10:10 10312 [Warning] Checking table: '.\bitnami_wordpress\wp_oqey_gallery'
2017-10-24 16:10:10 10312 [ERROR] mysqld.exe: Table '.\bitnami_wordpress\wp_oqey_images' is marked as crashed and should be repaired
2017-10-24 16:10:10 10312 [Warning] Checking table: '.\bitnami_wordpress\wp_oqey_images'
2017-10-24 18:19:24 2c54 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-24 18:19:24 11348 [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-24 18:19:24 11348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-24 18:19:24 11348 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-24 18:19:24 11348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-24 18:19:24 11348 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-24 18:19:24 11348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-24 18:19:24 11348 [Note] InnoDB: Using generic crc32 instructions
2017-10-24 18:19:24 11348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-24 18:19:24 11348 [Note] InnoDB: Completed initialization of buffer pool
2017-10-24 18:19:24 11348 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-24 18:19:24 11348 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 20482869 in the ib_logfiles!
2017-10-24 18:19:25 11348 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-10-24 18:19:26 11348 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-24 18:19:26 11348 [Note] InnoDB: Waiting for purge to start
2017-10-24 18:19:26 11348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 20482869
2017-10-24 18:19:26 6240 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-24 18:19:26 11348 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-24 18:19:26 11348 [Note] Server socket created on IP: '::'.
2017-10-24 18:19:26 11348 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
Franz47
 
Posts: 2
Joined: 25. October 2017 13:47
XAMPP version: 3.2.2
Operating System: Win 7 64b

Re: MySQL startet nicht mehr, XAMPP startet

Postby Franz47 » 26. October 2017 08:28

Problem selbst gelöst!
Franz47
 
Posts: 2
Joined: 25. October 2017 13:47
XAMPP version: 3.2.2
Operating System: Win 7 64b


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 41 guests