Search found 1270 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

MySQL Extension not working

Hi guys,

For some reason the MySQL Extension just doesn't work, however every other extension within the XAAMP control panel seems to work..This is my MySQL Error Log.

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

2016-08-27 02:03:02 c20 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.
2016-08-27 2:03:02 3104 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-27 2:03:02 3104 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-27 2:03:02 3104 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-27 2:03:02 3104 [Note] InnoDB: Memory barrier is not used
2016-08-27 2:03:02 3104 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-27 2:03:02 3104 [Note] InnoDB: Using generic crc32 instructions
2016-08-27 2:03:02 3104 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-27 2:03:02 3104 [Note] InnoDB: Completed initialization of buffer pool
2016-08-27 2:03:02 3104 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-27 2:03:02 3104 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-27 2:03:02 3104 [Note] InnoDB: Waiting for purge to start
2016-08-27 2:03:02 3104 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-08-27 2:03:02 3228 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-27 2:03:02 3104 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-27 2:03:02 3104 [Note] Server socket created on IP: '::'.
2016-08-27 2:03:02 3104 [Note] mysql\bin\mysqld: ready for connections.
Version: '10.1.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
by Bulletowns
27. August 2016 01:12
 
Forum: XAMPP for Windows
Topic: MySQL Extension not working
Replies: 3
Views: 593

mysql statet nicht

alle anderen Dienste laufen

das controlpanel gibt folgende fehlermedung aus:
17:41:00 [mysql] Fehler: MySQL wurde unerwartet beendet
17:41:00 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
17:41:00 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
17:41:00 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
17:41:00 [mysql] im Windows Event Viewer für weitere Hinweise
17:41:00 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
17:41:00 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

die logdatei zeigt folgendes:
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
160825 17:40:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160825 17:40:58 InnoDB: The InnoDB memory heap is disabled
160825 17:40:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160825 17:40:58 InnoDB: Compressed tables use zlib 1.2.3
160825 17:40:58 InnoDB: Initializing buffer pool, size = 16.0M
160825 17:40:58 InnoDB: Completed initialization of buffer pool
160825 17:40:58 InnoDB: highest supported file format is Barracuda.
160825 17:40:59 InnoDB: Waiting for the background threads to start
160825 17:41:00 InnoDB: 5.5.39 started; log sequence number 1608010
160825 17:41:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160825 17:41:00 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160825 17:41:00 [Note] Server socket created on IP: '0.0.0.0'.
160825 17:41:00 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)


was muss ich tun, das es läuft?
vielen Dank im voraus
by hrafnason
25. August 2016 16:52
 
Forum: XAMPP für Windows
Topic: mysql statet nicht
Replies: 11
Views: 391

Any Help? Apache/Mysel Error

Thx in advance



Error msg


12:28:49 [mysql] Error: MySQL shutdown unexpectedly.
12:28:49 [mysql] This may be due to a blocked port, missing dependencies,
12:28:49 [mysql] improper privileges, a crash, or a shutdown by another method.
12:28:49 [mysql] Press the Logs button to view error logs and check
12:28:49 [mysql] the Windows Event Viewer for more clues
12:28:49 [mysql] If you need more help, copy and post this
12:28:49 [mysql] entire log window on the forums







Log



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
by mojojojo
20. August 2016 12:47
 
Forum: XAMPP for Windows
Topic: Any Help? Apache/Mysel Error
Replies: 0
Views: 191

I no longer starts mysql

Today at around 2:35 p.m. I opened XAMPP and perfectly pers tonight when I opened it gives me an error and does not know how to solve it.


-----mysql_error-----
Code: Select all
2016-08-20 01:09:20 1040 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.
2016-08-20  1:09:20 4160 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-20  1:09:20 4160 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-20  1:09:20 4160 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-20  1:09:20 4160 [Note] InnoDB: Memory barrier is not used
2016-08-20  1:09:20 4160 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-20  1:09:20 4160 [Note] InnoDB: Using generic crc32 instructions
2016-08-20  1:09:20 4160 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-20  1:09:20 4160 [Note] InnoDB: Completed initialization of buffer pool
2016-08-20  1:09:20 4160 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-20  1:09:20 4160 [Note] InnoDB: The log sequence numbers 7768930 and 7768930 in ibdata files do not match the log sequence number 9351907 in the ib_logfiles!
2016-08-20  1:09:20 4160 [Note] InnoDB: Database was not shutdown normally!
2016-08-20  1:09:20 4160 [Note] InnoDB: Starting crash recovery.
2016-08-20  1:09:20 4160 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-08-20  1:09:20 4160 [Note] InnoDB: Restoring possible half-written data pages
2016-08-20  1:09:20 4160 [Note] InnoDB: from the doublewrite buffer...
2016-08-20  1:09:21 4160 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-20  1:09:21 4160 [Note] InnoDB: Waiting for purge to start
2016-08-20  1:09:21 4160 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 9351907
2016-08-20  1:09:22 2228 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-20  1:09:22 4160 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-20  1:09:22 4160 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2016-08-20  1:09:22 4160 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2016-08-20  1:09:22 4160 [Note] Server socket created on IP: '::'.
2016-08-20  1:09:22 4160 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by Lally
19. August 2016 23:16
 
Forum: XAMPP for Windows
Topic: I no longer starts mysql
Replies: 1
Views: 194

Mysql startert in xampp nicht

hey, ich weiß die frage wurde schon oft genug gepostet, aber irgendwie finde ich keine antowrt auf mein Problem.
Code: Select all
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

danke schon mal im Vorraus für jede Antowrt :)
by Firepitt
17. August 2016 13:53
 
Forum: XAMPP für Windows
Topic: Mysql startert in xampp nicht
Replies: 0
Views: 141

Installer was not able to connect to MySql server.

I have XAMPP up and running, all of the elements are green. However, I get the error message that "The installer was not able to connect to the MySql server. Please make sure MySql is running and introduce a valid password to connect to MySql."
Error Log:
2016-08-11 23:16:55 1210 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.
2016-08-11 23:16:55 4624 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-11 23:16:55 4624 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-11 23:16:56 4624 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-11 23:16:56 4624 [Note] InnoDB: Memory barrier is not used
2016-08-11 23:16:56 4624 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-11 23:16:56 4624 [Note] InnoDB: Using generic crc32 instructions
2016-08-11 23:16:56 4624 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-11 23:16:56 4624 [Note] InnoDB: Completed initialization of buffer pool
2016-08-11 23:16:57 4624 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-11 23:16:57 4624 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 1835067 in the ib_logfiles!
2016-08-11 23:16:57 4624 [Note] InnoDB: Database was not shutdown normally!
2016-08-11 23:16:57 4624 [Note] InnoDB: Starting crash recovery.
2016-08-11 23:16:57 4624 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-08-11 23:16:58 4624 [Note] InnoDB: Restoring possible half-written data pages
2016-08-11 23:16:58 4624 [Note] InnoDB: from the doublewrite buffer...
2016-08-11 23:17:02 4624 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-11 23:17:02 4624 [Note] InnoDB: Waiting for purge to start
2016-08-11 23:17:02 4624 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835067
2016-08-11 23:17:04 4624 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-11 23:17:04 11760 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-11 23:17:04 4624 [Note] Server socket created on IP: '::'.
2016-08-11 23:17:04 4624 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

MySql is running on port 3306

Could someone please point me in the right direction? I will not give up my day job to become a coder or wordpress guru. Mil thanks.
by Santitob
12. August 2016 07:01
 
Forum: XAMPP for Windows
Topic: Installer was not able to connect to MySql server.
Replies: 2
Views: 300

Re: Apache failure & MySQL failure

HEllo EVERYONE,

I have managed to start Apache,

but still I have problem with MySQL:

nearby log:

http://wklejto.pl/259449



2016-08-10 19:16:17 6728 [Note] Plugin 'FEDERATED' is disabled.
2016-08-10 19:16:17 177c 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.
2016-08-10 19:16:17 6728 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-10 19:16:17 6728 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-10 19:16:17 6728 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-10 19:16:17 6728 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-10 19:16:17 6728 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-10 19:16:17 6728 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-10 19:16:17 6728 [Note] InnoDB: Completed initialization of buffer pool
2016-08-10 19:16:17 6728 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-10 19:16:18 6728 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2016-08-10 19:16:18 6728 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-08-10 19:16:18 6728 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2016-08-10 19:16:18 6728 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2016-08-10 19:16:19 6728 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2016-08-10 19:16:19 6728 [Warning] InnoDB: New log files created, LSN=1625987
2016-08-10 19:16:19 6728 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-10 19:16:19 6728 [Note] InnoDB: Waiting for purge to start
2016-08-10 19:16:19 6728 [Note] InnoDB: 5.6.16 started; log sequence number 1625987
2016-08-10 19:16:19 6728 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 275bb569-5f1e-11e6-bf1a-485ab6bca66e.
2016-08-10 19:16:19 6728 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-10 19:16:19 6728 [Note] IPv6 is available.
2016-08-10 19:16:19 6728 [Note] - '::' resolves to '::';
2016-08-10 19:16:19 6728 [Note] Server socket created on IP: '::'.
2016-08-10 19:16:19 6728 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-08-10 19:16:19 6728 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-08-10 19:16:19 6728 [ERROR] Aborting

2016-08-10 19:16:19 6728 [Note] Binlog end
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'partition'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-10 19:16:19 6728 [Note] Shutting down plugin 'InnoDB'
2016-08-10 19:16:19 6728 [Note] InnoDB: FTS optimize thread exiting.
2016-08-10 19:16:19 6728 [Note] InnoDB: Starting shutdown...
2016-08-10 19:16:21 6728 [Note] InnoDB: Shutdown completed; log sequence number 1626134
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'ARCHIVE'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'MyISAM'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'MEMORY'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'CSV'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'sha256_password'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'mysql_old_password'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'mysql_native_password'
2016-08-10 19:16:21 6728 [Note] Shutting down plugin 'binlog'
2016-08-10 19:16:21 6728 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-08-10 19:22:56 64 [Note] Plugin 'FEDERATED' is disabled.
2016-08-10 19:22:56 e24 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.
2016-08-10 19:22:56 64 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-10 19:22:56 64 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-10 19:22:56 64 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-10 19:22:56 64 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-10 19:22:56 64 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-10 19:22:56 64 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-10 19:22:56 64 [Note] InnoDB: Completed initialization of buffer pool
2016-08-10 19:22:56 64 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-10 19:22:57 64 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-10 19:22:57 64 [Note] InnoDB: Waiting for purge to start
2016-08-10 19:22:57 64 [Note] InnoDB: 5.6.16 started; log sequence number 1626134
2016-08-10 19:22:57 64 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-10 19:22:57 64 [Note] IPv6 is available.
2016-08-10 19:22:57 64 [Note] - '::' resolves to '::';
2016-08-10 19:22:57 64 [Note] Server socket created on IP: '::'.
2016-08-10 19:22:57 64 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-08-10 19:22:57 64 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-08-10 19:22:57 64 [ERROR] Aborting

2016-08-10 19:22:57 64 [Note] Binlog end
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'partition'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-10 19:22:57 64 [Note] Shutting down plugin 'InnoDB'
2016-08-10 19:22:57 64 [Note] InnoDB: FTS optimize thread exiting.
2016-08-10 19:22:57 64 [Note] InnoDB: Starting shutdown...
2016-08-10 19:22:59 64 [Note] InnoDB: Shutdown completed; log sequence number 1626144
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'ARCHIVE'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'MyISAM'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'MEMORY'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'CSV'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'sha256_password'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'mysql_old_password'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'mysql_native_password'
2016-08-10 19:22:59 64 [Note] Shutting down plugin 'binlog'
2016-08-10 19:22:59 64 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-08-11 22:00:41 3824 [Note] Plugin 'FEDERATED' is disabled.
2016-08-11 22:00:41 b7c 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.
2016-08-11 22:00:41 3824 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-11 22:00:41 3824 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-11 22:00:41 3824 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-11 22:00:41 3824 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-11 22:00:41 3824 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-11 22:00:41 3824 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-11 22:00:41 3824 [Note] InnoDB: Completed initialization of buffer pool
2016-08-11 22:00:41 3824 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-11 22:00:42 3824 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-11 22:00:42 3824 [Note] InnoDB: Waiting for purge to start
2016-08-11 22:00:42 3824 [Note] InnoDB: 5.6.16 started; log sequence number 1626144
2016-08-11 22:00:42 3824 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-11 22:00:42 3824 [Note] IPv6 is available.
2016-08-11 22:00:42 3824 [Note] - '::' resolves to '::';
2016-08-11 22:00:42 3824 [Note] Server socket created on IP: '::'.
2016-08-11 22:00:42 3824 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-08-11 22:00:42 3824 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-08-11 22:00:42 3824 [ERROR] Aborting

2016-08-11 22:00:42 3824 [Note] Binlog end
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'partition'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-11 22:00:42 3824 [Note] Shutting down plugin 'InnoDB'
2016-08-11 22:00:42 3824 [Note] InnoDB: FTS optimize thread exiting.
2016-08-11 22:00:42 3824 [Note] InnoDB: Starting shutdown...
2016-08-11 22:00:43 3824 [Note] InnoDB: Shutdown completed; log sequence number 1626154
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'ARCHIVE'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'MyISAM'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'MEMORY'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'CSV'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'sha256_password'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'mysql_old_password'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'mysql_native_password'
2016-08-11 22:00:43 3824 [Note] Shutting down plugin 'binlog'
2016-08-11 22:00:43 3824 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-08-11 22:00:50 456 [Note] Plugin 'FEDERATED' is disabled.
2016-08-11 22:00:50 2d8 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.
2016-08-11 22:00:50 456 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-11 22:00:50 456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-11 22:00:50 456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-11 22:00:50 456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-11 22:00:50 456 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-11 22:00:50 456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-11 22:00:50 456 [Note] InnoDB: Completed initialization of buffer pool
2016-08-11 22:00:50 456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-11 22:00:51 456 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-11 22:00:51 456 [Note] InnoDB: Waiting for purge to start
2016-08-11 22:00:51 456 [Note] InnoDB: 5.6.16 started; log sequence number 1626154
2016-08-11 22:00:51 456 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-11 22:00:51 456 [Note] IPv6 is available.
2016-08-11 22:00:51 456 [Note] - '::' resolves to '::';
2016-08-11 22:00:51 456 [Note] Server socket created on IP: '::'.
2016-08-11 22:00:51 456 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-08-11 22:00:51 456 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-08-11 22:00:51 456 [ERROR] Aborting

2016-08-11 22:00:51 456 [Note] Binlog end
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'partition'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-11 22:00:51 456 [Note] Shutting down plugin 'InnoDB'
2016-08-11 22:00:51 456 [Note] InnoDB: FTS optimize thread exiting.
2016-08-11 22:00:51 456 [Note] InnoDB: Starting shutdown...
2016-08-11 22:00:52 456 [Note] InnoDB: Shutdown completed; log sequence number 1626164
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'ARCHIVE'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'MyISAM'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'MEMORY'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'CSV'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'sha256_password'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'mysql_old_password'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'mysql_native_password'
2016-08-11 22:00:52 456 [Note] Shutting down plugin 'binlog'
2016-08-11 22:00:52 456 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete



Please let me know, any help would be grateful!
by olinkaz93
11. August 2016 21:07
 
Forum: XAMPP for Windows
Topic: Apache failure & MySQL failure
Replies: 1
Views: 350

plötzlich stürzt mysql ab

Hallo zusammen,

bis dato hatte ich keine probleme mit Xampp & mysql.
Seit heute werden keine query mehr ausgeführt. beim Ausführen stürzt mysql ab. #2006 mysql server has gone away. + mysql.exe funktioniert nicht mehr.

auch über phpmyadmin ist die tabelle nicht ansprechbar bzw. stürzt ab wenn ich draufklicke.

Dies passiert nur bei einer bestimmten großen Tabelle. Sonst funktioniert alles einwandfrei.

habe Version 5.6.20 & Windows 7 prof 64bit
bei Version 5.6.3 (andere PC) funktioniert alles.

habe versucht in my.ini key_buffer usw. zu erhöhen... hat jedoch nichts bewirkt.


Code: Select all
2016-08-11 17:41:12 4420 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-11 17:41:12 4420 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-11 17:41:12 4420 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-11 17:41:12 4420 [Note] InnoDB: Memory barrier is not used
2016-08-11 17:41:12 4420 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-11 17:41:12 4420 [Note] InnoDB: Using generic crc32 instructions
2016-08-11 17:41:12 4420 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2016-08-11 17:41:12 4420 [Note] InnoDB: Completed initialization of buffer pool
2016-08-11 17:41:12 4420 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-11 17:41:12 4420 [Note] InnoDB: The log sequence numbers 101062102028 and 101062102028 in ibdata files do not match the log sequence number 101062109836 in the ib_logfiles!
2016-08-11 17:41:12 4420 [Note] InnoDB: Database was not shutdown normally!
2016-08-11 17:41:12 4420 [Note] InnoDB: Starting crash recovery.
2016-08-11 17:41:12 4420 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-08-11 17:41:12 4420 [Note] InnoDB: Restoring possible half-written data pages
2016-08-11 17:41:12 4420 [Note] InnoDB: from the doublewrite buffer...
2016-08-11 17:41:12 4420 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-11 17:41:12 4420 [Note] InnoDB: Waiting for purge to start
2016-08-11 17:41:12 4420 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 101062109836
2016-08-11 17:41:12 5772 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-11 17:41:12 4420 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-11 17:41:12 4420 [Note] Server socket created on IP: '::'.
2016-08-11 17:41:12 4420 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2016-08-11 17:41:12 4420 [Warning] Checking table:   '.\mysql\db'
2016-08-11 17:41:12 4420 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
2016-08-11 17:41:12 4420 [ERROR] mysqld.exe: Table '.\mysql\tables_priv' is marked as crashed and should be repaired
2016-08-11 17:41:12 4420 [Warning] Checking table:   '.\mysql\tables_priv'
2016-08-11 17:41:12 4420 [ERROR] mysql.tables_priv: 1 client is using or hasn't closed the table properly
2016-08-11 17:41:12 4420 [ERROR] mysqld.exe: Table '.\mysql\columns_priv' is marked as crashed and should be repaired
2016-08-11 17:41:12 4420 [Warning] Checking table:   '.\mysql\columns_priv'
2016-08-11 17:41:12 4420 [ERROR] mysql.columns_priv: 1 client is using or hasn't closed the table properly
2016-08-11 17:41:12 4420 [ERROR] mysqld.exe: Table '.\mysql\procs_priv' is marked as crashed and should be repaired
2016-08-11 17:41:12 4420 [Warning] Checking table:   '.\mysql\procs_priv'
2016-08-11 17:41:12 4420 [ERROR] mysql.procs_priv: 1 client is using or hasn't closed the table properly
2016-08-11 17:41:12 4420 [Note] c:\xampp2\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.13-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
InnoDB: Error: trying to access page number 700432 in space 226,
InnoDB: space name db/lac,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
2016-08-11 17:44:30 2324  InnoDB: Assertion failure in thread 8996 in file fil0fil.cc line 5866
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
160811 17:44:30 [ERROR] mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
by snowrider52
11. August 2016 16:02
 
Forum: XAMPP für Windows
Topic: plötzlich stürzt mysql ab
Replies: 3
Views: 210

xamp install mysql error

Hi all, I just downloaded xamp and the mysql component will not work, I get this message:

Error: MySQL shutdown unexpectedly.
7:01:07 PM [mysql] This may be due to a blocked port, missing dependencies,
7:01:07 PM [mysql] improper privileges, a crash, or a shutdown by another method.
7:01:07 PM [mysql] Press the Logs button to view error logs and check
7:01:07 PM [mysql] the Windows Event Viewer for more clues
7:01:07 PM [mysql] If you need more help, copy and post this
7:01:07 PM [mysql] entire log window on the forums

Any help would be amazing!!

Here is the log:


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

2016-08-09 19:01:04 1a34 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.
2016-08-09 19:01:04 6708 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-09 19:01:04 6708 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-09 19:01:04 6708 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-09 19:01:04 6708 [Note] InnoDB: Memory barrier is not used
2016-08-09 19:01:04 6708 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-09 19:01:04 6708 [Note] InnoDB: Using generic crc32 instructions
2016-08-09 19:01:04 6708 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-09 19:01:04 6708 [Note] InnoDB: Completed initialization of buffer pool
2016-08-09 19:01:04 6708 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-09 19:01:04 6708 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-09 19:01:04 6708 [Note] InnoDB: Waiting for purge to start
2016-08-09 19:01:04 6708 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-08-09 19:01:04 8200 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-09 19:01:04 6708 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-09 19:01:04 6708 [Note] Server socket created on IP: '::'.
2016-08-09 19:01:04 6708 [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.


2016-08-09 19:01:04 6708 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-08-09 19:01:04 6708 [ERROR] Aborting
by toddo280
10. August 2016 03:15
 
Forum: XAMPP for Windows
Topic: xamp install mysql error
Replies: 1
Views: 738

Re: MySQL startet nicht nach Mac OS X crash

Dieses Forum hier leistet Hilfe durch freiwillige Helfer. Es ist tatsächlich so, dass mir hier derzeit kein freiwilliger Helfer bekannt ist, der XAMPP auf Mac OS X betreiben geschweige denn Support dafür leisten kann und mag.

innodb_force_recovery = 1 ist die schwächste Form einer erzwungenen Wiederherstellung. Du kannst den Wert erhöhen und es nochmal versuchen.
Ein Wert von 4 oder höher führt am ehesten zum Erfolg.

Das Problem ist nicht XAMPP, das kann dir auch mit anderen Webserver Stacks mit MySQL/MariaDB passieren. InnoDB ist darauf ausgelegt Datenintegrität sehr hoch anzusetzen, daher wird für alles und jeden Prüfnummern gebildet und abgeglichen. Schon bei der kleinsten Abweichung verweigert das DBMS lieber komplett den Dienst statt die Datenintegrität zu gefährden.

Nun stellt ein Betriebssystemcrash eine der stärksten Formen der Beeinflussung dar, du ziehst der Datenbank quasi den Boden unter den Füßen weg.Wie willst du hier erwarten, dass ein DBMS graceful terminated wird? Das kann dir genauso bei anderen DBMS und anderen Betriebssystemen die Datenbank schrotten.
by Altrea
03. August 2016 18:47
 
Forum: XAMPP für Mac OS X
Topic: MySQL startet nicht nach Mac OS X crash
Replies: 2
Views: 155

Mysql won't start

Database wont start and logs say to post here, I have NO Idea what this says as I am much an amatuer at this. Any help is greatly appreciated. I have installed xamp on external HD as my C: drive is too small to support xamp and large site I need to work on. Apache runs fine, just cant start db.

Here are logs:
Code: Select all
2016-08-03 11:50:14 ec0 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.
2016-08-03 11:50:14 3776 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-03 11:50:14 3776 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-03 11:50:14 3776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-03 11:50:14 3776 [Note] InnoDB: Memory barrier is not used
2016-08-03 11:50:14 3776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-03 11:50:14 3776 [Note] InnoDB: Using generic crc32 instructions
2016-08-03 11:50:14 3776 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-03 11:50:14 3776 [Note] InnoDB: Completed initialization of buffer pool
2016-08-03 11:50:14 3776 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-03 11:50:14 ec0  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
 InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-08-03 11:50:14 3776 [ERROR] InnoDB: File (unknown): 'read' returned OS error 287. Cannot continue operation
2016-08-03 11:50:18 1fa4 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.
2016-08-03 11:50:18 8100 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-03 11:50:18 8100 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-03 11:50:18 8100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-03 11:50:18 8100 [Note] InnoDB: Memory barrier is not used
2016-08-03 11:50:18 8100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-03 11:50:18 8100 [Note] InnoDB: Using generic crc32 instructions
2016-08-03 11:50:18 8100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-03 11:50:18 8100 [Note] InnoDB: Completed initialization of buffer pool
2016-08-03 11:50:18 8100 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-03 11:50:18 1fa4  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
 InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-08-03 11:50:18 8100 [ERROR] InnoDB: File (unknown): 'read' returned OS error 287. Cannot continue operation
2016-08-03 11:51:50 2108 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.
2016-08-03 11:51:50 8456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-03 11:51:50 8456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-03 11:51:50 8456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-03 11:51:50 8456 [Note] InnoDB: Memory barrier is not used
2016-08-03 11:51:50 8456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-03 11:51:50 8456 [Note] InnoDB: Using generic crc32 instructions
2016-08-03 11:51:50 8456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-03 11:51:50 8456 [Note] InnoDB: Completed initialization of buffer pool
2016-08-03 11:51:50 8456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-03 11:51:50 2108  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
 InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-08-03 11:51:50 8456 [ERROR] InnoDB: File (unknown): 'read' returned OS error 287. Cannot continue operation
2016-08-03 11:53:59 22a8 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.
2016-08-03 11:53:59 8872 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-03 11:53:59 8872 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-03 11:53:59 8872 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-03 11:53:59 8872 [Note] InnoDB: Memory barrier is not used
2016-08-03 11:53:59 8872 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-03 11:53:59 8872 [Note] InnoDB: Using generic crc32 instructions
2016-08-03 11:53:59 8872 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-08-03 11:53:59 8872 [Note] InnoDB: Completed initialization of buffer pool
2016-08-03 11:53:59 8872 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-03 11:53:59 22a8  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
 InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-08-03 11:53:59 8872 [ERROR] InnoDB: File (unknown): 'read' returned OS error 287. Cannot continue operation


Thanks
Brentr
by Hollywood691
03. August 2016 18:08
 
Forum: XAMPP for Windows
Topic: Mysql won't start
Replies: 0
Views: 297

Re: XAMPP (Apache+MySQL Problem)

Bei mir ist es das Gleiche wie bei euch anderen!

13:24:35 [mysql] Fehler: MySQL wurde unerwartet beendet
13:24:35 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
13:24:35 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
13:24:35 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
13:24:35 [mysql] im Windows Event Viewer für weitere Hinweise
13:24:35 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
13:24:35 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.





Und jetzt die Logs.






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





Was ist da los? Kann mir bitte jemand Helfen, brauche ich eine andere Version oder muss ich mich irgentwo abmelden, habe ich irgentetwas falsch gemacht. Bei Skype habe ich mich schon abgemeldet! Was soll ich machen? Hilfe!!!!
by Tilu1TV
31. July 2016 12:43
 
Forum: XAMPP für Windows
Topic: XAMPP (Apache+MySQL Problem)
Replies: 7
Views: 3025

MySQL Won't Start

Hi,

Yesterday I was running on XAMPP a Wordpress installation with no problem. Apache and MySQL were running smooth but today I want to start the engine again and it's not working.

Is there anyone who can help me with this issue?

This is the log:

Code: Select all
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

2016-07-11 16:09:11 20388 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.
2016-07-11 16:09:12 131976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-11 16:09:12 131976 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-11 16:09:12 131976 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-11 16:09:12 131976 [Note] InnoDB: Memory barrier is not used
2016-07-11 16:09:12 131976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-11 16:09:12 131976 [Note] InnoDB: Using generic crc32 instructions
2016-07-11 16:09:12 131976 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-11 16:09:12 131976 [Note] InnoDB: Completed initialization of buffer pool
2016-07-11 16:09:12 131976 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-11 16:09:12 131976 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-11 16:09:12 131976 [Note] InnoDB: Waiting for purge to start
2016-07-11 16:09:12 131976 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-07-11 16:09:12 131628 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-07-11 16:09:12 131976 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-11 16:09:12 131976 [Note] Server socket created on IP: '::'.
2016-07-11 16:09:13 131976 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.13-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2016-07-11 16:28:42 1d0b8 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.
2016-07-11 16:28:42 118968 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-11 16:28:42 118968 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-11 16:28:42 118968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-11 16:28:42 118968 [Note] InnoDB: Memory barrier is not used
2016-07-11 16:28:42 118968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-11 16:28:42 118968 [Note] InnoDB: Using generic crc32 instructions
2016-07-11 16:28:42 118968 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-11 16:28:42 118968 [Note] InnoDB: Completed initialization of buffer pool
2016-07-11 16:28:42 118968 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-07-11 16:28:42 118968 [ERROR] InnoDB: The system tablespace must be writable!
2016-07-11 16:28:42 118968 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-11 16:28:42 118968 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-07-11 16:28:42 118968 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-11 16:28:42 118968 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-07-11 16:28:42 118968 [ERROR] Aborting

2016-07-11 16:28:42 1fe2c 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.
2016-07-11 16:28:42 130604 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-11 16:28:42 130604 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-11 16:28:42 130604 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-11 16:28:42 130604 [Note] InnoDB: Memory barrier is not used
2016-07-11 16:28:42 130604 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-11 16:28:42 130604 [Note] InnoDB: Using generic crc32 instructions
2016-07-11 16:28:42 130604 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-11 16:28:42 130604 [Note] InnoDB: Completed initialization of buffer pool
2016-07-11 16:28:42 130604 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-07-11 16:28:42 130604 [ERROR] InnoDB: The system tablespace must be writable!
2016-07-11 16:28:42 130604 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-11 16:28:42 130604 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-07-11 16:28:42 130604 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-11 16:28:42 130604 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-07-11 16:28:42 130604 [ERROR] Aborting

2016-07-11 16:28:43 20d88 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.
2016-07-11 16:28:43 134536 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-11 16:28:43 134536 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-11 16:28:43 134536 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-11 16:28:43 134536 [Note] InnoDB: Memory barrier is not used
2016-07-11 16:28:43 134536 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-11 16:28:43 134536 [Note] InnoDB: Using generic crc32 instructions
2016-07-11 16:28:43 134536 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-11 16:28:43 134536 [Note] InnoDB: Completed initialization of buffer pool
2016-07-11 16:28:43 134536 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-07-11 16:28:43 134536 [ERROR] InnoDB: The system tablespace must be writable!
2016-07-11 16:28:43 134536 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-11 16:28:43 134536 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-11 16:28:43 134536 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-11 16:28:43 134536 [ERROR] Plugin 'Aria' init function returned error.
2016-07-11 16:28:43 134536 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-11 16:28:43 134536 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-11 16:28:43 134536 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-07-11 16:28:43 134536 [ERROR] Aborting

2016-07-14 00:18:34 106e4 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.
2016-07-14  0:18:34 67300 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:18:34 67300 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:18:34 67300 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:18:34 67300 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:18:34 67300 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:18:34 67300 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:18:34 67300 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:18:34 67300 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:18:34 67300 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:18:34 67300 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 15857915 in the ib_logfiles!
2016-07-14  0:18:34 67300 [Note] InnoDB: Database was not shutdown normally!
2016-07-14  0:18:34 67300 [Note] InnoDB: Starting crash recovery.
2016-07-14  0:18:34 67300 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-07-14  0:18:36 67300 [Note] InnoDB: Restoring possible half-written data pages
2016-07-14  0:18:36 67300 [Note] InnoDB: from the doublewrite buffer...
2016-07-14  0:18:40 67300 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:18:40 67300 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:18:40 67300 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15857915
2016-07-14  0:18:40 67384 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:18:40 67300 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:18:40 67300 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:18:40 67300 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:18:40 67300 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:18:40 67300 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:18:40 67300 [ERROR] Aborting

2016-07-14 00:18:46 10994 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.
2016-07-14  0:18:46 67988 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:18:46 67988 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:18:46 67988 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:18:46 67988 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:18:46 67988 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:18:46 67988 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:18:46 67988 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:18:46 67988 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:18:46 67988 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:18:47 67988 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:18:47 67988 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:18:47 67988 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15859668
2016-07-14  0:18:47 68092 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:18:47 67988 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:18:47 67988 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:18:47 67988 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:18:47 67988 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:18:47 67988 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:18:47 67988 [ERROR] Aborting

2016-07-14 00:19:26 10bbc 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.
2016-07-14  0:19:26 68540 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:19:26 68540 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:19:26 68540 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:19:26 68540 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:19:26 68540 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:19:26 68540 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:19:26 68540 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:19:26 68540 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:19:26 68540 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:19:27 68540 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:19:27 68540 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:19:27 68540 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15863066
2016-07-14  0:19:27 67368 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:19:27 68540 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:19:27 68540 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:19:27 68540 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:19:27 68540 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:19:27 68540 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:19:27 68540 [ERROR] Aborting

2016-07-14 00:19:52 109ec 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.
2016-07-14  0:19:52 68076 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:19:52 68076 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:19:52 68076 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:19:52 68076 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:19:52 68076 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:19:52 68076 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:19:52 68076 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:19:52 68076 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:19:52 68076 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:19:53 68076 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:19:53 68076 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:19:53 68076 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15863316
2016-07-14  0:19:53 68160 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:19:53 68076 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:19:53 68076 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:19:53 68076 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:19:53 68076 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:19:53 68076 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:19:53 68076 [ERROR] Aborting

2016-07-14 00:20:06 1082c 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.
2016-07-14  0:20:06 67628 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:20:06 67628 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:20:06 67628 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:20:06 67628 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:20:06 67628 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:20:06 67628 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:20:06 67628 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:20:06 67628 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:20:06 67628 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:20:07 67628 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:20:07 67628 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:20:07 67628 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15863326
2016-07-14  0:20:07 67732 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:20:07 67628 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:20:07 67628 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:20:07 67628 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:20:07 67628 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:20:07 67628 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:20:07 67628 [ERROR] Aborting

2016-07-14 00:27:02 1eac 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.
2016-07-14  0:27:02 7852 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:27:02 7852 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:27:02 7852 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:27:02 7852 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:27:02 7852 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:27:02 7852 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:27:02 7852 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:27:02 7852 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:27:03 7852 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:27:05 7852 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:27:05 7852 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:27:05 7852 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15866200
2016-07-14  0:27:06 7976 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:27:06 7852 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:27:06 7852 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:27:06 7852 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:27:06 7852 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:27:06 7852 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:27:06 7852 [ERROR] Aborting

2016-07-14 00:28:56 1ed0 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.
2016-07-14  0:28:56 7888 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:28:56 7888 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:28:56 7888 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:28:56 7888 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:28:56 7888 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:28:56 7888 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:28:56 7888 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:28:56 7888 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:28:56 7888 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:29:05 7888 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:29:05 7888 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:29:06 7888 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15866210
2016-07-14  0:29:06 9104 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:29:06 7888 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:29:06 7888 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:29:06 7888 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:29:06 7888 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:29:06 7888 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:29:06 7888 [ERROR] Aborting

2016-07-14 00:30:36 1d84 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.
2016-07-14  0:30:36 7556 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:30:36 7556 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:30:36 7556 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:30:36 7556 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:30:36 7556 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:30:36 7556 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:30:36 7556 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:30:36 7556 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:30:36 7556 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:30:37 7556 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:30:37 7556 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:30:37 7556 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15866220
2016-07-14  0:30:37 9188 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:30:37 7556 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:30:37 7556 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:30:37 7556 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:30:37 7556 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:30:37 7556 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:30:37 7556 [ERROR] Aborting

2016-07-14 00:32:33 1710 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.
2016-07-14  0:32:33 5904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-07-14  0:32:33 5904 [Note] InnoDB: The InnoDB memory heap is disabled
2016-07-14  0:32:33 5904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-07-14  0:32:33 5904 [Note] InnoDB: Memory barrier is not used
2016-07-14  0:32:33 5904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-07-14  0:32:33 5904 [Note] InnoDB: Using generic crc32 instructions
2016-07-14  0:32:33 5904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-07-14  0:32:33 5904 [Note] InnoDB: Completed initialization of buffer pool
2016-07-14  0:32:34 5904 [Note] InnoDB: Highest supported file format is Barracuda.
2016-07-14  0:32:35 5904 [Note] InnoDB: 128 rollback segment(s) are active.
2016-07-14  0:32:35 5904 [Note] InnoDB: Waiting for purge to start
2016-07-14  0:32:35 5904 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 15866230
2016-07-14  0:32:35 6796 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)

2016-07-14  0:32:35 5904 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-07-14  0:32:35 5904 [ERROR] Plugin 'Aria' init function returned error.
2016-07-14  0:32:35 5904 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-07-14  0:32:35 5904 [Note] Plugin 'FEEDBACK' is disabled.
2016-07-14  0:32:35 5904 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-07-14  0:32:35 5904 [ERROR] Aborting


Looking forward to your kind assistance.

Alejandro
by universoac
14. July 2016 07:45
 
Forum: XAMPP for Windows
Topic: MySQL Won't Start
Replies: 0
Views: 389

Mysql Won't Start

Can anyone advise why my Mysql will not start, based on the error logs below? I have just done a clean install of Windows 10, which left Xampp intact after the Windows install, however using the Xampp Control Panel 3.0.2, Apache starts ok, but when clicking on Mysql, the pid appears and disappears, stopping the mysql process.

I am using the same database files as I am on my other PC where both Apache and Mysql run fine. The log entries for the PC where mysql runs ok, is under those below.

Mysql will not run:

160703 15:54:29 [Note] Plugin 'FEDERATED' is disabled.
160703 15:54:29 InnoDB: The InnoDB memory heap is disabled
160703 15:54:29 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:54:29 InnoDB: Compressed tables use zlib 1.2.3
160703 15:54:29 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:54:29 InnoDB: Completed initialization of buffer pool
160703 15:54:29 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... nnodb.html
160703 15:54:29 [ERROR] Plugin 'InnoDB' init function returned error.
160703 15:54:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160703 15:54:29 [ERROR] Unknown/unsupported storage engine: InnoDB
160703 15:54:29 [ERROR] Aborting

160703 15:54:29 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Mysql runs ok:

160703 15:46:11 [Note] Plugin 'FEDERATED' is disabled.
160703 15:46:11 InnoDB: The InnoDB memory heap is disabled
160703 15:46:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:46:11 InnoDB: Compressed tables use zlib 1.2.3
160703 15:46:11 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:46:11 InnoDB: Completed initialization of buffer pool
160703 15:46:11 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160703 15:46:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
160703 15:46:11 InnoDB: Waiting for the background threads to start
160703 15:46:12 InnoDB: 1.1.8 started; log sequence number 1599710
160703 15:46:50 [Note] Plugin 'FEDERATED' is disabled.
160703 15:46:50 InnoDB: The InnoDB memory heap is disabled
160703 15:46:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:46:50 InnoDB: Compressed tables use zlib 1.2.3
160703 15:46:50 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:46:50 InnoDB: Completed initialization of buffer pool
160703 15:46:50 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160703 15:46:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
160703 15:46:50 InnoDB: Waiting for the background threads to start
160703 15:46:51 InnoDB: 1.1.8 started; log sequence number 1599710
by Coastalguy
03. July 2016 21:33
 
Forum: XAMPP for Windows
Topic: Mysql Won't Start
Replies: 0
Views: 374

Re: joomla 3.5 auf xampp extrem langsam

Bei langsamen Joomla Installationen auf lokalen Testumgebungen gibt es immer ein paar Standardverdächtige:
- Namensauflösung von localhost (IPv6/IPv4 Problem)
- InnoDB Datenbankengine nicht performant
- externe Programme wie Virenscanner oder Firewalls
- Gesamtsystem zu schwach (ein Laptop ist kein Server)
by Altrea
03. July 2016 20:40
 
Forum: XAMPP für Windows
Topic: joomla 3.5 auf xampp extrem langsam
Replies: 2
Views: 312
PreviousNext

Return to advanced search