hello, currently using 2.2.2 and mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1… `pt_heartbeat`.`heartbeat` uses the server_id column for –update or –check but the server’s master could not be automatically determined. Please read the DESCRIPTION section of the pt-heartbeat POD. any ideas why this could…
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
… bug https://bugs.launchpad.net/percona-xtrabackup/+bug/945161 while using percona-xtrabackup-2.0.6, so I update this software…_buffer_pool_filename’ option in group ‘mysqld’ in MySQL options” My server is MySQL 5.5, my command is “innobackupex –defaults-file…/backup/tst_ch118_3/201305″ innodb_buffer_pool_filename is not a global variable of MySQL 5.5, why this error? thanks!
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… I can say that I’ve seen only one specific use case useful with InnoDB compression: i.e. you have a separate… and do not have a big performance hit. That’s why Facebook has their own InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6…
Comment: Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
March 25, 2013 By 2 Comments
Peter, Can you have a look at this: http://stackoverflow.com/questions/15619755/why-would-adding-a-duplicate-index-make-mysql-use-the-correct-index-not-the-dup
Post: Using MySQL as a Queue, and Free Percona Live Tickets
September 15, 2011 By Leave a Comment
… Engine Yard blog: 5 subtle ways you’re using MySQL as a queue, and why it’ll bite you. Go there to read… job queue or batch processing system, and try not to create one inside MySQL. Although the job queue is a great design…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… table that has a DDL operation waiting, will block. Why? Because MySQL sees that the old entries in the Table Cache have… application was using MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL when… > CREATE TABLE t1(i int(11) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…not use any of these two. With the choice left between RedHat/CentOS and SuSE, I lean towards the former. Why…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… unless opening and closing files is expensive operation (such as using MySQL on NFS file system). innodb_data_file_path got a…. I wonder why was not it implemented as number of different variables which would make more sense in my opinion. MySQL 5.6… and make sense. In some cases I think MySQL 5.6 does not go far enough in those changes but I can…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…Why is that ? Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been using…use MySQL Replication for upgrade. Once you have setup slave with new version and made it to caught up you can use…it is not possible as MySQL only …
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… status variables for post-execution analysis. So why is the “SELECT note” actually slower? It …no workaround, using FORCE-like commands or optimizer_switch flags- we can disable ICP, but not “using index”. So… about the new features of MySQL query planner? Are you not yet familiar with terms like MRR…
