-----BEGIN PGP SIGNED MESSAGE-----
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.
-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9LGa9lyjUJM+7nP4RArx3AJ9swXHifi4jrENHU8N5sUxQFePAZQCeNBUx
E1SnUdn13xdqFvKSWRl5GXM=
=Re4/
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
