Home / server / Questions / 320093
In Process
David Ramirez
Asked: 2011-10-08 15:55:05 +0800 CST

MediaWiki slow save of edited pages

  • 772

I have MediaWiki 1.16.2 on a the following LAMP platform, which performs quite good for other apps on a 16 GB RAM dual processor machine: CentOS 5.7 (64-bit) Apache 2.2.3 MySQL 5.0.77 PHP 5.1.6

It seems to depend somewhat on the used browser, but very frequently saving edited pages is too slow - not rare to wait 10 or 20 seconds for it even more for a very simple change.

Rendering the pages works pretty fast, but it's the saving after editing which is killing the user experience. I have detected some improvement when editing from a client running Opera than on Firefox (on a Fedora Linux platform).

Any hints about where can I tune up the server to make it better ?

Benchmarks of Apache run on the machine are impressive, BTW.

linux centos mysql php mediawiki

2 Answers

  1. Are you logging slow queries in mysql? Does the mysql error log show anything?

    In circumstances like this I would start looking at Cacti. The mysql-cacti-templates from Percona are invaluable for this. You will be able to see if you're experiencing an IO issue or a table locking issue. There could be quite a few causes.

    Refs:

    http://code.google.com/p/mysql-cacti-templates/

    • 1

  2. Just throwing out a thought, maybe the saves have more to do with loading external resources? It could be the browser waiting for a response, I have had experiences where slow loads were the result of external JS / content that might be getting slowed down.

    Have you investigated that route? Maybe a custom theme or JS editor taking its sweet time.

    • 0