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

* Your Email Address
* Spam protection	Enter the letters below: .___.. .. ..__..___. _/ \| \|\|_/ [__] \| ./__.\|/\\|\| \\| \| \|
Comment	> Add. Note: After applying the patch the load on the database server > went from 15-20 down to 0.xx > > This is the patch: > > --- /usr/share/php/Horde/History/Sql.php 2013-07-15 > 03:06:20.976871299 +0200 > +++ /xxx/Horde/History/Sql.php 2013-07-22 11:23:27.641122721 +0200 > @@ -293,10 +293,11 @@ > */ > public function getHighestModSeq($parent = null) > { > - $sql = 'SELECT MAX(history_modseq) FROM horde_histories'; > + $sql = 'SELECT history_modseq FROM horde_histories'; > if (!empty($parent)) { > $sql .= ' WHERE object_uid LIKE ' . > $this->_db->quote($parent . ':%'); > } > + $sql .= ' ORDER BY history_modseq DESC LIMIT 1'; > > try { > $modseq = $this->_db->selectValue($sql);
Attachment
Watch this ticket