Hey,
Thanks for the reply, it's appreciated.
The 1.9 and 1.12 installs are running on the same machine, and are not
receiving any traffic other than my testing. 1.9 is pointing to a production
DB instance, both are pointing to the same MySQL server, but I changed the
wgProxyKey for both installs so they don't hit the live memcached, could 1.9
be getting some cached data from the production DB to make it perform
better?
I'll take a look into the extra queries, they could be coming from our
customizations and extensions.
This query occassionally takes a long time to execute, not sure why:
SELECT /* Parser::replaceLinkHolders */ page_id, page_namespace,
page_title, page_is_redirect FROM `page` WHERE (page_namespace=0 AND
page_title IN('Study-Better', 'Have-Fun-While-Studying',
'Socialize,-Be-Funny-and-Make-Friends',
'Create-Good-Study-Habits-for-Exams', 'Get-Good-Grades',
'Ace-Your-Next-Test', 'Get-Straight-A\'s',
'Upgrade-Your-Life-As-a-Teenager'))
I repaired all
of the tables in the 1.12 database
Are you using MyISAM? If so, why? MediaWiki isn't really designed
for it at all; it uses InnoDB-specific features like primary key
clustering heavily.
No idea! Is it possible because we originally created this DB with a MW 1.3
install, that not all the tables have been converted? It looks like our
`archive` table is MyISAM, but in the new MW installs, it's InnoDB. Should
we switch them all over to be Inno?
Why don't you use maintenance/update.php from a shell? It's almost
certain to be more reliable.
Cool, I didn't know this existed. I'll use this next time.