… and combine that …MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables…table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… time ? Performing such query MySQL has to build (and do lookups) for all combinations which is 31*10=310…table and use the join to retrieve the rows from original table: mysql> show create table dl \G *************************** 1. row *************************** Table: dl Create Table: CREATE TABLE…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…statements which all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans, disk temp tables, etc…support to allow SELECT query transformations, joins and better filtering for the statistics Also combining these new commands with our msl …
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
…combined…table of numbers, and I want to sum them all up: mysql> show create table ex1; +——-+—————————————————————————————————–+ | Table | Create Table…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…join 2 tables but because the access type to the tables is “const” MySQL does not count it as access to two tables… this query in a simple way because scanning all that rows are actually needed to produce group …of rows it scans 100x, for example by adding combined index. So what is the easy way to …
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… run on MySQL. Dani is always pleasant to chat to and all conference … great combination indeed. SkySQL presented SkySQL Cloud Suite solution for deploying and managing MySQL …their table grouping technology allowing to dramatically increase performance of complicated join queries. MySQL users…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with … fashion, a final table `ontime_fact` is created by joining the newly constructed dimension table tables to the staging tables, omitting the dimension …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…table_name: orders mview_table_schema: demo mview_table_alias: o mview_join_condition: NULL mview_join_order: 999 *************************** 2. row *************************** mview_table…all customers. It computes this from the dashboard_top_customers MV, ordering them in descending order: mysql…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…different servers), multi-server partitioning to use combined memory and a lot of other … random accesses. This problem exists for all kinds of applications, however for OLTP …join of few large tables, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… a “flow”. An example ETL flow might combine data from item and category information into …large number of joins when many dimensions are involved. A data mart would collapse all of this …tables and materialized views. These features make working with a star schema much easier than it may be on MySQL…
