… can be enabled by –myisam_use_mmap=1 startup option. In this case instead of systems call MyISAM will use memcpy function. There is a… non-mmaped area we use pread/pwrite functions. To approve effectiveness of memory mapping several benchmarks: For benchmarks I used the sysbench tool and…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… do some benchmarks on my own. 2*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read… and sending it back to the client. I tested MyISAM with myisam_use_mmap option which did not seems to give any significant performance… best conditions I got about 13.5K queries/sec from MyISAM (double of Innodb already) which scaled to 70.000 queries…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
…MyISAM row cache in memcached could be interesting and actually not that hard to implement. We’ve recently implemented IO via mmap…data by same nodes. I have not benchmarked it however – should do once have a…it will be ready for serious production use. Speaking about Linux page cache efficiency – yes…
