…with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes…simply attempt to connect and run a simple query, but it’s always possible to build …external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…. As of MySQL 5.5, the query cache mutex isn’t hit at all if query_cache_type is zero. We made…’s status in SHOW PROCESSLIST to “Waiting on query cache mutex” when the query cache mutex is taken. This makes it really… miss your opportunity to learn subjects from NDB Cluster to InnoDB Architecture and Performance Optimization. These detailed presentations will give you the…
Comment: MySQL Partitioning - can save you or kill you
June 29, 2012 By 45 Comments
… where INDEX (a,b) is picked by the optimizer. Sometimes it will use only `a` from the … in the EXPLAIN. EXPLAIN _usually_ reflects the query plan for the query, but it _may_ not. > This base… not support partition pruning. Eh? Is that a NDB deficiency? Pruning “always” works with InnoDB or MyISAM. …
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
… 18.4 says –> This section discusses an optimization known as partition pruning, which was implemented … DBs, storing records @ 800 rps. deletion from NDB database has to happen very frequently. Deletion … load infile. Query result ( during inserts 100 rows per sec) : Query 3 in 30 sec. Queries 1, 2 …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… may have streaming data from memory when it fits there. Optimizer and Execution Storage engines are not created equal especially if… in Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB… as MySQL allows you using multiple storage engines in the query you need to test all kinds of combination such as…
Comment: The Doom of Multiple Storage Engines
May 11, 2010 By 22 Comments
…:Extending_CREATE_TABLE As part of Timour’s “Query Fragment Pushdown” work (this is a set of … obvious alternative would be a pluggable optimizer, but it seems preferable to have the optimizer constant, and let the … the .frm files. Especially for “remote” engines like NDB, syncing the .frm is a …
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… talk but doing it in simple efficient and innovative way. NDB cluster is yet another example I’d put in here… layer is much more complicated is constantly changed and different optimizations may change internal code paths dramatically. I know number of projects being interested in special techniques applying to optimizes certain types of queries with MySQL, it is not easy to do…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…load_master_table’, ’0′ ‘Com_lock_tables’, ’102′ ‘Com_optimize‘, ’0′ ‘Com_preload_keys’, ’0′ ‘Com_prepare_sql’, ‘… ’0′ ‘Com_show_master_status’, ’105′ ‘Com_show_ndb_status’, ’0′ ‘Com_show_new_master’, ’0′ ‘…var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_…
Post: Percona is hiring a consultant
December 16, 2009 By 7 Comments
… You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without interruption… Highly desirable skills include: Non-core MySQL technologies: XtraDB, Xtrabackup, NDB Cluster, third-party storage engines and appliances, etc. Technologies …
