Knowledgebase
Mysql Optimizer paid or free
Posted by nibb, 05-16-2009, 10:55 AM | Hi, I have some mysql optimizer scripts which run on the command line and give you some basic advices on configuration edition and optimization.
Problem is they dont give to much data and you have to run it again and again and im not getting there yet...
They are very basic but I wonder if someone knows one that is powerfull for mysql optimization. I dont mind if its paid. For linux of course.
|
Posted by supportstaff, 05-16-2009, 11:10 AM | you can use mysql tuner.
install it as follows.
Download the latest version in plain text to your server with wget:
# wget mysqltuner.pl
Or, you can download the gzipped version:
# wget mysqltuner.pl/mysqltuner.pl.gz
To run the script, simply make it executable and run it:
# chmod +x mysqltuner.pl
# ./mysqltuner.pl
|
Posted by nibb, 05-16-2009, 11:12 AM | I use that exactly already and another one which i dont recall the name. Are their any others out there?
mysqltuner just never seems to be enought, no matter what i adjust another setting pops up.
|
Posted by supportstaff, 05-16-2009, 11:17 AM | Try this one buddy you will get the result.........
/etc/my.cnf:
[mysqld]
max_connections=500
max_user_connections=300
safe-show-database
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 15
connect_timeout = 15
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
net_read_timeout = 10
net_write_timeout = 10
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
[mysqldump]
quick
max_allowed_packet=16M
|
Posted by RHS-Chris, 05-16-2009, 12:26 PM | Mysqlreport is the other:
http://hackmysql.com/mysqlreport
|
|
Add to Favourites
Print this Article |
Also Read