… of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since… restarted (and there are others when it comes up) it joins the cluster seamlessly. I would like to note here that…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… answers: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s hard… like SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be… why it helped? When I did not use the STRAIGHT_JOIN, the query optimizer reordered the tables. It seemed to prefer an…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time… in the largest table. You can find the individual SSB query definitions in my previous blog post. Test environment These tests…=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… with a talk titled, “Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit development team, will… can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table…(1) as installed_count from client_app_inventory cai inner join device d on (cai.client_id = d.client_id) inner….label_id, cai.inventory_id All 4 tables in the query are locked!
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
Slow Query should be run on as-needed basis, and re-actively …-actively. I’ve actually see worse performance caused by slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool but it should only be …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty LSN range and thus… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug… fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304…
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.
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is… table on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table…_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… seeing. But, if you can connect and run a simple query and receive a response back in a reasonable (what is… example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
