• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Slow Query Log

SneakyDave

Well-known member
#1
I have a few styles installed, but most of the templates are inherited from the parent.

I've seen this reported as a slow query in MySQL. I assume this is normal? Where would this query be executed, in the admincp?

# Query_time: 10.760047 Lock_time: 0.000000 Rows_sent: 6966 Rows_examined: 6966
use xf_blahblahblah;
SET timestamp=1325503815;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `xf_template_compiled`;
 

SneakyDave

Well-known member
#3
Nothing is telling me that's it's slow: top, munin, cpu, memory, I/O. Just curious I guess.

sqltuner.pl only sqwawks about the number of JOINs performed without indexes, but I haven't pinpointed that to xf yet.
 

SneakyDave

Well-known member
#5
Really? That's weird, other than the USE command, I didn't change anything. Maybe it was from a backup script. Thanks for the info Mike.