June 19, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… interval, as TokuDB does time-based checkpoints. …will interesting how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for …_type = 0 ft_min_word_len = 4 #default_table_type = …

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 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 …

Filed Under: Insight for DBAs, MySQL

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

…Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…blocks any type of …performed. Let’s see this scenario via a test case: session1 > start transaction; Query OK, 0 rows affected…performed and hence no wait. Does…will block. Why? Because MySQL …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , ,

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

…data that the write sets that needs to be applied are in the online node’s gcache, it will only perform…split. Q: How does latency and bandwidth affect performance? Is it practical …, galera and built-in mysql replication are independent from each … convert it to a cluster type, and add nodes to it)…

Filed Under: MySQL, XtraDB Cluster

Post: How to find MySQL queries worth optimizing ?

September 11, 2012 By 6 Comments

…: 10000000 Rows_affected: 0 Rows_read:…perform but as only actual rows which are found and returned up to the top level MySQL…MySQL does not count it as access to two tables. In case of “real” access to the data it will… | id | select_type | table | type | possible_keys | key…

Filed Under: Insight for DBAs, MySQL

Post: Upgrading MySQL

January 5, 2010 By 24 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…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…’t on performance just yet. Having loaded the data, the first…InnoDB when the table does not contain a suitable …affected (8.65 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table | Op | Msg_type | Msg…MyISAM and InnoDB I will get back the same …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

…Type ‘\c’ to clear the current input statement. percona1 mysql> use test ERROR 1047 (08S01): Unknown command If you try to insert data…XtraDB Cluster does …perform an insert, this first insert will take longer: percona1 mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected…

Filed Under: MySQL, XtraDB Cluster

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: …

Filed Under: Insight for Developers Tagged With: ,
« Older Posts