… warm, this also does not take into account… and then the lookup will be performed. So key-…like to see the affect of BKA on the…pool_reads and Innodb_data_read. We can …performance gain. This is not entirely visible in the manual either for MariaDB or MySQL… to see what specific types of queries would …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…x This query will roughly be evaluated in… see the individual affect of an optimization (…1.53G Innodb_data_reads 120552 123872…does not actually mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL…Plan id select_type table type possible_keys key…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data…affected (0.00 sec) mysql> insert into test.demo values (1,1); Query OK, 1 row affected…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… ran which does a … master will create enough…performance dramatically and even if nothing has changed to the replication traffic, changes to concurrent traffic on the slave can affect…check the types and…data size can be the difference between slave never lags and slave never is able to catch up. MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41 min 52.04 sec) Data… the refresh performance and query results. The view type does not usually* affect the time …based on the complete refresh method will always take NULL for this …
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
…the index will be used which can be seriously affect performance. Of…performance by joining data to yet another table though why it does not work for multiple group remains question to check with MySQL…row *************************** id: 1 select_type: SIMPLE table: g type: index possible_keys: …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…MySQL. If you design your data wisely considering what MySQL can do and what it can’t you will…MySQL and other way around. Even storage engines have very important differences which can affect performance…data sets full table scans are often faster than range scans and other types…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been using before does…affected or if you are you are capable of implementing fixes quickly, and what is most important your users will…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…will often be close to seeing performance 32GB server would have. You however have to be careful and understand how data…performance. By far the best method is trying, if you can afford it – just get memory upgrade and see how it affects performance…
Post: Predicting how long data load would take
May 24, 2007 By 12 Comments
…will normally be, if you measure rows, but if you measure in amount of loaded data…affect performance…data in MySQL you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA…
