Gentlemen, if your personal Mediawiki wiki has been around since early
2007, you might want to clean out the thousands of Mediawiki:
namespace rows that were left in the database by
maintenance/deleteDefaultMessages.php . Wouldn't it make you feel good
to clean out thousands of wasted rows, leaving behind e.g., on a small
wiki, perhaps just a few hundred rows that are actually related to us?
I don't know why the design decision was made to just leave those
Mediawiki: namespace items sitting in the archive and text tables. But
OK, we proceed to clean them out by hand. I hope I got this right:
$ mysqlshow --count myDatabase > before.txt
$ mysql myDatabase
SELECT COUNT(*) FROM archive WHERE ar_namespace = 8 AND ar_user_text = 'MediaWiki default';
COUNT(*)
1518
DELETE FROM archive WHERE ar_namespace = 8 AND ar_user_text = 'MediaWiki default';
$ php purgeOldText.php --purge
Purge Old Text
Searching for active text records in revisions table...done.
Searching for active text records in archive table...done.
Searching for inactive text records...done.
1518 inactive items found.
Deleting...done.
$ mysql myDatabase
SELECT COUNT(*) FROM logging WHERE log_comment = 'No longer required' AND log_namespace = 8;
COUNT(*)
1510
SELECT MIN(log_timestamp),MAX(log_timestamp) FROM logging WHERE log_comment = 'No longer required' AND log_namespace = 8;
MIN(log_timestamp) MAX(log_timestamp)
20070226185326 20070226194040
DELETE FROM logging WHERE log_comment = 'No longer required' AND log_namespace = 8;
$ mysqlshow --count myDatabase|diff before.txt -|sed '/|/!d'
< | archive | 15 | 2206 |
> | archive | 15 | 688 |
< | logging | 10 | 2597 |
> | logging | 10 | 1087 |
< | text | 3 | 4466 |
> | text | 3 | 2948 |