SMF Support > Server Performance and Configuration
SSD vs RAM for MySQL
Mark Rose:
--- Quote from: Forum Labs on October 06, 2011, 10:24:52 PM ---I still do not know how you get your read request ratio from the values above. Can you please decode this for me ;)
--- End quote ---
read request ratio: (1 - Innodb_buffer_pool_reads / Innodb_buffer_pool_read_requests) * 100 = cached percentage
Your cached percentage is 99.999%, so you don't have a problem there. You could decrease your buffer pool size if you needed more RAM elsewhere.
--- Quote ---I am only getting 60,000 page views a day. The forum has 3,205,782 total posts.
Your forum looks more active have you considered using SSD? Or the performance of your current setup is enough? If your current setup can handle your forum without SSD maybe my server can do it as well.
--- End quote ---
My server is not far from the point where a standard hard drive's write latency is an issue (very small, occasional delays). When I upgraded the machine, I got a battery-backed RAID 5 setup and the cache handles the write bursts well.
--- Quote ---Here's my server load right now
--- Code: ---Operating System: CentOS release 5.6 (Final)
Processor: Intel® Core(TM)2 Quad CPU @ 2.40GHz (1600.000MHz)
Load averages: 2.12, 1.77, 1.68
Memory usage: 99.15% (3873496k / 3906684k)
Swap: 2.055% (172360k / 8385912k)
--- End code ---
I do not know if I actually need to upgrade my server or I just need to optimize mysql. I am already using nginx + PHP-FPM + APC
I would be getting this server if I need to upgrade :)
3.2GHz quad core Xeon E3-1230 CPU
16GB ram
2x 500GB 7200rpm Hard Drive in RAID1
Price: $150 monthly
--- End quote ---
Your load average is great. Turn on hyperthreading if you haven't (it's good with PHP). Your current machine is doing very well. You don't need more memory, and SSD probably wouldn't do much with your traffic levels. I'd recommend SSD if you were doing 250,000 pageviews a day or more.
Forum Labs:
--- Quote from: Mark Rose on October 07, 2011, 12:18:16 AM ---Your load average is great. Turn on hyperthreading if you haven't (it's good with PHP). Your current machine is doing very well. You don't need more memory, and SSD probably wouldn't do much with your traffic levels. I'd recommend SSD if you were doing 250,000 pageviews a day or more.
--- End quote ---
Thank you for all your advice :) I really appreciate it. I am always reading your posts as I am learning a lot from it.
BTW how do you monitor your pageviews? do you use google analytics? My 60,000 pageviews per day is from google analytics.
I visited my stats page today and check my older pageviews collected by SMF statistics and here it is
--- Code: ---2010-07-03 143,257
2010-07-04 149,114
2010-07-05 157,800
2010-07-06 156,194
2010-07-07 155,430
--- End code ---
That was last year and since then I turned off the counting of pageviews. It should have probably doubled by now if that stats is correct. I just turned on again the tracking of daily page views so I can check how many page views I am getting :)
Mark Rose:
Use the SMF stats. In that case, I'd certainly consider getting SSD. You don't need more RAM though. See if your host can slap in an extra drive.
Joshua Dickerson:
RAM and a couple more disk drives are a hell of a lot cheaper than a decent SSD. You're not going to see the results that you see in benchmarks with any old SSD. There are high-end, $15,000 drives, and low-end $300 drives. The difference is that the low-end is worse than a 10K SAS drive. Look at the numbers on them.
Another 2 drives and more RAM is a better option. You probably have a bunch of tweaking to do though. One of my favorite slide shows which I quote regularly - http://www.slideshare.net/matsunobu/linux-and-hw-optimizations-for-mysql-7614520
I regularly watch iostat and htop. Check your mount options if you think you're having drive issues - might be something there. Chances are, there are other problems. Check your slow query and fpm logs. Watch how much time each request takes. There's a lot of stuff to do before spending more money.
Although, $150 for that server is pretty good.
Mark Rose:
One other thing: I strong recommend running a recent 5.5 release from MySQL or Percona. The 5.5 series has a ton of performance improvements with regards to concurrent queries.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version