May 25, 2012

Comment: Benchmarking single-row insert performance on Amazon EC2

… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that…

Comment: ext4 vs xfs on SSD

sandeep, I am not aware about alternative in ext4. There is a patch for MySQL which can do somewhat similar on any filesystem (this comes with Percona XtraDB Cluster)

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application… on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera library, version 2.x, a generic…

Comment: ext4 vs xfs on SSD

…. For that matter look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list… agreements, customers can try to pressure companies to move one patch ahead of another. I’ve worked in that environment, and can tell you that I’ve almost never seen a patch moved up that way unless something is completely broken. There…

Comment: MariaDB 5.3 is released as GA!

… to back-port patches. As an alternative Ubuntu has decided to just keep rolling out the latest version of MySQL for the… latest version of MySQL is fine from a general perspective, but Oracle (and Sun before them) don’t just patch security exploits… why distributions like to pin release versions.) Given MariaDB is MySQL with patches, I’m not sure quite how much that gains…

Comment: MariaDB 5.3 is released as GA!

… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what…’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases have never included new features… is the case that distros would only want to patch security issues whereas MySQL also fixes non-security bugs like server crash…

Post: Percona welcomes Drizzle 7.1

… function HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was released…_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication via LDAP. This …

Comment: MariaDB 5.3 is released as GA!

… microsecond timestamp support in version 5.6, yes. MySQL is unlikely to be a usable solution for GIS anytime … misconceptions, such as “Percona Server is just a set of patches” or “MariaDB has everything Percona Server has and more.” Henrik…

Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

… this better for some use cases in MariaDB. The Facebook patch has an InnoDB-only solution that avoids blocking. I think… support MyISAM and I hope that the distributions (Percona, MariaDB, MySQL) also provide a solution. See “START TRANSACTION WITH CONSISTENT INNODB…

Post: The new cool MySQL patch has landed! Check your queries performance!

… STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you… query SELECT COUNT(1) FROM t2; Important note: Although the patch was tested and run successfully under stress with both synthetic… it in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not…