As you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our…) and sources with patches here http://www.percona.com/mysql/5.0.75-b11/
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… buffer. To restrict to the too small value (e.g. 0) is not recommended for performance. If you don’t like… to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the each user threads…) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…,000,000 rows each. Total database size ~58GB. MySQL version: 5.5.16 Initial benchmark, which InnoDB configured for this hardware innodb… 3800M. InnoDB usually takes 75% mark as limit for “sync” stage ( 3800M * 0.75 = 2850M ). That is checkpoint age exceeds 75% sync mark, that… (“Log flushed up to” – “Last checkpoint at”) > “total log size” * 0.75 , then InnoDB is in “sync” mode. What to do? I…
Comment: 5.0.75-build12 Percona binaries
January 24, 2009 By 18 Comments
I downloaded http://www.percona.com/mysql/5.0.75-b12/source/mysql-5.0.75-percona-b12-src.tar.gz, but each time I try to decompress it, I get an error: mysql-5.0.75/Docs/INSTALL-BINARY mysql-5.0.75/Docs/manual.chm gzip: stdin: invalid compressed data…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query1370.50372.161… more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99 Query2NANANA Query3NANANA Query4NANANA Query5NANANA…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… of 4+4 striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There…_logging 1 225 ± 9 211 ± 3 0.94 213 ± 9 0.95 20 767 ± 41 730 ± 35…± 54 731 ± 12 0.98 703 ± 36 0.94 In this case every test was run 5 times and random measurement…_logging /no_logging 1 9512 8943 0.94 20 27675 25869 0.93 100 11609 11236 0.97 Conclusion From the all tests…
Post: Xtrabackup, doing once...
March 5, 2009 By 6 Comments
… for InnoDB / XtraDB engines for MySQL 5.0 / 5.1 versions. Currently we tested only for 5.0.75 / 5.0.77 and it works just fine. We… code version on Launchpad lp:~percona-dev/percona-xtrabackup/alpha-0.2 , after some polishing and more testing we will prepare…
Comment: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
May 11, 2009 By 12 Comments
Add my vote for back-porting! I haven’t had the time to test 5.1 enough to roll it out yet. I’ve used the 5.0.67 and 5.0.75 Percona builds, and they offer some real improvements over the vanilla build in our environment.
Comment: 5.0.75-build11 percona binaries
January 5, 2009 By 7 Comments
I installed the 5.0.75-build11 binaries. And it works great, only that I would not want error logging in syslog. Is there a way to disable it without compiling from sources without mysqld_safe_syslog-5.0.62.patch? I am using mysqld_multi script to start the instance. Thanks 
Comment: 5.0.75-build11 percona binaries
December 24, 2008 By 7 Comments
Yes, SHOW GLOBAL STATUS LIKE ‘Questions’; looks right. I upgrade from 5.0.65-percona-highperf-b10-log to 5.0.75-percona-highperf-b11-log and notice this.
