…’s measurements (http://www.tokutek.com/2012/01/1-billion-insertions-%E2%80%93-the-wait-is…are perhaps 10 times bigger than they were 4 years ago when the iiBench project started, …net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too,…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but…MySQL 4.1 but you still could not run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL…can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…1 supports multiple purge threads too, although using more than one is considered experimental at the moment. Unfortunately this patch…MySQL 5.6 versions will contain a fixed and much better performing…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… database and application performance. Over time msl patch grew with …-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=gcc’ … only those from every (1/log_slow_rate_limit) …patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
….4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and IO patches… a lot of customers not quite ready to update to MySQL 5.1 in particular as there is little in this version… get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4 with relevant performance changes…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…patches. Second is “-percona-highperf” release, which contains experimental patches that can improve performance significantly. On this stage “percona-highperf” contains patches…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… offering more performance benefits in MySQL 5.1 It …patches Mark Callaghan from Google released so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches…1-2 SATA drives so they are far from optimal for server grade IO subsystems. These are for MySQL 4…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… you can see there is some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is… isolate effect of this patch we only use this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with… about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while decreased CPU usage. Note when…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF …performance penalties of using of patches. Also we fixed potential memory leaks in microslow and userstats patches… / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5.1…read of size 8 at 0xff27758 by thread #4 ==9090== at 0x6B67C51: log_io_complete (sync0sync.ic:…memory after the reset. A speculative processor might perform the read first, which could leave a …
