PDA

View Full Version : need help understanding explain=1 information


Harley D
06-03-2003, 04:04 PM
I found that my queries average :

Server: 3.23.54
? Client: 3.23.52
? Protocol-Version: 10
? Uptime: 1714022
? Threads: 16
? Questions: 2076810
? Slow queries: 6
? Opens: 8275
? Flush tables: 1
? Open tables: 64 Queries per second avg : 1.212

here is the onfo I get



I'm a nuub, ya probably guessed that by now :)
but what am I looking for exactly, and what changes do you suggest I make?

Thanks in advance.

filburt1
06-03-2003, 04:37 PM
It shows:

1. What queries were executed
2. How long they took (after - before = elapsed, don't know why it wouldn't do that itself...)
3. How many queries were executed total
4. Total page generation time

It's dangerous because users can see the raw queries. How specifically that can be bad, I don't know (maybe some obscure XSS problem where you can steal hashes).

Harley D
06-03-2003, 05:39 PM
Thank you.