Apache Friends Support Forum

Today out of the blue mysql just stops running for some reason. Here is the LOG any ideas? Sorry if it's obvious i'm new to this. Thanks

2018-03-07 13:40:01 ae4 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.
2018-03-07 13:40:01 2788 [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.

2018-03-07 13:40:01 2788 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-03-07 13:40:01 2788 [Note] InnoDB: The InnoDB memory heap is disabled
2018-03-07 13:40:01 2788 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-03-07 13:40:01 2788 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-03-07 13:40:01 2788 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-07 13:40:01 2788 [Note] InnoDB: Using generic crc32 instructions
2018-03-07 13:40:01 2788 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-03-07 13:40:01 2788 [Note] InnoDB: Completed initialization of buffer pool
2018-03-07 13:40:01 2788 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-07 13:40:01 2788 [Note] InnoDB: The log sequence number 47050378 in ibdata file do not match the log sequence number 47050904 in the ib_logfiles!
2018-03-07 13:40:01 2788 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-03-07 13:40:02 2788 [Note] InnoDB: 128 rollback segment(s) are active.
2018-03-07 13:40:02 2788 [Note] InnoDB: Waiting for purge to start
2018-03-07 13:40:02 2788 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 47050904
2018-03-07 13:40:02 2788 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-07 13:40:02 2788 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-03-07 13:40:02 2788 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-03-07 13:40:02 2788 [Note] Server socket created on IP: '::'.
2018-03-07 13:40:02 2788 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Have a backup of your database? Looks like some of the data may have corrupted. I recommend not stopping MySQL with the control panel, rather use mysqladmin command line to do a clean shutdown. Can also happen if your computer is shut down while server is running.

comment out or delete innodb_additional_mem_pool_size on your my.ini configuration for mysql. a missing mysql user table can easily be solved though phpmyadmin if you have one installed.