Create an Account
username: password:
 
  MemeStreams Logo

MySQL InnoDB and Solaris/Opteron forcedirectio (Performance Tuning Tips)

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
MySQL InnoDB and Solaris/Opteron forcedirectio (Performance Tuning Tips)
Topic: Technology 1:54 am EST, Feb 27, 2007

(Verified using MySQL 4.1, assumed for other MySQL versions, given that this is a platform architecture issue.) When using the InnoDB storage engine on Solaris 10 for x86_64 architecture (AMD Opteron), it is important to to mount any filesystems used for storing InnoDB-related files using the forcedirectio option. (The default on Solaris 10/x86_64 is not to use this filesystem mounting option.) Failing to use forcedirectio will cause a serious degradation of InnoDB's speed and performance on this platform.

MySQL InnoDB and Solaris/Opteron forcedirectio (Performance Tuning Tips)



 
 
Powered By Industrial Memetics
RSS2.0