To reduce Mysql Query CPU utilization

Question

I have query which uses like with "%search_pattern%" which is taking high CPU utilization if i hit 5-6 parallel request, my table has data around 30 Million.

Can any alternative methods or algorithm be used to optimize that?

Ex:

SELECT * FROM USER_DETAILS U WHERE U.NAME LIKE %JOHN%';

CPU Utilization is going to 700%

Possible duplicate of Optimization of MySQL search using "like" and wildcards — FuzzyTree
– FuzzyTree, Commented Oct 13, 2015 at 10:28

Bernd Buffen · Accepted Answer · 2015-10-13 11:10:35Z

1

When you use LIKE '%JOHN%' mysql cant use a index and must compare each ROW with the String. The only way to use a Index is use LIKE 'JOHN%' ´. look if a index on NAME

answered Oct 13, 2015 at 11:10

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

To reduce Mysql Query CPU utilization

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related