… a customer benchmarking insert performance on Amazon EC2, …query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL…see the impact of growth in data-set on the insert rate. …large, because it varies between ~6.5k to ~12.5k INSERTs per second, with…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…tuples. If the buffer size is large enough only a single range lookup…53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 …queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL…; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY,i_c_…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with…data is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
What does working with large data sets in mySQL teach you ? Of course you have to learn a lot about query optimization, art of building… learn when working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data sets – it… have some large data set experience but it is not the case for many people – I constantly run into the customers assuming it…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers … with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by one for query …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…Query Cache and Replication, which were clearly not enough to solve all performance problems (like scaling Writes with replication or dealing with large data…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
…customers or products. Because of the partially denormalized nature of a star schema, the dimension tables in a data…query execution, clustered tables and materialized views. These features make working with a star schema much easier than it may be on MySQL…
Page: Consulting for MySQL
July 31, 2006 By
… downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to optimize queries ? Customized training… work with you to recover as much data as possible. Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data…are several problems with the very large transaction caused …. Even simple SELECT queries might have to …mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… important is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or hash joins, you… has a custom table, which is really constructed behind the scenes from the name-value tables in a complex query with many joins. I have never seen this approach scale well. Use The Best Technologies You Can MySQL is not…
