LiteSpeed Technologies
Download Download     Blog Blog     Wiki Wiki     Forum Forum     Store     Contact Contact    

Go Back   LiteSpeed Support Forums > LiteSpeed Web Server > Install/Configuration > Optimization for a VPS 4GB running multiple wordpress sites

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-07-2012, 05:11 AM
yellowfrog yellowfrog is offline
New Member
 
Join Date: Jan 2012
Posts: 3
Default Optimization for a VPS 4GB running multiple wordpress sites

Hello

i have a 4GB VPS with LS/cpanel and 100WP Blogs.

Now I have problems since 2 weeks with the server load Up to 30.
where I can begin to reduce the server load.

in what configs I need to make settings ?


my.cnf
PHP Code:
[mysqld]
local-infile=0
datadir
=/var/lib/mysql
query_cache_limit
=3M
query_cache_size
=256M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections
=25
max_connections
=50
interactive_timeout
=30
wait_timeout
=120
connect_timeout
=20
thread_cache_size
=128
key_buffer
=128M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors
=20
max_allowed_packet
=16M
tmp_table_size
=256MB
max_heap_table_size
=256MB
table_cache
=4096
sort_buffer_size
=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M  ## 1MB for every 1GB of RAM
thread_concurrency=## Number of CPUs x 2
myisam_sort_buffer_size=64M
server
-id=1
innodb_buffer_pool_size
=2G

#slow_query_log = /var/log/mysql_slow_queries.log
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time 
2
log
-queries-not-using-indexes
# this can be used on your own wish.
#collation-server=latin1_general_ci

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid
-file=/var/lib/mysql/mysql.pid
open_files_limit
=10240

[mysqldump]
quick
max_allowed_packet
=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=32M
sort_buffer
=32M
read_buffer
=2M
write_buffer
=2M

[myisamchk]
key_buffer=32M
sort_buffer
=32M
read_buffer
=2M
write_buffer
=2M

[mysqlhotcopy]
interactive-timeout 
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 04:43 AM.



- Archive - Top
© Copyright 2003-2011 LiteSpeed Technologies, Inc. All rights reserved. Privacy Policy.