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
445
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.