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
Subject
Views
Written By
Posted
1597
December 11, 2017 02:16PM
624
December 11, 2017 09:21PM
Re: Query causing CPU Spike to 100% after MYSQL upgrade
581
December 12, 2017 09:13AM
516
December 12, 2017 02:52PM
543
December 13, 2017 12:29PM
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.