mysql8.0.18 a killed tread cant released
Hi:
I met a very difficult problem. A threads keep in killed for days.it was doing a simple searching （select count(*)）. as i knew it was a New feature（innodb_parallel_read_threads=4）what made select count() faster
in mysql8.0. it happenned twice already and now it happen in another mysql server.
undo logs cant be truncated by mysql system and Grow to 5G per file· cpu was full buzy.no err in errlog
Subject
Views
Written By
Posted
mysql8.0.18 a killed tread cant released
624
June 08, 2020 12:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.