June 18, 2013

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona… Server 2) here is the list of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2…, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such…

Comment: Open Source, the MySQL market (and TokuDB in particular)

…’60s, IBM had 70% of the computer market; number 2 had no more than 4%. It was _very_ …a migration was virtually a rewrite. (Today moving from MySQL to/from Oracle/MSSql/etc is even more painful.)…there were only the “Big 4″; then the “Big 3“. Also, European manufacturers were fading away, and Asian …

Post: Understanding the maximum number of columns in a MySQL table

…_FIELDS – 3 = 1020, but we play safe here */ DBUG_RETURN(HA_ERR_TO_BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines #define DATA_N_SYS_COLS 3 /* data0type.h… (1024-1)-3*2=1017 which is exactly the same as what I can create. That’s right folks, in MySQL 5.6…

Post: Percona Server for MySQL 5.5.30-30.2 now available

…). Fixed yum dependencies that were causing conflicts in CentOS 6.3 during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The… #1070856 introduced a regression in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when… (Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation. Bugs can…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

…). Fixed yum dependencies that were causing conflicts in CentOS 6.3 during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The… #1070856 introduced a regression in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when… (Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation. Bugs can…

Post: Is your MySQL buffer pool warm? Make it sweat!

… of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you…. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and Expo next week in… graph shows chunk 4’s workload warmed up with chunk 3. The result is similar for every single graph, each chunk…

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

…dependencies that were causing conflicts in CentOS 6.3 during installation. Bug fixed #1031427 (Ignacio Nin). … hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery… Based on Percona Server 5.5.30-30.2 including all the bug fixes in it …

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

… dependencies that were causing conflicts in CentOS 6.3 during installation. Bugs fixed #1031427 and #1051874. When…regression in Percona Server 5.1.66-14.2 which could cause a server to hang when…. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug …

Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

… based on the MySQL version, but no xtrabackup_56 is included in the release? -bash-3.2$ tar -tvf percona-xtrabackup-2.0.6…-2.0.6/share/doc/percona-xtrabackup/ sub set_xtrabackup_version { # Based on MySQL version choose correct binary # MySQL 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup…