I am trying to work out if we need to upgrade our server hardware or need to configure the MySQL settings to make things faster.
SELECT * From table took 1.6 seconds from the command line. However
mysql-slow.log shows that it takes 7 seconds when one of our processes from another server executes it. This seems very slow to me. The table contains three INT columns only.
It's an Ubuntu Rackspace cloud server. We have 4GB RAM and only 1.2GB is used up.
So do the numbers look about right or is there something wrong?
I have added the
EXPLAIN EXTENDED SELECT * From table here: