This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In … be joined together (Q4.1, Q4.2) but worse when small amounts of data are examined. Conclusion In some cases MyISAM is…=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… specify. It doesn’t matter what order you specify the keywords in this tuple, it is equivalent to this expression: WHERE k1…_name) = (‘Karwin’, ‘Bill’); Q: On the Dynamic Pivot, the straight join, can you explain more about why you thought about doing…_id) as an option there? Yes, I think what you’re referring to is what I covered as the Derived-Table Solution on…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… CMAN. Let’s have look at what happens if we have a cluster … to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 ...OK ] Starting gfs_controld… [ OK ] Unfencing self… [ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager: [ OK…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for their… on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much…_groups table to define the relationship between them. When someone joins a group, you run a transaction that adds the relationship…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… features the Birds of a Feather sessions where you can join attendees with similar interests to discuss common topics of interest… details on the dinner and other Tuesday night activities. Wednesday is the Community Networking Reception in the exhibit hall. Mingle with… sure to stop by during the conference and see what’s available. Join us in Santa Clara from April 22nd through the…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… of intersection, let’s review different workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid…(k)+k; COMMIT; That is, our PRIMARY KEY is not sequential anymore, which is bad for InnoDB, but this is what I need for my… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… State of the MySQL Ecosystem”, summarizes what we’re all coming to understand: “It is now over three years since Oracle acquired… Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What‘s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle… if it is to remain competitive in the new world order of the cloud and big data. If you can join us…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… can take a look at some vmstat data to see what‘s actually happening on the system during all these various… entirely sure why that’s the case or at what point the performance is going to level off since these tests were… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… and benefits of this major release. The conference is April 22-25, 2013 at the Santa Clara …” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior …the liveliest, most engaging Percona Live event yet. Please join us in Santa Clara, April 22-25 for …
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the other day… is allocated per-join-per-thread, in special cases. A join buffer is allocated to cache rows from each table in a join when the join…, back to the question about how the buffer is allocated. Its meaning is actually “minimum join buffer size.” Here’s the code, in…
