bugphpGroupWare - Bugs: bug #1192, MYSQL raise 50% CPU and httpd 45%...


You are not allowed to post comments on this tracker with your current authentication level.

bug #1192: MYSQL raise 50% CPU and httpd 45% when asking 2000 tickets

Submitted by:  Sebastien MAYER <sebmay>
Submitted on:  Thu 12 Sep 2002 09:20:25 PM UTC  
Item Group: SVN trunk (dev code)Category: tts
Severity: 4 - ImportantPriority: 3 - Low
Status: NonePrivacy: Public
Assigned to: Lars Piepho <lpiepho>Open/Closed: Open
Component Version: NoneOperating System: GNU/Linux - Mandrake
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Tue 20 Jan 2004 04:14:40 AM UTC, comment #1:

I just created 30,000 contacts and the addressbook ran just fine, as far as list, add, and view contact.

Yes, there is a problem with TTS. Most of TTS needs to be re-written, its making a ton of redundent querys. This won't happen durring .16 ... I can't promiss anything for .18 either, it will happen in time.

Joseph Engo <jengo>
Project Administrator
Thu 12 Sep 2002 09:20:25 PM UTC, original submission:

In general in 14RC3, when you try to get lot of records, you notice an horrible response time.
What is lots : 2000 tickets for example.
On Linux, asking 2000 records to Mysql is just a snap. But when you ask PhpGroupware to show all tickets (closed and open) and you have 2000 of them, you simply pass the 30 seconds and get rejected by PHP. We will not increase this tempo : Just create 1000 contacts in the address book. Try to display them one shot....and get crazy.

My question : Is this solved in the .14 release ?

If not : It seems that you do like asking all records with an individual Mysql select ! Or you may read all of them one shot, but then get some linked information in another file one after the other... Like 2001 connection and selects.
Then better load all linked info in one table, then read all selected records in one select, and then do the links with PHP reading memory indiced table.

Please do the following test : create a big base ! Create 10 000 contacts ! then travel down the base...

Every guy using the addressbook does it because : he got a large amount of contact, and they are many guys to share the contacts. If it is not the case, they use the integrated address book of theire local outlook/netscape etc...

Briefly : reading into Mysql should use 1 or little number connection, and 1 or little number of select. And accept to manage numbers like many tousands as regular and normal value.

Got Comments ?

Sebastien MAYER <sebmay>


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.


Please enter the title of George Orwell's famous dystopian book (it's a date):



Follow 5 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 20 Jan 2004 11:51:18 AM UTCpowerstatAssigned toNone=>lpiepho
Tue 20 Jan 2004 04:14:40 AM UTCjengoSeverity3 - Normal=>4 - Important
  Priority5 - Normal=>3 - Low
Tue 17 Sep 2002 02:47:13 AM UTCcebItem Group0.9.14 RC3=>(Error - Not Found)
Mon 16 Sep 2002 11:25:45 PM UTCskwashdCategoryNone=>(Error - Not Found)

Back to the top

Powered by Savane 3.1-cleanup1