… may become mandatory with the next release). CMAN v3 is a Corosync plugin that monitors the names and number of active…_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman And create the cluster, perform the following command on one server only…. we need then to delegate the fencing to pacemaker (adding a fence device, fence methods to specific node and the instances…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… upgrade. You usually upgrade only a few machines to see how it goes before deploying the new version on every server. Having such an incompatibilty could unfortunately become a major hurdle in the…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… in the 5.5.31-30.3 milestone at Launchpad. New Features: Percona Server has ported the Atomic write support for… diagnostics. Bugs Fixed: Fix for bug #1131187 introduced a regression that could cause a memory leak if query cache was used together… squeeze due to older OpenSSL version. Bug fixed #1183610. If a slave was running with its binary log enabled and then…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked… lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… These tests were done on a relatively fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4… concurrency, which this benchmark does not cover. I will make a follow-up post about concurrency in another blog post in…, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…/2013/05/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql CREATE TABLE `menu` ( `id` int(11) NOT NULL auto_increment, `label…($parent, $level) { $result = mysql_query(“SELECT a.id, a.label, a.link, Deriv1.Count FROM `menu` a LEFT OUTER JOIN (SELECT parent, COUNT(*) AS…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 20, 2013 By 10 Comments
@Jervin can you take a look at that thread – any idea of what’s going on? is there any more debug i can do? thanks
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
… for very large (but not necessarily slow) queries. It’s a good tool but it should only be used when needed…
Comment: Migrating between MySQL schemas with Percona Xtrabackup
June 11, 2013 By 2 Comments
Is there a way to modify the discard script so that it deals with foreign key constraints?
Comment: Recovering Innodb table Corruption
June 10, 2013 By 22 Comments
Thanks a lot. It resolves a serious problem i was getting in my server. Only here I found the solution. Hugs
