http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692015-03-10T11:42:15ZTYPO3 ForgeTYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=2521392015-03-10T11:42:15ZGerrit Code Review
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Under Review</i></li></ul><p>Patch set 1 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="http://review.typo3.org/37692">http://review.typo3.org/37692</a></p> TYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=2521442015-03-10T12:23:32ZGerrit Code Review
<ul></ul><p>Patch set 2 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="http://review.typo3.org/37692">http://review.typo3.org/37692</a></p> TYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=2521462015-03-10T12:44:53ZGerrit Code Review
<ul></ul><p>Patch set 1 for branch <strong>TYPO3_6-2</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="http://review.typo3.org/37698">http://review.typo3.org/37698</a></p> TYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=2521502015-03-10T13:01:08ZAndreas Fernandeza.fernandez@scripting-base.de
<ul><li><strong>Status</strong> changed from <i>Under Review</i> to <i>Resolved</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" title="[BUGFIX] Use "user_auth" index for DataHandler:printLogErrorMessages Add the database field "act..." href="http://forge.typo3.org/projects/typo3cms-core/repository/1749/revisions/bd64f55b29d21106f8abd79750df2bc1e73c595f">bd64f55b29d21106f8abd79750df2bc1e73c595f</a>.</p> TYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=2523862015-03-12T14:04:40ZChristian PlattnerChristian.Plattner@world-direct.at
<ul></ul><p>May I add that your modification "AND action<256" <strong>did not help</strong> improving the performance:<br /><pre>explain SELECT * FROM sys_log WHERE type=1 AND action<256 AND userid=1 AND tstamp=1425974587 AND error<>0;
+----+-------------+---------+------+-----------------+-------+---------+-------+-------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------+------+-----------------+-------+---------+-------+-------+-------------+
| 1 | SIMPLE | sys_log | ref | event,user_auth | event | 4 | const | 33532 | Using where |
+----+-------------+---------+------+-----------------+-------+---------+-------+-------+-------------+</pre><br />Still, many rows have to be read. If you had added "AND action in (-1,0,1,2)", only 4 rows had to be read.</p>
<p>Follow-up bug report <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Bug: [ad Bug #65634] Backend performance improvement: SQL Indexes not used in printLogErrorMessages (Closed)" href="http://forge.typo3.org/issues/65697">#65697</a> was created.</p> TYPO3 Core - Bug #65634: Backend performance improvement: SQL Indexes not used in printLogErrorMessageshttp://forge.typo3.org/issues/65634?journal_id=3813732018-10-02T11:45:12ZBenni Mackbenni@typo3.org
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li></ul>