database problem

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