XF 1.1 Huge topic page load very slowly

[Mario Estrada]

We have a thread that has a huge first page and it takes a long time to load and it actually triggers an entry in our mysql long query logs, taking around 4 seconds to complete the query.

The affected thread *:
http://www.techspot.com/ community/topics/google-redirect-and-tdsskiller-wont-run.159317/

Might be related, our DB is running with every table as MyISAM, we haven't changed the tables to InnoDB because we are still testing new backup scripts that work efficiently with InnoDB.

* Removed link because I don't wan't crawlers opening that page or anyone abusing it.

 

[Jake Bunce]

Try enabling debug mode by adding this line to your library/config.php file:

$config['debug'] = 1;

That will display load stats and explain each query. That may help to know where the problem lies. Also check your server load by running "top" in the shell. Check standard stuff like free memory, swap, disk usage, cpu usage, heavy processes, etc.

Might be related, our DB is running with every table as MyISAM, we haven't changed the tables to InnoDB because we are still testing new backup scripts that work efficiently with InnoDB.

Your forum is sufficiently large and busy that you may be experiencing scaling issues with MyISAM. InnoDB scales much better.

 

[agison]

Use mydumper to generate backup. It's fast for both MyISAM & InnoDB.

 

[Mario Estrada]

Thanks, our server administrator is working on migrating the backup script to mydumper.

And I'll post an update if we find the problem causing this excessive load.

 

[Mario Estrada]

Looks like by switching to InnoDB we no longer have the slow queries issue with big threads.