View Issue Details

IDProjectCategoryView StatusLast Update
0000497WackoWikiinstallerpublic2018-04-26 08:05
ReporteradministratorAssigned Toadministrator 
PrioritynormalSeverityminorReproducibilitysometimes
Status resolvedResolutionfixed 
Product Version5.5.5 
Target Version5.5.6Fixed in Version5.5.6 
Summary0000497: Optimized revision table UPDATE query for upgrade from 5.4.x
DescriptionHi!
I have WackoWiki 5.4.3 under CentOS 7.4 x64, PHP 5.4 and MariaDB 5.5. The database has about 4000 pages and 50000 revisions. During upgrade to WackoWiki 5.5.5 (PHP 7.1, MariaDB 10.2) the script setup/database_mysql_updates.php worked more one hour! This is too slow for such amount of records. Request $update_revision_r5_4_0 must be changed as:

--- setup/database_mysql_updates.php.orig
+++ setup/database_mysql_updates.php
@@ -133 +133 @@
-$update_revision_r5_4_0 = "UPDATE {$pref}revision AS r, (SELECT page_id, page_lang FROM {$pref}page) AS p SET r.page_lang = p.page_lang WHERE r.page_id = p.page_id";
+$update_revision_r5_4_0 = "UPDATE {$pref}revision AS r, {$pref}page AS p SET r.page_lang = p.page_lang WHERE r.page_id = p.page_id";

After that the script worked about 2 minutes.
Steps To ReproduceNot optimal DB request during upgrade from 5.4.3
Additional InformationSource: https://wackowiki.org/doc/Comment604
TagsNo tags attached.

Issue History

Date Modified Username Field Change
2018-04-26 07:47 administrator New Issue
2018-04-26 07:47 administrator Status new => assigned
2018-04-26 07:47 administrator Assigned To => administrator
2018-04-26 07:49 administrator Summary Optimized UPDATE query for revision table => Optimized UPDATE query for upgrade from 5.4.3
2018-04-26 07:49 administrator Steps to Reproduce Updated View Revisions
2018-04-26 08:02 administrator Status assigned => resolved
2018-04-26 08:02 administrator Resolution open => fixed
2018-04-26 08:02 administrator Fixed in Version => 5.5.6
2018-04-26 08:02 administrator Note Added: 0001005
2018-04-26 08:05 administrator Summary Optimized UPDATE query for upgrade from 5.4.3 => Optimized revision table UPDATE query for upgrade from 5.4.x