Hi, yesterday I installed Solaris 01/08 on a Sun's server with two 2Ghz Opterons and 2 GB ram (I don't remember the model of the server but it's one of those 1U rack-mountable servers with -hideous- rocket-loud fans that never slow down, maybe VX2200 ? )
I configured the bundled Mysql 5.0.xx to work on a ZFS pool made on a raid1 on the 2 bundled disks, but although I followed all the tuning tips found in various Sun bloggers, that can be resumed as: - limiting zfs's usage of memory to 256MB (appending to /etc/system set zfs:zfs_arc_max = 0x8000000 and rebooting, hopefully I did the right thing) - increasing up to 1.5GB the parameter innodb_buffer_pool_size and up to 48M innodb_additional_mem_pool_size (in steps, of course) - trying innodb_flush_method = O_DIRECT - zfs's recordsize=16k on that particular pool, set before creating a single file on it the performance is simply despairing. Just to give you and idea: an import from a 7 MB SQL dumpe takes 9 seconds if I set engine=myisam, and 98 seconds if engine=innodb. Considering that both myisam and innodb tables are stored on the same zfs pool and on the same directory I daresay that there's something extremely wrong in the interaction of my innodb with zfs. I hope that someone can help me. Thanks, Nico _______________________________________________ opensolaris-discuss mailing list opensolaris-discuss@opensolaris.org