Re: Unique IDs

Thu, 12 Feb 2004 10:14:46 -0800

code it within your program. If this is in fact a primary key (whcih you seem to describe it as), then it should be distinct anyway. So do an INSERT IGNORE or even just an INSERT. It will fail upon duplicates. Check the affected rows or the insert_id (using whatever API you use to access MySQL), sleep for a second, then try the insert again. I doubt there's a good way to hang up the database on the issue.

Cheers;
-M



From: Craig Jackson <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "Keith C. Ivey" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique IDs
Date: Thu, 12 Feb 2004 11:57:24 -0600

On Thu, 2004-02-12 at 11:47, Keith C. Ivey wrote:
> Craig Jackson <[EMAIL PROTECTED]> wrote:
>
> > I have a very large web app that uses timestamp for unique IDs.
> > Everything was rolling fine until we started getting many users per
> > second, causing some of the unique IDs to not be unique -- users were
> > being assigned the same timestamp. Since the web app is so large we
> > don't want to change the method of assigning IDs as it would create a
> > major project.
>
> I don't understand.  If you're getting many users per second, and
> your timestamps have 1-second resolution, how could you possibly
> solve the problem without changing the method of assigning IDs?
> Are the "many users per second" periods just short bursts, and you're
> really only getting several hundred users per day?  If so, I guess
> you could keep waiting a second and trying the insert again, but that
> could lead to indefinite delays if traffic gets high.  I think you've
> got to bite the bullet and change the unique ID to something that's
> actually unique -- even an AUTO_INCREMENT would work.

Thanks for the speedy reply and I have already recommended
auto_increment for the solution. We do need that quick fix until the
problem is fixed. How would I go about making Mysql wait one second
between inserts. We only get about 1000 hits per day, but they tend to
be concentrated in short time intervals.


>
> --
> Keith C. Ivey <[EMAIL PROTECTED]>
> Tobacco Documents Online
> http://tobaccodocuments.org


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/photos&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to