Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Here is the configuration :
Bugzilla (3.4.2) application running on a Ubuntu server 8.04 with Perl 5.8.8.

Here is the problem :
Sometimes (randomly), pages take very long to load. It can be any of the login page or query.cgi page or buglist.cgi... etc...
Using top on the server, I tried to see what was wrong, and saw that sometimes a bugzilla script would use 30% memory and last pretty long (1 to 5 seconds) and sometimes not even show in the list because it responded too quickly or just use 2%. The mysqld process does not seems to be the problem.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Problem came from the configuration of the MySQL server. Indeed the InnoDB config options were too low (buffer pool size). Found a good link for that : http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/

share|improve this answer

Check your network interfaces for errors and retransmit counts. It you are dropping packets you may have to wait for timeouts before the packet is retransmitted. Any load graphs for the network would help as well.

share|improve this answer
    
Thing is that only the Bugzilla app is slow randomly, other services (in PHP) do not suffer any slowness –  Serty Oan Oct 6 '10 at 6:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.