Re: transaction rate drops gradually
Posted by:
Aftab Khan
Date: April 17, 2009 03:21AM
Can you list the number of operations each of your SP perform?
Also do you observe any innodb DEADLOCKS?
Trun this OFF innodb_doublewrite (This variable can be turned off with --skip-innodb_doublewrite for benchmarks or cases when top performance is needed rather than concern for data integrity or possible failures.)
if possible try using the InnoDB plugin version 1.0.3 available at InnoDB.com
Try to test innodb_concurrency_tickets between 10000, 5000, and 500; innodb_thread_sleep_delay between 20000, 10000, and 5000; and innodb_thread_conncurrency between 8, 6, and 4
One more thing I'll like you to do , if your CPU has HyperThreading, turn it off.
Edited 3 time(s). Last edit at 04/17/2009 03:42AM by Aftab Khan.
Subject
Views
Written By
Posted
3984
April 15, 2009 12:38PM
1968
April 16, 2009 04:35AM
1963
April 16, 2009 06:36AM
Re: transaction rate drops gradually
2005
April 17, 2009 03:21AM
1902
April 26, 2009 11:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.