Increase by 30% the efficiency of MYSQL
Pseudonyme
Dear all,
Do you know how to increase by 30 % the performance of a Mysql 2006
version ?
1) Case :
A. MySQL Server has a lot a connections from a lot of parties.
B. The Fiduciary querries are mainly select querries (44%) to a single
30 tables database. 5 of these tables has between 10.000 to 20.000
lines.
2) Temp_research report
We were thinking of :
Handler_read_rnd : may be too much querries analyse the tables
Opened_tables : may be to diminish this value in order to increase the
cache
key_buffer_size : that one may be should be increased
max_connections : some benchmarks, MySQL MVP are mentioning a 500 to a
1000 value
record_buffer : it may be increased by 20 to 40% to feed the thread
and enhance searches.
sort_buffer : may be each thread could be decreased in weight (many
users with simple querries)
table_cache : that one could be managed with a correlative analysis of
options
thread_cache_size : I will increase in case of 'too much connection"
That's a temp_research report : the Fiduciary trusts mas-o-menos our
temp_analysis.
3) Do you believe it is possible to gear Mysql variables to speed up
Mysql by 30% ?
Server status : http://tinyurl.com/33a6dm
Variables : http://tinyurl.com/3bumg7
Do you believe it is possible to gear Mysql variables to speed up
Mysql by 30% ?
We believe in your comments that might help hundreds of persons.
Thank you for your feedback from your knowledge and experience.
Norm/Bob
John Murtari
> 1) Case :
> A. MySQL Server has a lot a connections from a lot of parties.
> B. The Fiduciary querries are mainly select querries (44%) to a single
> 30 tables database. 5 of these tables has between 10.000 to 20.000
> lines.
>
>
> 3) Do you believe it is possible to gear Mysql variables to speed up
> Mysql by 30% ?
>
> Server status : http://tinyurl.com/33a6dm
>
> Variables : http://tinyurl.com/3bumg7
>
Looks like you are not using the query cache, the size is 0,
you may want to try adding the following to your my.cnf
-----
# enable query caching
# How big the chache is
query_cache_size=20M
# the maximum size of any result set stored
query_cache_limit=2M
# type of chaching
query_cache_type=1
------
If there are not many writes to the tables you should see
a noticable performance change.
Best regards!
--
John
___________________________________________________________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/
Paul Lautman
> Dear all,
>
> Do you know how to increase by 30 % the performance of a Mysql 2006
> version ?
Why 30%?
What is special about 30%?
What actual problem are you seeing?