innodb_io_capacity tuning on a Linode SSD server

Hello,

How can I tune mysql config innodbiocapacity according to my Linode SSD server IOPS? I'm using a 4gb Linode Server and Mysql Community Server 5.6. I've been reading that the innodbiocapacity (default=200) should be equivalent to your server's IOPS, and 2000-4000 should be a good value for SSD servers. Have anyone seem any improvement in increasing the value of this configuration on a Linode SSD server?

0 Replies

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct