git.heureux-cyclage.org - lhc/web/wiklou.git/commit

dépôts / lhc / web / wiklou.git / commit

author	Brad Jorsch <bjorsch@wikimedia.org>
	Tue, 12 Sep 2017 17:12:29 +0000 (13:12 -0400)
committer	James D. Forrester <jforrester@wikimedia.org>
	Fri, 23 Feb 2018 18:06:20 +0000 (10:06 -0800)
commit	27c61fb1e94da9114314468fd00bcf129ec064b6
tree	f5cc45ec82c54570b24c94cda7e0d0d249e010c6	tree \| snapshot
parent	0c712ce564e0bd53e28f2581a714ee8cd04b614c	commit \| diff

Add `actor` table and code to start using it

Storing the user name or IP in every row in large tables like revision
and logging takes up space and makes operations on these tables slower.
This patch begins the process of moving those into one "actor" table
which other tables can reference with a single integer field.

A subsequent patch will remove the old columns.

Bug: T167246
Depends-On: I9293fd6e0f958d87e52965de925046f1bb8f8a50
Change-Id: I8d825eb02c69cc66d90bd41325133fd3f99f0226

126 files changed:

RELEASE-NOTES-1.31		diff \| blob \| history
autoload.php		diff \| blob \| history
includes/ActorMigration.php	[new file with mode: 0644]	blob
includes/Block.php		diff \| blob \| history
includes/DefaultSettings.php		diff \| blob \| history
includes/EditPage.php		diff \| blob \| history
includes/Linker.php		diff \| blob \| history
includes/MediaWikiServices.php		diff \| blob \| history
includes/Revision.php		diff \| blob \| history
includes/RevisionList.php		diff \| blob \| history
includes/ServiceWiring.php		diff \| blob \| history
includes/Storage/RevisionStore.php		diff \| blob \| history
includes/Title.php		diff \| blob \| history
includes/actions/InfoAction.php		diff \| blob \| history
includes/api/ApiQueryAllDeletedRevisions.php		diff \| blob \| history
includes/api/ApiQueryAllImages.php		diff \| blob \| history
includes/api/ApiQueryAllRevisions.php		diff \| blob \| history
includes/api/ApiQueryAllUsers.php		diff \| blob \| history
includes/api/ApiQueryBase.php		diff \| blob \| history
includes/api/ApiQueryBlocks.php		diff \| blob \| history
includes/api/ApiQueryContributors.php		diff \| blob \| history
includes/api/ApiQueryDeletedRevisions.php		diff \| blob \| history
includes/api/ApiQueryDeletedrevs.php		diff \| blob \| history
includes/api/ApiQueryLogEvents.php		diff \| blob \| history
includes/api/ApiQueryRecentChanges.php		diff \| blob \| history
includes/api/ApiQueryRevisions.php		diff \| blob \| history
includes/api/ApiQueryUserContributions.php		diff \| blob \| history
includes/api/ApiStashEdit.php		diff \| blob \| history
includes/cache/UserCache.php		diff \| blob \| history
includes/changes/ChangesList.php		diff \| blob \| history
includes/changes/RecentChange.php		diff \| blob \| history
includes/changetags/ChangeTagsLogItem.php		diff \| blob \| history
includes/content/ContentHandler.php		diff \| blob \| history
includes/db/DatabaseOracle.php		diff \| blob \| history
includes/deferred/SiteStatsUpdate.php		diff \| blob \| history
includes/exception/CannotCreateActorException.php	[new file with mode: 0644]	blob
includes/export/WikiExporter.php		diff \| blob \| history
includes/filerepo/file/ArchivedFile.php		diff \| blob \| history
includes/filerepo/file/LocalFile.php		diff \| blob \| history
includes/filerepo/file/OldLocalFile.php		diff \| blob \| history
includes/import/WikiRevision.php		diff \| blob \| history
includes/installer/DatabaseUpdater.php		diff \| blob \| history
includes/installer/MssqlUpdater.php		diff \| blob \| history
includes/installer/MysqlUpdater.php		diff \| blob \| history
includes/installer/OracleUpdater.php		diff \| blob \| history
includes/installer/PostgresUpdater.php		diff \| blob \| history
includes/installer/SqliteUpdater.php		diff \| blob \| history
includes/jobqueue/jobs/RecentChangesUpdateJob.php		diff \| blob \| history
includes/libs/rdbms/database/IDatabase.php		diff \| blob \| history
includes/logging/LogEntry.php		diff \| blob \| history
includes/logging/LogPage.php		diff \| blob \| history
includes/logging/LogPager.php		diff \| blob \| history
includes/page/WikiPage.php		diff \| blob \| history
includes/revisiondelete/RevDelArchiveItem.php		diff \| blob \| history
includes/revisiondelete/RevDelArchivedFileItem.php		diff \| blob \| history
includes/revisiondelete/RevDelFileItem.php		diff \| blob \| history
includes/revisiondelete/RevDelList.php		diff \| blob \| history
includes/revisiondelete/RevDelLogItem.php		diff \| blob \| history
includes/revisiondelete/RevDelLogList.php		diff \| blob \| history
includes/revisiondelete/RevDelRevisionItem.php		diff \| blob \| history
includes/revisiondelete/RevisionDeleteUser.php		diff \| blob \| history
includes/specialpage/ChangesListSpecialPage.php		diff \| blob \| history
includes/specials/SpecialFileDuplicateSearch.php		diff \| blob \| history
includes/specials/SpecialLog.php		diff \| blob \| history
includes/specials/SpecialMIMEsearch.php		diff \| blob \| history
includes/specials/SpecialNewpages.php		diff \| blob \| history
includes/specials/SpecialRedirect.php		diff \| blob \| history
includes/specials/pagers/ActiveUsersPager.php		diff \| blob \| history
includes/specials/pagers/BlockListPager.php		diff \| blob \| history
includes/specials/pagers/ContribsPager.php		diff \| blob \| history
includes/specials/pagers/DeletedContribsPager.php		diff \| blob \| history
includes/specials/pagers/ImageListPager.php		diff \| blob \| history
includes/specials/pagers/NewFilesPager.php		diff \| blob \| history
includes/specials/pagers/NewPagesPager.php		diff \| blob \| history
includes/specials/pagers/ProtectedPagesPager.php		diff \| blob \| history
includes/user/User.php		diff \| blob \| history
includes/user/UserIdentity.php		diff \| blob \| history
includes/user/UserIdentityValue.php		diff \| blob \| history
includes/watcheditem/WatchedItemQueryService.php		diff \| blob \| history
maintenance/archives/patch-actor-table.sql	[new file with mode: 0644]	blob
maintenance/deleteDefaultMessages.php		diff \| blob \| history
maintenance/fixUserRegistration.php		diff \| blob \| history
maintenance/initEditCount.php		diff \| blob \| history
maintenance/migrateActors.php	[new file with mode: 0644]	blob
maintenance/mssql/archives/patch-actor-table.sql	[new file with mode: 0644]	blob
maintenance/mssql/tables.sql		diff \| blob \| history
maintenance/oracle/archives/patch-actor-table.sql	[new file with mode: 0644]	blob
maintenance/oracle/tables.sql		diff \| blob \| history
maintenance/orphans.php		diff \| blob \| history
maintenance/populateIpChanges.php		diff \| blob \| history
maintenance/populateLogSearch.php		diff \| blob \| history
maintenance/populateLogUsertext.php		diff \| blob \| history
maintenance/postgres/archives/patch-actor-table.sql	[new file with mode: 0644]	blob
maintenance/postgres/tables.sql		diff \| blob \| history
maintenance/reassignEdits.php		diff \| blob \| history
maintenance/rebuildrecentchanges.php		diff \| blob \| history
maintenance/removeUnusedAccounts.php		diff \| blob \| history
maintenance/rollbackEdits.php		diff \| blob \| history
maintenance/sqlite/archives/patch-actor-table.sql	[new file with mode: 0644]	blob
maintenance/tables.sql		diff \| blob \| history
tests/parser/ParserTestRunner.php		diff \| blob \| history
tests/phpunit/MediaWikiTestCase.php		diff \| blob \| history
tests/phpunit/includes/ActorMigrationTest.php	[new file with mode: 0644]	blob
tests/phpunit/includes/BlockTest.php		diff \| blob \| history
tests/phpunit/includes/CommentStoreTest.php		diff \| blob \| history
tests/phpunit/includes/PageArchiveTest.php		diff \| blob \| history
tests/phpunit/includes/RevisionDbTestBase.php		diff \| blob \| history
tests/phpunit/includes/RevisionTest.php		diff \| blob \| history
tests/phpunit/includes/Storage/RevisionStoreDbTest.php		diff \| blob \| history
tests/phpunit/includes/Storage/RevisionStoreRecordTest.php		diff \| blob \| history
tests/phpunit/includes/Storage/RevisionStoreTest.php		diff \| blob \| history
tests/phpunit/includes/api/ApiBaseTest.php		diff \| blob \| history
tests/phpunit/includes/api/ApiQueryRecentChangesIntegrationTest.php		diff \| blob \| history
tests/phpunit/includes/api/ApiQueryWatchlistIntegrationTest.php		diff \| blob \| history
tests/phpunit/includes/api/query/ApiQueryUserContributionsTest.php	[new file with mode: 0644]	blob
tests/phpunit/includes/auth/AuthManagerTest.php		diff \| blob \| history
tests/phpunit/includes/auth/CheckBlocksSecondaryAuthenticationProviderTest.php		diff \| blob \| history
tests/phpunit/includes/changes/RecentChangeTest.php		diff \| blob \| history
tests/phpunit/includes/import/ImportTest.php		diff \| blob \| history
tests/phpunit/includes/logging/LogFormatterTestCase.php		diff \| blob \| history
tests/phpunit/includes/page/WikiPageDbTestBase.php		diff \| blob \| history
tests/phpunit/includes/password/UserPasswordPolicyTest.php		diff \| blob \| history
tests/phpunit/includes/specialpage/ChangesListSpecialPageTest.php		diff \| blob \| history
tests/phpunit/includes/user/UserGroupMembershipTest.php		diff \| blob \| history
tests/phpunit/includes/user/UserTest.php		diff \| blob \| history
tests/phpunit/includes/watcheditem/WatchedItemQueryServiceUnitTest.php		diff \| blob \| history

Wiklou, le Wiki du Wiklou

RSS Atom