… series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL…may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with…buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… limited number of $5 Expo Only passes. Use discount code “KEY” when registering for the Percona Live MySQL Conference… of Percona. The discussion will focus on MySQL 5.6 and how MySQL must evolve if it is to… data. If you can join us in Santa Clara for the Percona Live MySQL Conference and Expo, use …
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
…limited and pre-registration is required). The MySQL 5.6 content continues Tuesday morning when Tomas Ulin, VP, MySQL…join us in Santa Clara, April 22-25 for the Percona Live MySQL…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL …define the relationship between them. When someone joins a group, you run a transaction … This means more waiting, and after the limit is exceeded you will still get the …
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles…, NotABug. I’m thinking of the lack of sort-merge joins or intra-query parallelism, for example. It would be lovely… them. That’s why I listed those as major limitations. And because MySQL is a multi-threaded database for Web usage that…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… on the field that is used to join the two tables? A: The question in this case is how MySQL will execute the join…: There is a hard limit on amount of indexes you can have, which is 64 per table in recent MySQL versions. However it is often too many. Instead of thinking about hard limit of indexes I prefer…
Post: MySQL Limitations Part 3: Subqueries
October 25, 2010 By 21 Comments
This is the third in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1, 2). This post is…-out as users expect. It’s easy to pick on subqueries in MySQL, so I’ll try to be gentle. The following… it. And many MySQL users have learned to simply write JOINs instead, so it isn’t that much of a limitation. But it…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… be exceptional for traditional MySQL as MySQL optimizer with its nested loops joins does not favor …is ability of MySQL to use powerful system (including powerful storage) – Is quite limited with single…get a lot better performance with multiple MySQL instances on powerful storage. When you move …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… (BNL) Join of MySQL 5.5.24, Batched Key Access (BKA) Join of MySQL 5.6.5 and Block Nested Loop Hash (BNLH) Join of…_switch=’join_cache_incremental=on‘ optimizer_switch=’join_cache_hashed=on‘ optimizer_switch=’join_cache_bka=on‘ join_cache_level=4 join_buffer_size=32M join_buffer_space_limit=32M…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… join in this case because there is really no join: mysql> EXPLAIN select SQL_NO_CACHE c.city from cities_join c JOIN states s ON…, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE c.city from cities_join c JOIN states s ON (s… c.city, s.name from cities_join c JOIN states s ON (s.id = c.state_id) limit 10000,5; Result time(mean): 0…
