UESPWiki:Upgrade History

The UESPWiki – Your source for The Elder Scrolls since 1995

Jump to: navigation, search

If you have any feedback on a particular upgrade, please add it to this page's discussion.

[edit] 27 March 2008

Setup a redirect on content1 from www.uesp.net/phpbb to forums.uesp.net to try to prevent caching issues of old links to the forum.

[edit] 21 February 2008

Set the $configdate in LocalSettings.php on content1 to force invalidation of entire Wiki cache. This will force the various changes done over the past few weeks to be applied to everyone.
While Google analytics was removed from the site the cookie will still be present in returning visitors browsers which will prevent the main content page from being cached for anonymous users. Looking at Squid settings there seems to be no simple method to ignore the presence of a particular cookie.

[edit] 20 February 2008

Installed and enabled Tidy on the Wiki.
Installed the ProtectSection extension as requested.
Disabled the use of Google Analytics as it may have been interfering with the caching of the main content pages due to use of cookies. Changes will likely take a while to propagate through the cache but will keep an eye on the cache utilization (currently averaging 60% cache hits) and see if there's any improvement.

[edit] 19 February 2008

Reduced MaxRequests to 1000 from 10000 on content1. This will cause the Apache child threads to restart more often reducing their memory consumption some.
Removed "ignore-private" on squid1 for default objects. This might/should eliminate issues with logging in that have been reported.

[edit] 17 February 2008

Turned off KeepAlive and compression off content1 to try and get some better performance out of it.
memcached on content1 is up to 120MB of memory.
Removed sidebar ad unit on wiki. It has lower click thru than bottom ad unit and removing it cleans up the display, especially for short pages.
Removed Google search on sidebar (barely used).
Removed top text ad unit on forms and added bottom image ad unit.
Added "forums.uesp.net" option in Google search box on the forums. Fixed issue with search form not working on topic pages.
Added the scripts countconn and countips to squid1 for easily checking the number of incoming connections.
Turned on Apache access logs on content1 with a daily rotation for more accurate traffic count.
Tweaked some MySQL settings on content1. Set thread_cache from 0 to 8, thread_concurrency from 2 to 8.
Reverted the CSS settings in the forums for the color of the main scroll bar (from beige to whatever the default is).

[edit] 7 February 2008

Optimized 3 images on the main page (2 logos and background) by saving as JPEG. Went from 96.8 kb to 18.0 kb saving 88.8 kb. This reduces the total size of the main page by almost one half (from 181 to 92 kb)!
Added expires headers on content1 to some files that didn't have it (/w/images and /w/index.php).
Tried again to remove the ETag header from all files. Some files still have it for despite it being completely disabled in Apache. Perhaps MediaWiki is adding the header or it is a caching issue( not a big deal anyways).
Minified wikibits.js and ajax.js with JSMin for an overall savings of 14kb (5kb after compression).
Testing site in YSlow yields a score of C(74) compared to a few months ago we scored a solid F(?). The way things are scored we are probably closer to a B (Google ads, Etags, CDN all the lower score) and with a little further tweaking an 'A' might even be possible.
Note that moving wikibits.js to load from the bottom of the page rather than the top resulted in some minor display issues in Firefox (change was undone).
Set $wgSquidMaxage to 2678400 (31 days) from the default 18000 seconds (5 hours) on content1. Could not figure out how to set it to 0 like Wikipedia.

[edit] 6 February 2008

Installed mod_gzip on content1. All text/html, js, and css pages should be compressed if the client supports it.
Turned ETags off on content1.

[edit] 5 February 2008

Turned KeepAlive on for content1 (1 second timeout).

[edit] 4 February 2008

Re-enabled the daily auto-restart of Apache on content1 to clear any lingering connections.
Reduced MaxClients to 60 on content1.
Enabled memcached on content1 with an intial size of 256MB. Will monitor performance and adjust size as needed. After 1 day memcached memory use is up to 50MB.

[edit] 1 February 2008

obmap.uesp.net and simap.uesp.net forward to the relevant map (shorter URLs to remember for people wanting to quickly get to the maps). maps.uesp.net currently forwards to the Oblivion map but may eventually go to a general map/index page leading to all available maps.

[edit] 29 January 2008

Edited various Apache ExpiresDefault and Squid refresh_pattern settings in order to cache more cacheable content. May need to still make changes in order to make sure any cacheable stuff is properly cached and any uncacheable stuff is not. Short term saw a small increase in cached objects from 50 to 65%.

[edit] 28 January 2008

Re-enabled ob_gzhandler in LocalSettings.php.
Changed namespace spelling from "Talk" to "talk".
Random pages should no longer display talk or any pages with a "/" in them.

[edit] 25 January 2008

Fixed issue with Oblibion/SI maps not showing images.
Installed sar (SysStat) on both content1 and squid1 servers.

[edit] 24 January 2008

Switched the DNS entries for uesp.net and www.uesp.net to point to squid1.uesp.net. Squid settings will still have to be checked and confirm its caching things correctly. As it is now it might be just passing most requests through.
Disabled the mod_limitipconn and mod_evasive Apache modules as they were causing issues with the Squid cache. Will need to confirm and check settings and renable at some point.
Reset the Apache Timeout setting to 300.

[edit] 23 January 2008

Enabled mod_expires in the Apache web server and made some initial settings as listed on the talk page.
Turned on the Squid settings in MediaWiki.
Received the squid1.uesp.net server and setup the Squid cache. While it is currently working it seems it is not caching the Wiki pages (requests go straight through). Note that uesp.net still points to the main content server (content1.uesp.net) and won't be switched to squid1 until it is confirmed as working.
Changed Timeout from 300 to 60 on the Apache web server.

[edit] 15 January 2008

Changed wait_timeout from the default 28800 to 90 seconds in MySQL.
Changed the ad panel to a single 120x600 unit (text and image).
Added ad panel at bottom of page (image ads).
Turned KeepAlive off.

[edit] 14 January 2008

Ran Optimize Table on all tables in the wiki database. Tables that seemed most in need of it, based on time required to run optimization, were searchindex (34.5 seconds), pagelinks (13.2), and revision (12.8).

[edit] 9 January 2008

Gave the admin group write access to Oblivion's alchemy, map, and simap directories.

[edit] 8 January 2008

Enabled KeepAlive on the Apache web server with a timeout of 1 second to observe any change in performance.

[edit] 4 January 2008

Tweaked web server settings. Increased MaxClients from 75 to 100. Changed MaxRequests from 0 (unlimited) to 10000.
Disabled gzip compression of Wiki content (unsure if this has any effect with current web server settings).

[edit] 3 January 2008

Reset $wgAjaxSearch = false
Reset $wgDisableCounters = false (no performance change noted)
Reboot server for the first time in 6 months to see if performance issues are resolved.
Disabled web server automatic restarting every day (testing performance after reboot).
Setup ssh/sudo access for Nephele to be able to restart web server if needed.
Apparently the mail setup was allowing anyone to send mails through the server. Temporary shutdown smtp to note any performance affects (needs to be permanently fixed).

[edit] Archives

[edit] Wiki Upgrade Procedure

This is mainly a reminder to myself as to what needs to happen during the typical Wiki upgrade.

[edit] Offline Upgrade

Since we've made a number of changes to the base MediaWiki installation the steps to upgrade a new release of the Wiki are given below.

Download the Wiki release
Copy AdminSettings.php and LocalSettings.php
Delete the config directory
Copy the extensions directory
Copy includes\SpecialActiveUsers.php
Copy the main logo image skins\common\images\wiki.png
Modify includes\SpecialSearch.php (lines 61-63, 102-184, 233-263, 358-361, 365-368, 387-389, 391-587, 589-594) and includes\SearchMySQL.php (lines ) with the site specific search engine changes
Update getThumbnails() (lines 1048-1070) in includes\Image.php
Update SQL queries in SpecialLonelypages.php (lines 34-47), SpecialRandompage.php (lines 73-79, 103-111), SpecialPopularpages.php (no longer needed as of v1.10), SpecialShortpages.php (lines 35-43), SpecialUncategorizedpages.php (lines 31-42), SpecialAncientpages.php (lines 31-40), and SpecialNewpages.php (lines 48-68)
Modify includes\Sanitizer.php (lines ) to allow the tags kbd, q, dfn, abbr, and acronym (and others as needed) to the htmlpairs array and in the setupAttributeWhitelist function
Modify skins\MonoBook.php to move the search box upwards if desired and the ad sections (move p-search to below p-logo, add p-googlesearch and p-googleads to below p-lang). Add hidden inputbox within the searchform (lines 160-162).
Possibly modify skins\monobook\main.css to remove the clear parameter from the tleft and tright classes.
Modify extensions\SpamBlacklist\SpamBlacklist_body.php (lines 140-143).
Modify includes\Parser.php (lines 3728-3756).
Modify includes\SearchEngine.php (lines 57-128).

[edit] Site Upgrade

Upload modified Wiki to server in new directory
Set the owner/group of the entire new directory to the web server user
Create images symlink to the appropriate path in the new Wiki directory
Lock Wiki (add a line $wgReadOnly = "..." to LocalSettings.php).
Backup wiki and forums database
Backup current images directory
In the new Wiki change the wiki path in LocalSettings.php (this is for the update script to run properly)
Run update.php from the new Wiki maintenance path (/virtual/php5/bin/php -f update.php)
Change the wiki path back to the default in LocalSettings.php
Rename current wiki to another path (eg: w-old)
Rename new wiki to main wiki path
Test wiki running under the main wiki path
If there seems to be problems swap the old/new Wiki directories to their previous values and check settings
Unlock Wiki once things seem to be running well enough

Retrieved from "http://www.uesp.net/wiki/UESPWiki:Upgrade_History"