Hello, I'm having a mysql database problem. My hosting service keeps shutting down my database because of some long running queries that are causing high load on the database server. I need someone with expertise in this field to help me get these problems rectified. I have provided some examples below:
Please reply only if you are an expert in this field.
# Time: 120115 8:22:10
# User@Host: gellnsh_4[gellnsh_4] @ [[login to view URL]]
# Query_time: 15 Lock_time: 0 Rows_sent: 6 Rows_examined: 79910
SELECT PRICE,RETAILPRICE,BUYURL,NAME,DESCRIPTION,IMAGEURL,IMPRESSIONURL
FROM MFproducts WHERE ADVERTISERCATEGORY LIKE '%MIDI Cables%' LIMIT 16,
16;
# Time: 120115 8:23:07
# User@Host: gellnsh_4[gellnsh_4] @ [[login to view URL]]
# Query_time: 23 Lock_time: 0 Rows_sent: 1 Rows_examined: 79910
SELECT count(sku) FROM MFproducts WHERE ADVERTISERCATEGORY LIKE
'%Instrument Cable%';
# Time: 120115 8:23:52
# User@Host: gellnsh_4[gellnsh_4] @ [[login to view URL]]
# Query_time: 20 Lock_time: 0 Rows_sent: 1 Rows_examined: 79910
SELECT count(sku) FROM PIANOproducts WHERE ADVERTISERCATEGORY LIKE
'%Keyboard%' AND ADVERTISERCATEGORY LIKE '%Books%' OR ADVERTISERCATEGORY
LIKE '%Keyboard%' AND ADVERTISERCATEGORY LIKE '%Video%';
# Time: 120115 8:24:08
# User@Host: gellnsh_4[gellnsh_4] @ [[login to view URL]]
# Query_time: 16 Lock_time: 0 Rows_sent: 16 Rows_examined: 16551
SELECT PRICE,RETAILPRICE,BUYURL,NAME,DESCRIPTION,IMAGEURL,IMPRESSIONURL
FROM PIANOproducts WHERE ADVERTISERCATEGORY LIKE '%Keyboard%' AND
ADVERTISERCATEGORY LIKE '%Books%' OR ADVERTISERCATEGORY LIKE '%Keyboard%'
AND ADVERTISERCATEGORY LIKE '%Video%' LIMIT 3040, 16;
regards