The Arcive of vBulletin Modifications Site. |
|
need help understanding explain=1 information Details »»
|
||||||||||||||||||||||||||||
|
need help understanding explain=1 information
Developer Last Online: Apr 2012
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 Quote:
![]() but what am I looking for exactly, and what changes do you suggest I make? Thanks in advance. Show Your Support
|
||||||||||||||||||||||||||||
| Comments |
|
#2
|
|||
|
|||
|
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). |
|
#3
|
||||
|
||||
|
Thank you.
|
![]() |
|
|