Help! Have tried everything – Site still EXTREMELY slow at peak times!!
-
I know this is a long post, but I’d appreciate it greatly if some genius from the WP community could just take a quick look at it!
I have tried and tried to get some kind of answer to my woes.
I have a relatively popular site (about 750k – 1mm PV per month). It’s a beefy home page, and the site has quite a few plugins.
Can someone please take a look at my configuration settings to see if you can find some OBVIOUS errors that I could tweak to attain a temporary improvement in performance?
I have every known enhancement:
- WP-Cache
- eAccelerator
- SQL cache
- Varnish HTTP proxy cache
I have tried modifying my server settings based on what I’ve learned on the web. My.cnf file, http.conf, and more.
I have a dedicated Xeon 2.8ghz, 2GB ram, (2) SATA 80GB hard drives.
I also run OpenAds PHP banner software on the same server. Server up over 2MM ads per month. Not from the PHP database either, they’re local server based to relieve database congestion.
I’m running the following versions of the products:
- WP 2.0.11 (RC2)
- MySQL 4.1.22
- PHP 4.4.4
- Apache 1.3.37 (I think)
- Linux 2.6.9-42.0.10.ELsmp
I run the following Plugins:
– Adhesive
– Admin Drop down Menu
– Adsense-Deluxe
– AHCommentCentral (may not be needed going forward)
– Ajaxified Comment Preview (will accept anything similar)
– Akismet
– Audio Player (will probably be removed in to use external tools)
– Bannage (needed, but doesn’t always work properly)
– Breadcrumb Navigation
– Category Visibility (1.0.0b)
– Comment link target Blanker
– Customizable Post Listings (would want similar functionality)
– Democracy Poll (2.01) integral part of the site
– Email Users (used maybe 2x a year)
– Event Calendar – Integral part of the site
– Geo Press using Yahoo! – Integral part of the site
– Get recent comments – Integral part of the site
– Google (XML) sitemaps – needed.. using 3.0b7 now
– Inline RSS (kinda buggy, would take a viable alternative)
– Keyword Tags (.80) customized it heavily to make it work
– Link Trucator – to keep comment section from breaking the theme
– Live Calendar (may get removed)
– Nice Categories (inherent with the theme I use)
– Paged comments (must have, since many posts have over 500 comments)
– Post Levels (may remove this eventually)
– Post Query Accelerator (needed to keep performance acceptable, but will remove if 2.2 and HyperDB solves the problem)
– Quoter 1.1 – MUST HAVE, as it’s used 100’s of times daily. An alternative or improved code would be needed
– Related Posts – needed.. keeps readers interested in archived posts
– Rock You (used infrequently)
– RunPHP – must have for inserting certain ad-code in the posts
– Share This – included with every post
– Show Top Commentators – keeps users competitive
– Smiley Javascript buttons – also used daily by readers
– Text Link Ads – in the sidebar
– Themed login and Register – keeps readers from seeing the static wordpress landing page, and away from the dashboard
– Weasel’s login redirect / text change – see above
– WordPress Database backup
– WP-AddQuickTag – makes my posting easier
– wp-Cache – MUST HAVE to improve perfomance
– WP-MostCommentedPosts – another important feature
– WP-PostRatings – requiredLastly, here is my current My.CNF config settings.
Do you see anything in here that might be causing issues? Something BLATANTLY wrong with the settings that could be either bloating my mem usage or not using enough? MySQL is definitely the memory and speed hog, and I’d love to know if there is something here that looks wrong to you.
I know this is a long post, but I’d appreciate it greatly if some genius from the WP community could just take a quick look at it!MY.CNF:
————————–
[mysqld]
old_passwords=1
datadir=/var/lib/mysql
skip-locking
skip-innodb
safe-show-database
query_cache_limit=6M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=512
max_connections=2048 # four times max_user_connections, to support the ad software#delayed_insert_timeout=40
interactive_timeout=10
wait_timeout=15
connect_timeout=20
thread_cache_size=512
key_buffer=64M ## 32MB for every 1GB of RAM
myisam_sort_buffer_size=64M
join_buffer_size=8M
max_connect_errors=20
max_allowed_packet=64M
table_cache=2048
tmp_table_size=64M
max_heap_table_size=64M
record_buffer=2M
sort_buffer_size=2M ## 1MB for every 1GB of RAM
read_buffer_size=2M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
server-id=1long_query_time=1
#log-slow-queries=/var/log/mysql-slow.log
#log=/var/log/mysql-query.log[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————————-
Appreciate any help or advice anyone can provide. I’ve looked at all the different MySQL sites, and I cannot get consistent information, etc.
Thank you!
- The topic ‘Help! Have tried everything – Site still EXTREMELY slow at peak times!!’ is closed to new replies.