tag:blogger.com,1999:blog-31421954.post2022096318285825592..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : So, why use mySQL 5.0Dathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-31421954.post-8583199162819767322007-03-22T11:40:00.000-07:002007-03-22T11:40:00.000-07:00Also, in a failure scenario like servers died or u...Also, in a failure scenario like servers died or user error caused a deletion of the table, it's easy to recover the last increment and get up in a matter of minutes, while the random number approach would be disastrous.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-22303752837634284152007-03-22T11:16:00.000-07:002007-03-22T11:16:00.000-07:00To ensure that the random number is unique a list ...To ensure that the random number is unique a list must be kept to ensure that the random number is not generated again. This would require a table with 100s of millions of rows.<BR/><BR/>Incrementing a number requires a table with only 1 row.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-7462015902515208962007-03-21T22:26:00.000-07:002007-03-21T22:26:00.000-07:00Probably missing something, but why not use random...Probably missing something, but why not use randomly generated numbers as primary keys?Anonymousnoreply@blogger.com