I'm running 64-bit Debian Squeeze and I've installed bugzilla from the repositories. This action has auto-configured and installed:
- Bugzilla 22.214.171.124-4.5
- MySQL Ver 14.14 Distrib 5.1.63
- Apache 2.2.16-6+squeeze8
When I browse my Bugzilla web interface I find that navigation is very fast, but adding new bugs or comments is very slow (10s+).
I've tried the following things to rectify the issue:
Configured Bugzilla to use mod_perl rather than mod_cgi. The navigation speeded up a little, but form submission remained slow.
Threw more resources at the (virtual) server. It now has two CPU cores and 4 GB memory (up from one core and 1GB memory). No discernible difference.
Followed the advice on this page to tweak my sendmail configuration. Again, this doesn't appear to have improved matters.
Watched the output from
topwhile submitting a bug. Nothing seemed to hog resources.
Can anyone advise on my next best step to troubleshoot the cause of my performance problems? It wouldn't surprise me if the bottleneck is related to MySQL but how can I determine that?