Slow MySQL

Thanks, Jacob.. But I don't get it.. Never heard of DESCRIBE before, and when I run it in phpMyAdmin, it gives something similar to what SELECT would have..

If this is your SQL:
SELECT * FROM users WHERE id = 1

Show me/us the output of:
DESCRIBE SELECT * FROM users WHERE id = 1

That way we can see if your SQL is using indexes.

Alright.. That makes a bit more sense to me.. Well, the query I run on the front page there is:

"FROM table WHERE field = 'value' ORDER BY id DESC"

If I put "DESCRIBE" in front of that, PHPMyAdmin gives me this..

id = 1
select_type = SIMPLE
table type = items
possible_keys = ALL
key = NULL
key_len = NULL
ref = NULL
rows = 2
Extra = Using where; Using filesort

Is there a key on "field"?
"Using filesort" is bad. But 2 rows shouldn't be a problem.

What do you select?

If you would like to get max speed you need an index that covers your WHERE, ORDER BY and SELECT. This way MySQL only needs to look in the index.
At least there should be an index that covers WHERE and ORDER BY in that order.

I'll see if I can find out how to see the connect time while leaving out the query time.

The 'slow' log is invaluable for me, to know what uses up resources. But that's only if you control the my.cnf and have access to the logs. I use this in my.cnf:

set-variable = long_query_time=1
log-slow-queries

Thanks, Flemming.. Don't have access though..

Whether I have tweaked the code to absolute perfection or not, it seems to me there's no doubt the error is with Gigahost..

I've installed the exact same script here (web5.gigahost.dk rather than web9.gigahost.dk), and hooked it up with an exact copy of the database (mysql2.gigahost.dk rather than mysql3.gigahost.dk)..

Load time has dramatically improved..

Thanks for your help, you guys, but this is a Gigahost issue, and hopefulle they'll own up to it soon..