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

* Your Email Address
* Spam protection	Enter the letters below: . ..__..__ . .. . \| \|[__]\| \\|\/\|\|_/ \|__\|\| \|\|__/\| \|\| \
Comment	> 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. >
Attachment
Watch this ticket