MySQL Forums
Forum List  »  Performance

Re: Query causing CPU Spike to 100% after MYSQL upgrade
Posted by: Irfan Khan
Date: December 12, 2017 09:13AM

Funny part is only one filter makes the query goes kaput

and (`cft`.`name` = ('Document - Product, Processing and Application')


If we change it to this , it works. Table only has 48 records, so its not volume either.

and (`cft`.`name` like ('Document%Product, Processing and Application').


There is no error in first one, and its just a query so expectation is for it to bail out, but it just sits, making mysqld to go 100% and making the DB unusable.

Thanks
IK

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query causing CPU Spike to 100% after MYSQL upgrade
383
December 12, 2017 09:13AM


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.