Jump to content

Great improvements with SSD


Recommended Posts

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:

post-146012-0-35728000-1404385614_thumb.

Separated database from HDD and setup to run from SSD (also RAID1):

post-146012-0-32470600-1404385612_thumb.

Very nice results... :D

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...