Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
surinp3 Posted July 3, 2014 Posted July 3, 2014 Just wanted to say, wow, about the difference between having your files and database on HDD vs files on HDD and database on SSD. Wanted to speed up my site a bit and after a bunch of optimizations of stuff and cache and so on software-wise, I decided to try moving database to SSD. Here are the results of todays server upgrade: Single HDD for files and databases with RAID1 before the upgrade: Separated database from HDD and setup to run from SSD (also RAID1): Very nice results... :D
mikaweb™ Posted July 3, 2014 Posted July 3, 2014 Nice. Can I ask you what do you use to get these charts? Thx
Rugger Posted July 3, 2014 Posted July 3, 2014 You see I have just bought an SSD for my laptop and wow it has sped everything up. If my host would allow me to buy an SSD, send it to them, and them fit it for a small fee it would be great. But no - they require that they supply it and the upgrade would be like $40pm. Which is not worth it but I would love it.
surinp3 Posted July 4, 2014 Author Posted July 4, 2014 Nice. Can I ask you what do you use to get these charts? Thx NewRelic - using free version and it is almost enough for me, but the paid version is too expensive.
Gabriel Torres Posted July 6, 2014 Posted July 6, 2014 Hi, I am optimizing my MySQL server as well and found this: innodb_page_size "Smaller pages might also be efficient with SSD storage devices, which typically use small block sizes. Keeping the InnoDB page size close to the storage device block size minimizes the amount of unchanged data that is rewritten to disk." Source: http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html Check this also: https://blogs.oracle.com/mysqlinnodb/entry/innodb_5_6_4_supports However, in order to convert the data you already have: If you want to use smaller page sizes with existing data, export the data first with a logical export utility such as mysqldump. Then create the new mysql instance with innodb-page-size=4k or 8k and import the data. Do not use a physical export method such as alter table … discard tablespace. Note: I haven't tried this yet. I hope this information helps. Also, if you are using Linux, I've just found out that TRIM is not enabled by default. You must change this. Please read: https://wiki.debian.org/SSDOptimization http://www.bitsbythepound.com/using-a-solid-state-drive-ssd-with-ubuntu-11-04-409.html http://apcmag.com/how-to-maximise-ssd-performance-with-linux.htm Gabriel.
Dmacleo Posted July 6, 2014 Posted July 6, 2014 use ssd here on few pcs and want to use on server also but its a $$ issue. choice is either 1 ssd or 2 500gb in raid 1 and I choose the redundancy. but when (if) I can afford 2 ssd in raid I would swap in a second.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.