View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000497 | WackoWiki | installer | public | 2018-04-26 07:47 | 2018-04-26 08:05 |
| Reporter | administrator | Assigned To | administrator | ||
| Priority | normal | Severity | minor | Reproducibility | sometimes |
| Status | resolved | Resolution | fixed | ||
| Product Version | 5.5.5 | ||||
| Target Version | 5.5.6 | Fixed in Version | 5.5.6 | ||
| Summary | 0000497: Optimized revision table UPDATE query for upgrade from 5.4.x | ||||
| Description | Hi! 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 Reproduce | Not optimal DB request during upgrade from 5.4.3 | ||||
| Additional Information | Source: https://wackowiki.org/doc/Comment604 | ||||
| Tags | No tags attached. | ||||
|
|
Commit: https://sourceforge.net/p/wackowiki/dev/ci/e3a65b08dbb4b781bce3db5000d52e2ffd724e6d Many Thanks to Mangalor |
| 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 | |
| 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 |
