Re: random reads
Thanks Rick,
My key_buffer is 4G which is almost 25% of the RAM. My application is subjected to heavy load of queries almost 1000/s.
Currently, I have 20 threads connected to mysql.
Another interesting observation. When increase the number of threads that my client application is using to connect to mysql, my performance is reducing. In terms of benchmark; with 80 client threads connected, i m getting an avg of 300MiliS, while with 20 threads, this value is 70MiliS.
Can anyone tell me why?
Subject
Views
Written By
Posted
5785
February 05, 2009 05:32PM
2809
February 06, 2009 09:53PM
Re: random reads
2836
February 10, 2009 06:10PM
2658
February 14, 2009 12:50AM
2482
February 23, 2009 11:53PM
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.