Results 1 to 1 of 1
Thread: Optimize my.cnf on VPS
-
04-08-2011, 09:01 AM #1Web Hosting Evangelist
- Join Date
- Nov 2005
- Posts
- 539
Optimize my.cnf on VPS
After running a perl script mysql tuner, i got the following result... please suggest me what values need change to improve the performance and decrease the server load. These days server load is increased on my VPS.
[--] Total buffers: 1.2G global + 7.5M per thread (105 max threads)
[!!] Maximum possible memory usage: 2.0G (98% of installed RAM)
[OK] Slow queries: 0% (1/130K)
[OK] Highest usage of available connections: 23% (25/105)
[OK] Key buffer size / total MyISAM indexes: 544.0M/274.4M
[OK] Key buffer hit rate: 99.0% (353K cached / 3K reads)
[OK] Query cache efficiency: 77.1% (52K cached / 68K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts)
[OK] Temporary tables created on disk: 15% (140 on disk / 930 total)
[OK] Thread cache hit rate: 99% (25 created / 11K connections)
[OK] Table cache hit rate: 97% (572 open / 586 opened)
[OK] Open file limit used: 66% (1K/1K)
[OK] Table locks acquired immediately: 99% (30K immediate / 30K locks)
[mysqld]
skip-bdb
local-infile=0
query_cache_limit=4M
query_cache_size=160M
query_cache_type=1
max_user_connections=150
max_connections=105
interactive_timeout=100
wait_timeout=15
connect_timeout=20
thread_cache_size=320
key_buffer=544M
join_buffer_size=3M
max_allowed_packet=32M
table_cache=768
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_heap_table_size=240M
tmp_table_size=240M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=128M
server-id=1
local-infile=0
log-slow-queries=/var/log/slow_queries.log
long_query_time = 10
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=64M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
#[mysql.server]
#user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
#[mysqldump]
#quick
#max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=4M
write_buffer=4M
[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=4M
write_buffer=4M
[mysqlhotcopy]
interactive-timeout
Memory usage high on connection tracking and on following...
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.domain.com.pid --skip-external-locking
Similar Threads
-
Optimize my.cnf for my server
By chasebug in forum Dedicated ServerReplies: 1Last Post: 03-07-2011, 09:06 AM -
Need Help optimize my.cnf and httpd.conf
By bornic in forum Hosting Security and TechnologyReplies: 6Last Post: 08-29-2009, 09:59 PM -
Optimize my.cnf and httpd.conf ...
By mouseattack in forum Hosting Security and TechnologyReplies: 40Last Post: 03-27-2009, 03:26 PM -
Optimize my.cnf?
By AndyJ in forum Hosting Security and TechnologyReplies: 3Last Post: 04-18-2005, 03:14 PM -
Optimize MySQL my.cnf
By MattF in forum Hosting Security and TechnologyReplies: 1Last Post: 07-15-2001, 01:12 PM