-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sean Kelly wrote: > Isn't that the 1024 bug, no more that 1024 Inno transactions at a time?
Hmm, I just saw this: http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_undo_slots Perhaps we need to only bench readwrite on XtraDb? InnoDB team, if you're listening, this should be addressed :) - -jay > On Mon, May 4, 2009 at 4:09 PM, Jay Pipes <[email protected]> wrote: > 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 >> _______________________________________________ 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkn/eq0ACgkQ2upbWsB4UtFcCACfRtA67KXErtXiBBpqLyQaFiKc +lsAoIa+6TS1igTu+QHsboR/pqUo6aoT =xeTn -----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
