MySQL Forums
Forum List  »  Quality Assurance

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


I met a very difficult problem. A threads keep in killed for 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 err in errlog

Options: ReplyQuote

Written By
mysql8.0.18 a killed tread cant released
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.