{"id":531,"date":"2008-03-09T12:33:04","date_gmt":"2008-03-09T20:33:04","guid":{"rendered":"http:\/\/multimedia.cx\/eggs\/ids-in-db\/"},"modified":"2020-07-25T23:03:39","modified_gmt":"2020-07-26T06:03:39","slug":"ids-in-db","status":"publish","type":"post","link":"https:\/\/multimedia.cx\/eggs\/ids-in-db\/","title":{"rendered":"How Many IDs In A Database?"},"content":{"rendered":"<p>Current snapshot of the <a href=\"http:\/\/fate.multimedia.cx\/\">FATE<\/a> database:<\/p>\n<p><script src=\"https:\/\/gist.github.com\/multimediamike\/d4f9bdd96d03ffd2083ffb14a653bf8b.js\"><\/script><\/p>\n<p>And we&#8217;re just getting started. This might be construed as either long-term planning or silly paranoia, but I have started to wonder what it would take to overflow the id field of the test_result table. I&#8217;m not even sure how large it is. MySQL simply reports the database field as being type &#8220;int(11)&#8221;. I have read various bits of literature which do not give a definitive answer on just how many bits that is. Worst case, I am assuming 32 bits, signed, with a useful positive range around 2 billion. Suppose I ramp up to around 500 unique tests in the database (hey, with all the individual regression tests yet to be imported, as well as various official conformance suites, that&#8217;s actually a fairly conservative estimate) and add 6 more configurations to round out to 20. That means each build\/test cycle will generate 500 * 20 = 10000 test results. If there are 10 cycles on an average day, that means 100,000 test results per day and 3 million per month. That would last the 31-bit range for about 715 days, or nearly 2 years.<\/p>\n<p>Okay, I guess I will put off worrying about the implications for the time being. But I still need to revise the test_result table to be more efficient (i.e., quit storing the stdout field if it&#8217;s the same as was specified in the test specification).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Current snapshot of the FATE database: And we&#8217;re just getting started. This might be construed as either long-term planning or silly paranoia, but I have started to wonder what it would take to overflow the id field of the test_result table. I&#8217;m not even sure how large it is. MySQL simply reports the database field [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[],"class_list":["post-531","post","type-post","status-publish","format-standard","hentry","category-fate-server"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts\/531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/comments?post=531"}],"version-history":[{"count":2,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":4610,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts\/531\/revisions\/4610"}],"wp:attachment":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/media?parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/categories?post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/tags?post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}