Create an Account
username: password:
 
  MemeStreams Logo

MemeStreams Discussion

search


This page contains all of the posts and discussion on MemeStreams referencing the following web page: MySQL InnoDB and Solaris/Opteron forcedirectio (Performance Tuning Tips). You can find discussions on MemeStreams as you surf the web, even if you aren't a MemeStreams member, using the Threads Bookmarklet.

MySQL InnoDB and Solaris/Opteron forcedirectio (Performance Tuning Tips)
by Lost at 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.


 
 
Powered By Industrial Memetics