MySQL running slow

[davecates]

Hi,
We have a new fresh install of Plesk 8.2 running on Fedora 6.
The install is only running 1 domain but the site is taking ages to search through the MySQL database. The site was working fine on another Plesk hosted Linux system. The admin has moved the site over and a copy of the database.
Is there any advice anyone can give as to what we can do to speed up the query? The server shows a CPU utilisation of 0.4% idle but with the query up to 97%!!!! for 1 query!!
Any ideas? many thanks.

 

[simpliq_adi]

Hello,

Check the /etc/my.cnf also, what version of mysql are you running?

 

[davecates]

We're running version 5.0.2 of MySQL.
The domain developers copied the database over from a version 4 MySQL database.
From looking through the database via phpmyadmin there appears to be some red comments in the status about indexing. Do you think it sounds like the database wasn't indexed when it was moved over?
I'm not too experienced with MySQL hence my questioning.
There is a debate about the amount of RAM available but the server is a 3.2Ghz single core (of dual core proc) with 512MB of RAM on a minimal Fedora 6 install and Plesk 8.2
Thanks for any replies!

One more comment - this is running as a virtual machine within MS virtual server. The host is Win2k3 with a 3.2GHz dual core, 2Gb RAM and 250GB hdd (1 core. 512Mb and 100Gb allocated to the Linux VM). Nothing else is running or installed on the host as yet.