Nope - nothing close to 4GB or even 1GB... My greatest data file size is 80MB. The largest table is 1.7 million rows. I have databases with more and bigger files. I think my problem is that the table having the problem with auto increment is refreshed everyday (or even multiple times a day) by different automated programs running on various other machines. These updates run at different times and remove all of the records from the last run before repopulating the records. In most cases the largest value is pretty big so when a new recordis added the auto increment field just gets bigger and bigger since there is probably never a time where there are 0 records in the table. One would think that the value would not top out until 2^31 since I have it defined as a normal INT. I guess I can make it a BIGINT, but I think I will run into a problem eventually regardless how big I make the field...
Ken Menzel wrote: > But did you check if the file size is at 4Gig? This will cause > strange things to happen, mysql does not gice a nice error for this > condition. If the table was not created with MAX_ROWS option = to > some real large number like 500000000000, then you could be running > into a problem with the size of the MYD or MYI file. You can use the > ALTER statement to add this option to the table. > Hope this helps, > Ken > ----- Original Message ----- > From: "Bill Hess" <[EMAIL PROTECTED]> > To: "Keith C. Ivey" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, October 08, 2002 4:52 PM > Subject: Re: AUTO_INCREMENT max value... > > > >>Not really getting errors but getting warnings when inserting > > records > >>and having duplicate values since the primary key is the one that is >>auto incremented... >> >>Keith C. Ivey wrote: >> >>>On 8 Oct 2002, at 12:23, Bill Hess wrote: >>> >>> >>> >>>>What is the maximum value of an AUTO_INCREMENT field? I am >>> > currently > >>>>running into a maximum value of 296,995,724 on Solaris 8 using >>> > MySQL > >>>>3.23.42 - the field has been defined as an INT(11), which should >>> > be able > >>>>to handle a value bigger than what I am seeing - The DuBois MySQL >>> > book > >>>>states it should handle 2^31 which turns out to be 2,147,483,648 >>> >>> >>>What is the error message you're getting? Could it be that the >>>problem is the actually size of your data file (over 4 GB?) rather >>>than the value of the AUTO_INCREMENT? >>> >>>[Filter fodder: SQL] >>> >> >>-- >> >>Bill Hess >>Technology Resource Group >> >> >> >>-------------------------------------------------------------------- > > - > >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > >>Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > >> > > -- Bill Hess Technology Resource Group --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
