mysql expert needed

Hi
my box is getting high load lately bitween 1- 3 and am not sure if its related to kernel upgrade to 2.4.21-37.EL cuz i never have any load problem before this upgrade

am trying to investigate where is the bottelnick and start with mysql slow queries cuz my website is based on vbulletin forum and there is only one website on this server

i did cat /var/lib/mysql/slow_queries.log

and thease are the top slow queries i found :

# Time: 051028 13:41:28
# User@Host: indexsi_saif[indexsi_saif] @ localhost []
# Query_time: 81 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM attachment
WHERE posthash <> '' AND
dateline < 1130492407;


# Time: 051028 14:41:06
# User@Host: indexsi_saif[indexsi_saif] @ localhost []
# Query_time: 58 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM attachment
WHERE posthash <> '' AND
dateline < 1130496008;



# Time: 051028 15:41:00
# User@Host: indexsi_saif[indexsi_saif] @ localhost []
# Query_time: 56 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM attachment
WHERE posthash <> '' AND
dateline < 1130499604;



# Time: 051028 19:40:54
# User@Host: indexsi_saif[indexsi_saif] @ localhost []
# Query_time: 48 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM attachment
WHERE posthash <> '' AND
dateline < 1130514006;


# Time: 051028 22:41:07
# User@Host: indexsi_saif[indexsi_saif] @ localhost []
# Query_time: 62 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM attachment
WHERE posthash <> '' AND
dateline < 1130524805;
# Time: 051028 22:52:01




what is cuzing thease queries to take all that time and how to fix it ?


WHM 10.6.0 cPanel 10.8.0-S59
RedHat Enterprise 3 i686 - WHM X v3.1.0

Celeron(R) CPU 2.40GHz

1 giga ram

swap used almost 10%

 

 

 

 

Top