-----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
