… creating and loading an indexed table by creating the table with only the clustered index, and adding the secondary indexes after the data is… InnoDB picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation… the record update, the index tree would be corrupted. The correct solution is to make the freed clustered index pages unavailable to the… Bug#12612184 fix. btr_mark_freed_leaves(): Mark all freed clustered index leaf pages of a mini-transaction allocated (nonfree=TRUE) before…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… optimizations in works which would improve performance of index accesses/index scans. For example retrieving index values first and then accessing rows in… with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…
Post: Announcing Percona XtraDB Cluster 5.5.27-23.6
September 7, 2012 By Leave a Comment
… from our software repositories. Features: Percona XtraDB Cluster supports tunable buffer size for fast index creation in InnoDB. This value was calculated… be adjusted for better performance. Percona XtraDB Cluster has implemented ability to have a MySQL Utility user who has system access to…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…cluster view: global state: 77c9da88-b965-11e1-0800-ea53b7b12451:97, view# 18: Primary, number of nodes: 3, my index…3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size | 3 | …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication. For those who don… a 3 node PXC cluster. Let’s create a table to test on and insert some data: node2 mysql> create table autoinc… LOCKS space id 0 page no 823 n bits 72 index `PRIMARY` of table `test`.`autoinc` trx id 83B lock_mode…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… the cluster. Q: Are adding/updating mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables… in cluster and won’t affect overall availability? As I said, some ALTER TABLE operations, such as adding and removing indexes, can…, exist any dedicated checks specifically for XtraDB Cluster nodes, or a check that will check cluster consistency across all nodes. Please let…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… end up in Galera Cluster Best Practices, though I’ve heard that talk from Seppo (Codership) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text indexing, I… kind of architecture. Case Study: Designing a synchronous multi-master cluster for elastic scale-out and scale-in in the cloud…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… shorter time. This is why we have to do careful indexing build summary/cache tables hunt queries which traverse a lot… far MySQL does not have anything which tackles this need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster in terms of Storage – only…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… picked as the clustered index by InnoDB in the absence of a PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query with compound indexes). #832528 (Alexey Kopytov). Added a…
