SMF Support > Server Performance and Configuration

SSD vs RAM for MySQL

<< < (3/4) > >>

Joshua Dickerson:
Forum Labs, what are you spending for your server now?

If you're using 4 drives (or two pairs), you'd want to give the data directory its own drive or at least move it to a drive that you'll use less often.

A couple of changes to the filesystem:

•   ext4 instead of ext3
•   Noatime
•   Barrier=0: http://www.slideshare.net/matsunobu/linux-and-hw-optimizations-for-mysql-7614520 / http://www.slideshare.net/matsunobu/linux-performance-tuning-stabilization-tips-mysqlconf2010  (page 17) (Yoshinori Matsunobu is one of the leading experts in MySQL optimizations) http://kerneltrap.org/mailarchive/linux-ext4/2009/9/11/6399013
•   Dir_index
•   Vm.swapiness=1 (not 0 because we aren’t completely in RAM)
•   Huge Page Support: http://vekseid.com/blogs/vekseid/optimizing_a_server_for_mysql

All of those will help you out a lot. Of course, if you don't have a BBWC, I wouldn't go with the barrier=0 option.

Joshua Dickerson:
I forgot to mention, might want to use Barracuda engine on Percona and compress your tables. That will help you get more CPU usage and less memory/disk usage.

Forum Labs:
My current server only costs me $80 monthly

4GB RAM
C2Q Q6600
2x250GB

Thanks for sharing those links :)

Is percona a replacement to mysql? I might just upgrade to mysql 5.5 since I am too busy right now.

Thanks everyone

Joshua Dickerson:
Yes, Percona is a drop-in replacement to MySQL. Meaning, you don't need to make any changes to your application to make it work. It works well with SMF. Are those drives in a RAID config?

vegita:
SSD is very fast and reliable, my db is about 20 Gigs, and RAM is 32 GB, But i see lot of performance is with SSD hardisk itself, go with it .

Navigation

[0] Message Index

[#] Next page

[*] Previous page