Isn't that the 1024 bug, no more that 1024 Inno transactions at a time? On Mon, May 4, 2009 at 4:09 PM, Jay Pipes <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi! > > In running Drizzle benches, I'm running into the following when running > readwrite sysbench tests on our machine: > > 2009-05-04 14:02:39,950 INFO: Running sysbench config > innodb_1000K_readwrite for concurrency at 2048 - iteration 0. > 090504 14:03:41 InnoDB: Warning: cannot find a free slot for an undo > log. Do you have too > InnoDB: many active transactions running concurrently? > > This only occurs when concurrent connections > 1024 (we run our benches > up to 2048 concurrent connections). > > Is there an innodb server setting that I should change in order to get > around this problem? Here is what I am using: > > [drizzled] > > # Options provided directly to the drizzled server > # when the server is started. > > innodb_buffer_pool_size= 128M > innodb_log_file_size= 64M > innodb_log_buffer_size= 8M > innodb_thread_concurrency= 0 > innodb_additional_mem_pool_size= 16M > table_open_cache= 4096 > table_definition_cache= 4096 > > [sysbench] > > # Options given to the sysbench program on every iteration > > max-time= 60 > max-requests= 0 > test= oltp > drizzle-db= test > drizzle-port= 9306 > drizzle-host= 127.0.0.1 > drizzle-user= root > db-ps-mode= disable > db-driver= drizzle > drizzle-table-engine= innodb > oltp-read-only= off > oltp-table-size= 1000000 > > Any help is most appreciated! Thanks in advance! > > Jay > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkn/dY0ACgkQ2upbWsB4UtGkewCfVdsnS5FDBDFW5/wW1WB3qGZ3 > iN4AnjDH9BkWV566l8UqF2+KJglg7o4d > =XGTO > -----END PGP SIGNATURE----- > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
