…: Percona XtraDB Cluster has ported Twitter’s MySQL NUMA patch. This patch implements improved NUMA support as it prevents imbalanced memory allocation across… be no retry. This version of Percona XtraDB Cluster implements significant speedups and memory footprint reduction on ranged queries. Bugs fixed: Some…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory workload index accesses might be… with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by… to fit data set you’re working with in memory – Processing in memory is so much faster and you have whole bunch…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…disabled. 120619 13:21:17 InnoDB: The InnoDB memory heap is disabled 120619 13:21:17 … 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size | 3 | +——————–+——-+…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…re looking for a lot. This will cause data clustering done by these columns which can be helpful … fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal … of indexes. The indexes can’t fit in memory anymore. How does this affect performance? A: Typically …
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
…” width=”237″] Percona XtraDB Cluster[/caption] Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7… append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, InnoDB temporary tables….4 including all the bug fixes in it, Percona XtraDB Cluster 5.5.29-23.7.2 is now the current…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these… penalty DRBD introduce and do not use this option wast memory and CPU cycles on double caching. Even in this case… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… them to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master… ? From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy… Wave is appliances – you can see Violin Memory appliance which can be used with MySQL to get very fast IO and so…
Post: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
… MySQL is the MySQL server manipulating FRM files. The only MySQL storage engine I’m aware of having fully crash safe DDL is MySQL Cluster (NDB). Proving that MEMORY is/isn’t…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best…, so it’ll bring different parts of the table into memory. So that’s the first thing that’s happening. The… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on… 1 (assuming a 20 node cluster): cd shard-query ./start_workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is…-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20…
