…a single port. [Don’t try more than 2; the additional work that the kernel has… it looks like you’ll need to wait for the next release of MHA. Q:…of a clustered filesystem with an external lock manager. You might say that MySQL/NDB… and insert a few rows into an InnoDB table, but trying to run a simple…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… the node doesn‘t join the cluster…TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman [root@percona2 ~]# sed -i.sed “s/.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT…Mounting configfs… [ OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… … and everything works again as…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… slow gzip-1 mode works well. The tpcc database, which contains a lot of random data that doesn‘t compress well showed a… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…InnoDB, but usually only when the buffer pool is cold. Please don’t… Regardless, when the working set fits in memory, InnoDB almost always performs …innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id… Implied relationships box, but this generally only works if you have used the exact same name…– this might make sense to Developers but it doesn‘t help SchemaSpy at all. This is where …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… on 1 Gbps networks. 1 Gbps seems like a lot, doesn‘t it? Actually, maybe not as much as you think. While…, we can see our outbound bandwidth on our master node doesn‘t change as we add more nodes when we are using… wsrep_cluster_address = gcomm://239.192.0.11 And this works fine. Pretty slick! Note that IST and SST will still…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… then subsequent queries against the temp table fail. Q: Why doesn‘t the query optimizer take care the execution decisions? Since they… to the same execution plan. (I know it doesn‘t though.) Why don’t you try writing a SQL query optimizer and see… query in a suboptimal form. Q: Doesn‘t the primary key solution for random selection only work when the IDs for movies are…
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 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… Matt Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will…’re in the Portland area and work with MySQL, then this is an event you can’t afford to miss… 
So register…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn‘t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
