… Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a… Windows you do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT… to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits…
Comment: SysBench - benchmark tool
November 18, 2007 By 20 Comments
… on a Pentium 4 running FreeBSD 6.2 and it’s been a great tool providing great performance information when it comes to upgrading hardware components. I noticed that hardware components may have a substantial impact on MySQL‘s performance…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
…_creation Added extended statistics to slow log Adjust defaults with performance intention Added parameter to control checkpoint age Added recovery statisticsÂ…://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD. There is an… repo the upgrade becomes as easy as yum update MySQL-server-percona MySQL-client-percona The latest source code of XtraDB, including…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far… just 386MB). my question is: would i get an additional performance-benefit if i ‘refragment’ the ibdata-file by dropping / importing…
Post: 5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
… build 17 of MySQL with Percona patches is available. New features in the release: MySQL-5.0.83… mutex contention. It may help if you suffer performance loss when the working set does not fit…. Google’s style IO – innodb_io_patches.patch FreeBSD .tar.gz package for amd64 platform is available…
Comment: More on dangers of the caches
September 25, 2010 By 5 Comments
I found mysql will slow down after several runs. for example, if you … score, then second and third run, the performance is dropped, score is lower. On FreeBSD, my machine gave me 51000 queries/second…
