Programuotojas reikalingas

Sveiki, yra projektas toks www.gangsteriai.lt. Bet jis pradejo labai letai veikti. Turiu omeny uzsilagina karts nuo karto. patikrino per ssh, tai problema yra ta, kad mysqld procesas uzkelia CPU iki 70% ir tuo metu kai jis toks uzkiles serveriu neimanoma naudotis. Taip laikosi apie 30sec. Tada viskas gerai, ir uz kokiu 5min vel viskas is naujo. Nuejau i phpmyadmin patikrint gal ka, ir statuse radau stai ka:

Table_locks_waited 3 487 The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.