… already were done. This could be related to current market conditions or may be 1B price tag was at higher end…) or will we see more and more push to purchase MySQL if you really plan to heavily use it ? Now for Percona… Marten saying once on the company meeting few years ago “If MySQL will get market value as Google is now, every one…
Post: Join me for 'MySQL 5.6: Advantages in a Nutshell.' Webinar. March 6 at 10 a.m. PST
March 4, 2013 By Leave a Comment
… overview of the advantages MySQL 5.6 offers. My focus is a practical one – to identify the conditions in which one or… available. You may find yourself wondering what advantages MySQL 5.6 provides and if the benefits exceed the effort of upgrading. This…, replication, and transparency features. “MySQL 5.6: Advantages in a Nutshell” will be recorded for your convenience. If you missed it, or…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now… enhancement actually is, and what is it aimed at. Index Condition Pushdown Traditional B-Tree index lookups have some limitations in…_partkey`,`l_quantity`,`l_shipmode`,`l_shipinstruct`) and the WHERE condition defined as: l_partkey = x and l_quantity >= 1 and…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…table_schema: demo mview_table_alias: c mview_join_condition: USING (customer_id) mview_join_order: 999 *************************** 3. row …mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41 min 52.04 sec) *If…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… second table. This means many point queries, say for example if table1 yields 1000 rows then 1000 index lookups are performed… more index range lookups. This means MySQL can employ many other optimizations like for example if columns other then the secondary key… that the following changes were made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… Work This code doesn’t work because of a race condition. If the connection is alive when checked, there’s no guarantee… a call to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW… is to use the same code that fixes the race condition. Again, if the connection is down, you’ll find out when…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…_idx | li_shp_dt_idx | 3 | NULL | 8272067 | Using index condition; Using where; Using MRR | +—-+————-+———-+——-+—————+—————+———+——+———+———————————————–+ See there are new Extra notes… is ‘Using Index condition‘, what I was able to find is Baron’s bug with no mention in MySQL 6.0 manual… else worth to mention here is that MySQL is wrong choosing index scan here. If we try to execute query with IGNORE…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… it brings. Multi Range Read With traditional secondary index lookups, if the columns that are being fetched do not belong to… be depend on the number of rows that match the condition ‘key_column=x’. You can see that there are a… that the following changes were made in the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… regression from plugin increases with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb… older Innodb versions. Note: These are completely CPU bound test conditions, data fits to buffer pool furthermore data and logs are…. UPDATE: Some people are asked about CPU usage in this condition. Here is the graph: The CPU usage is normalized to…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also …this to 20.000 queries/sec from single thread if all data fits to bugger pool, scaling to …just was not really designed and tested in such condition – normal case is to allocate cache memory to …
