Oracle recently announcent MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA… we should expect from new release. I made sysbench oltp benchmarks on 10 mln rows (worth 2.5GB of data), on… is issue in scaling over 16 threads, that in current benchmarks – this is concurrency on rollback segment (which is global shared…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
…on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona ….gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages…. 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
…. If you spent last 10 years writing Stored Procedures for Oracle or DB2 it may be cool and convenient for you… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error… Procedures Indeed can help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL 5.0 was about 10…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
…Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is ….gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages…Bug reports Previous posts on this topic: Benchmarking Galera replication overhead Percona Server 5.5….
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 24 Comments
Vadim’s benchmarks for High Performance MySQL 3rd Edition in a simple readonly workload showed that MySQL 5.1 is actually a hair… MariaDB versus MySQL, but this blog post is one of the few credible benchmarks. I think the lack of published benchmarks from the… all worlds. I speculate that when MySQL 5.6 is GA, the official MySQL from Oracle will have a clear advantage over GA…
Page: Presentations
May 3, 2006 By
… about benchmarking issues and MySQL performance issues and settings. This presentation was written for Oracle audience so it is kind of special. Download MySQL Benchmark and Testing Project MySQL Users Conference 2003, San Jose, CA Presentation about projects MySQL Benchmark…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… look at https://blogs.oracle.com/supportingmysql/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman… high query rates is likely to be optimal until full benchmarking to determine perfect size can be done. It’s vital… configuration overall. Views are my own. For an official Oracle view, consult a PR person. James Day, MySQL Senior Principal Support Engineer, Oracle
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… expensive in the MySQL world, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL has done…, writing and emphasising benchmarks that benchmark performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes in later… using MySQL because it seems to offer the neccessary performance. Are we just kidding ourselves, and should we switch to Oracle? HT… recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle‘s main database, I believe…
Comment: Adaptive flushing in MySQL 5.6 - cont
September 11, 2012 By 13 Comments
… to be viable, though. And doesn’t make for easy benchmarking the way that’s usually done with the send as… see much benchmarking interest today. You might find the discussion at http://blog.wl0.org/2012/04/initial-reactions-to-mysql-5… time. Views are my own. For an official Oracle opinion seek out a PR person. James Day, MySQL Senior Principal Support Engineer, Oracle.
