[horde] [whups] whups very slow after cvs update

[Volker Then]

Chuck Hagenbuch wrote:
> Quoting Volker Then <vt at volkerthen.com>:
> 
>> Yes, I had a look, but there is nothing suspicious to be found. I   
>> just can tell, that mysqld consumes up to 99% when horde/whups is   
>> querying the database. The upgrade tickets table (with "due date")   
>> is browsable with phpMyAdmin without any problems. Thereto the   
>> entire whups database is accessible with older versions of whups (as  
>>  of last month). So, I don't think it's a problem with the database   
>> but with the scripts accessing it.
> 
> While it's processing, try opening a MySQL shell and typing "SHOW  
> PROCESSLIST".
> 

Here's the relevant output:

| 1528 | horde  | localhost | bugs   | Query   | 34   | Copying to tmp
table | SELECT whups_tickets.ticket_id as id,
whups_tickets.ticket_summary as summary, whups_tickets.user_id |


Volker