Hi all, I'm looking at my wiki's mysql database using phpMyAdmin and I see that the page table defines the primary key (page_id) as an unsigned int(8). Which got me thinking, 1) what is the maximum number of wiki articles possible and 2) what is the failure mode (i.e what happens). Does it generate an error? Does is apologize? Also, does moving a page bring the wiki one step closer to its limit?
thanks, - rich (revansx)
On 13/04/07, revansx@cox.net revansx@cox.net wrote:
Hi all, I'm looking at my wiki's mysql database using phpMyAdmin and I see that the page table defines the primary key (page_id) as an unsigned int(8). Which got me thinking, 1) what is the maximum number of wiki articles possible and 2) what is the failure mode (i.e what happens). Does it generate an error? Does is apologize? Also, does moving a page bring the wiki one step closer to its limit?
http://www.mysql.org/doc/refman/5.0/en/numeric-type-overview.html seems to indicate that the maximum possible number of pages would be 4 294 967 295, which...is a lot of pages.
I would assume the failure mode would throw up some sort of database exception, since the column is unsigned, it would overflow back to 1. I'm not quite sure if MySQL explicitly detects this condition in an autonumbered column, but either way, I would anticipate a database error.
Moving a page to a new title will typically create a new page record unless the old page is a redirect that's being "deleted" in the process, so yes, it would bring you closer to the limit.
Rob Church
I will sleep well tonight - lol
thanks Rob, - rich (revansx)
----- Original Message ----- From: "Rob Church" robchur@gmail.com To: "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Sent: Friday, April 13, 2007 6:32 PM Subject: Re: [Mediawiki-l] Where the wiki sidewalk ends?
On 13/04/07, revansx@cox.net revansx@cox.net wrote:
Hi all, I'm looking at my wiki's mysql database using phpMyAdmin and I see that the page table defines the primary key (page_id) as an unsigned int(8). Which got me thinking, 1) what is the maximum number of wiki articles possible and 2) what is the failure mode (i.e what happens). Does it generate an error? Does is apologize? Also, does moving a page bring the wiki one step closer to its limit?
http://www.mysql.org/doc/refman/5.0/en/numeric-type-overview.html seems to indicate that the maximum possible number of pages would be 4 294 967 295, which...is a lot of pages.
I would assume the failure mode would throw up some sort of database exception, since the column is unsigned, it would overflow back to 1. I'm not quite sure if MySQL explicitly detects this condition in an autonumbered column, but either way, I would anticipate a database error.
Moving a page to a new title will typically create a new page record unless the old page is a redirect that's being "deleted" in the process, so yes, it would bring you closer to the limit.
Rob Church
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Keep on sleepin' <grin> -- at one page per second, every hour of every day, that's 136 years and 37 days of pages before "the sidewalk ends".
Put another way, that's 2462 times the size of English Wikipedia.
-- Joshua
On 4/13/07 3:38 PM, "Richard Evans" revansx@cox.net wrote:
I will sleep well tonight - lol
thanks Rob,
- rich (revansx)
----- Original Message ----- From: "Rob Church" robchur@gmail.com To: "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Sent: Friday, April 13, 2007 6:32 PM Subject: Re: [Mediawiki-l] Where the wiki sidewalk ends?
On 13/04/07, revansx@cox.net revansx@cox.net wrote:
Hi all, I'm looking at my wiki's mysql database using phpMyAdmin and I see that the page table defines the primary key (page_id) as an unsigned int(8). Which got me thinking, 1) what is the maximum number of wiki articles possible and 2) what is the failure mode (i.e what happens). Does it generate an error? Does is apologize? Also, does moving a page bring the wiki one step closer to its limit?
http://www.mysql.org/doc/refman/5.0/en/numeric-type-overview.html seems to indicate that the maximum possible number of pages would be 4 294 967 295, which...is a lot of pages.
I would assume the failure mode would throw up some sort of database exception, since the column is unsigned, it would overflow back to 1. I'm not quite sure if MySQL explicitly detects this condition in an autonumbered column, but either way, I would anticipate a database error.
Moving a page to a new title will typically create a new page record unless the old page is a redirect that's being "deleted" in the process, so yes, it would bring you closer to the limit.
Rob Church
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org