MySQL Forums
Forum List  »  Quality Assurance

mysql8.0.18 a killed tread cant released
Posted by: Danie Dong
Date: June 08, 2020 12:32AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql8.0.18 a killed tread cant released
57
June 08, 2020 12:32AM


Sorry, only registered users may post in this forum.

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.