Editing MySQL

Jump to: navigation, search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 71: Line 71:
  
 
===InnoDB IO Capacity===
 
===InnoDB IO Capacity===
*This parameter should be set to approximately the number of I/O operations that the system can perform per second. You probably don't want to set this really high, otherwise the OS might suffer. For most SSDs, setting the capacity to 2000 - 4000 should be just fine, especially if the SSD is dedicated to MySQL. For slower, spinning disk systems you may not want to mess with this value at all. I've found that for the most part 2000 is a pretty decent value to start at.  
+
*This parameter should be set to approximately the number of I/O operations that the system can perform per second. You probably don't want to set this really high, otherwise the OS might suffer. I will do some testing with this, but I would imagine settings this anywhere from 5 - 10 x the default should be fine, depending on your storage system. I would start at 1000, or 2000 and raise this until you get the best performance. Settings this much above 20,000 might cause system issues.
 
<pre>
 
<pre>
 
# Default here is 200
 
# Default here is 200

Please note that all contributions to wiki.mikejung.biz may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see wiki.mikejung.biz:Copyrights for details). Do not submit copyrighted work without permission!

Cancel | Editing help (opens in new window)

Template used on this page: