XF 1.1 Slow Query Log

[SneakyDave]

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`;

 

[Luke F]

Misconfigured or slow server if it takes 10 seconds to read ~15mb

 

[SneakyDave]

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.

 

[Mike]

If that's the literal query, that's not from XF.

 

[SneakyDave]

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.

 

[SneakyDave]

Yes, I can confirm that it was from a backup script, not an XF issue.