Re: MySQL Service Exception
First impressions...
96 queries/sec, 1200 inserts/sec over 34 hrs, that's a fairly busy system, is the hardware as old as the OS?
How much RAM is there? That appears to be crucial.
innodb_buffer_pool_size is small, should usually be 70% or so of RAM available to MySQL, but innodb usage numbers look low, is the biggest query load MyISAM?
Handler_read_rnd_next is high, ie lots of table scans, indicating many queries need to be optimised esp. with covering indexes.
The query cache is deprecated as of 5.7.20, gone in 8, and it appears to be causing mischief here, so consider disabling it.
Is there swapping going on? If so, that needs to be stopped.
Are you needing performance_schema? In a busy system, it costs, turn it off if you can.
Before assuming you've hit a bug, address the above.
Edited 1 time(s). Last edit at 09/01/2017 03:19PM by Peter Brawley.