On 12 Feb 2004 at 11:57, Craig Jackson wrote: > 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.
You'd have to code that logic into your application, using Perl or PHP or C or whatever. Try the insert. If it fails, wait a second and try again with the new timestamp. Repeat until you succeed or until you've gone through some number of tries (at which point you give up). It's ugly, but that's what you asked for. How about converting the column to a BIGINT AUTO_INCREMENT with a new value of, say, 30000000000000? Then your old values would still be around with values like 20040212131422. That's also ugly, but not as ugly as the solution with waiting. -- 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]
