When using the InnoDB storage engine on Solaris 10 for x86_64 architecture (AMD Opteron), it is important 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 option.) Failure to use forcedirectio causes a serious degradation of InnoDB's speed and performance on this platform.
InnoDB tuning issues on ZFS... MySQL AB :: MySQL 5.0 Reference Manual :: 14.2.11 InnoDB Performance Tuning Tips |