6.0.0-beta13
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/11/26
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers