… and Performance and Improvements and new Features in MySQL 5….MySQL Instructor, will continue the topic of BigData with a talk titled, “Conquering BigData with MySQL and Shard Query…join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s hard to make a… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight …performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance…_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
…use MySQL 5.6 built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to measure performance. The query patterns will include: Exclusion Join…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so…_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type =…_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… grouping technology allowing to dramatically increase performance of complicated join queries. MySQL users are always hungry for better performance as you might guess. Tokutek have… for MySQL Developers and DBAs especially helpful in offering the “proof” of Performance situation being related or unrelated to the database performance which…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK…_table_alias: o mview_join_condition: NULL mview_join_order: 999 *************************** 2. row …Refreshed both views. Compared the refresh performance and query results. The view type …
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… us now replace the range with IN list in this query: mysql> explain select sum(events) from info where d IN(’2007… you get say thousands of groups at the same time ? Performing such query MySQL has to build (and do lookups) for all combinations… sec same as the query using join with day list table. So we finally managed to get better performance by joining data to yet…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql…mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE…
