[Tickets #12476] Database running mad after update to 5.1.1

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12476
------------------------------------------------------------------------------
  Ticket             | 12476
  Created By         | marth at tsvschlieben.de
  Summary            | Database running mad after update to 5.1.1
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.1.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


marth at tsvschlieben.de (2013-07-19 06:54) wrote:

After updating to v 5.1.1 the database causes huge load while running  
queries of these type:

SELECT MAX(history_modseq) FROM horde_histories WHERE object_uid LIKE  
'turba:%';

mysql> EXPLAIN SELECT MAX(history_modseq) FROM horde_histories WHERE  
object_uid LIKE 'turba:%';
+----+-------------+-----------------+-------+-----------------+-----------------+---------+------+--------+-------------+
| id | select_type | table           | type  | possible_keys   | key    
           | key_len | ref  | rows   | Extra       |
+----+-------------+-----------------+-------+-----------------+-----------------+---------+------+--------+-------------+
|  1 | SIMPLE      | horde_histories | range | history_uid_idx |  
history_uid_idx | 767     | NULL | 999027 | Using where |
+----+-------------+-----------------+-------+-----------------+-----------------+---------+------+--------+-------------+
1 row in set (0.00 sec)

The system becomes nearly unusable because of these queries.