… have been working for a customer benchmarking insert performance on Amazon EC2, and I have some… Configuration First of all let me describe the EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge …so that we can see the impact of growth in data-set on the insert rate. We can see that …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
….89G 1.53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_… execution plans. a. Bad Plan id select_type table type possible_keys key key_len ref rows filtered … Rowid-ordered scan; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY,i_c_nationkey PRIMARY 4 …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… – l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem FORCE INDEX (i_l_orderkey) …values for Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately … intend to run tests to see what specific types of queries would benefit from Hash Join …
Post: Data Recovery Toolkit for InnoDB Version 0.1 Released
November 26, 2007 By 6 Comments
… data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data… recover data even when processed InnoDB page has been reassigned to another table and/or was partially destroyed Supports all MySQL data types except BLOBs, SETs and BITs (will be implemented in next releases) Has really great set of data filters to define data…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… might have to do some awkward backpedaling with customers, who now expect realtime data. The database giveth, and the database taketh… want to build your aggregate tables to avoid joins. Watch Data Types Does your ad ID look like “8a4dabde-1c82-102c-ab13… big, every byte matters a lot. Use the smallest data types you can, the simplest character sets you can, and watch…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… is off the table. Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken… aspect of application performance. Customer interaction In all cases, the customer‘s guidance is our first rule. The customer determines the depth and… pay off, and mention those to the customer. Or we economize by giving the customer easy choices so they can decide which…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… can pre-compute joins and may aggregate and summarize data. Using the aggregated data can significantly improve query response times compared to… commercial databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor…://flexviews.googlecode.com/svn/trunk/ flexviews Next you have to customize the example ini file. FlexCDC is located in the flexviews…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…length: 8.7482 Std: NULL Optimal_fieldtype: ENUM(‘blog’,'contact’,’customer‘,’image’,'lab_project’,'news’,'page’,'percona_faq’,'presentation’,'press_release…information for type column is maximum length which is really helpful in more cases than ENUM data type – maximum length of data actually stored…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… item was in each category. These types of warehouses are almost always “insert only”. Data is very likely never updated or deleted… lists of customers or products. Because of the partially denormalized nature of a star schema, the dimension tables in a data mart… approach to data warehousing. There is also a cousin of the star schema in which the dimensions are normalized. This type of…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied…to apply application changes, the longer is the downtime. Our customer built his application so it automatically detects the new …
