MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mark Matthews Date:July 10 2002 4:54pm
Subject:Re: Bug with AUTO_INCREMENT
View as plain text  
Hash: SHA1

Steve Hay wrote:
| Thomas Spahni wrote:
|> Steve,
|> I tried your example on MyIsam tables; no problems with auto_increment at
|> all, except for a few
|> ERROR 1040: Too many connections
|> when 100 scripts are inserting concurrently at full speed.
|> Thomas
| I've tried the same myself on MyISAM tables as well now, and I also
| found that there is no problem - it only seems to happen using BDB tables.
| However, I need to use BDB tables rather than MyISAM to get transaction
| support, which is required by the software that I'm working on.
| In fact, it seems that BDB tables work too if the transaction support is
| not used, i.e. set AUTOCOMMIT=1 and don't bother with explicit COMMIT
| statements.
| Maybe MySQL has a problem with AUTO_INCREMENT when used with transactions?

Is there a reason you can't use InnoDB tables? They are
transaction-capable, and they have a lot more active development on them
than BDB. They also support AUTO_INCREMENT.


Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla -


Bug with AUTO_INCREMENTSteve Hay10 Jul
  • Re: Bug with AUTO_INCREMENTRichard Fox10 Jul
  • Re: Bug with AUTO_INCREMENTSteve Hay10 Jul
    • Re: Bug with AUTO_INCREMENTThomas Spahni10 Jul
  • Re: Bug with AUTO_INCREMENTVictoria Reznichenko12 Jul
  • Re: Bug with AUTO_INCREMENTSteve Hay12 Jul
Re: Bug with AUTO_INCREMENTSteve Hay10 Jul
Re: Bug with AUTO_INCREMENTMark Matthews10 Jul
Re: Bug with AUTO_INCREMENTSteve Hay12 Jul