…_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct… is 181G. Now let’s come down to the interesting part. Results With the table purchases_noindex, that has no secondary…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0. We have worked hard since our last major release…, i.e. one couldn’t do streaming incremental backups. As part of the backup, the LRU dump is now included as… advanced users. The new features in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL Conference…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite…. However, it had many limitations and missing features. The new 2.1 version of the tool removes those limitations and makes… MySQL Conference and there will be many talks about various parts of the toolkit: A 3-hour tutorial about the toolkit…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… limitations in cases such as range scans, where index parts after the part on which range condition is applied cannot be used…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… then for each value of ‘pk_column’ which is a part of the secondary key tuple, a point primary key lookup… TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). I did not use Scale Factor… of improvement in the optimizer, as it is clearly a part of the optimizer’s job to select the best query…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 16 Comments
…-server-wsrep-5.5.20-23.4 with galera-23.2.0. When starting the second node and higher we get…:01 ubuntu-server-129 CRON[3512]: (root) CMD ( cd / && run-parts –report /etc/cron.hourly)
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…, or even the rare count. But for the most part they are designed to be simple. A classic example is… show you in part 2. Part 2 of this post will talk about performance in a 100% pure memcached environment. Part 3 will focus… username, or even the rare count. But for the most part they are designed to be simple. A classic example is…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…them. A third instance, the client, will be discussed in part 7. Since this will be a proof of concept, I…b0ee-a5ac07975ce4) – partition with quorum Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… is simple and requires only 3 basic operations per transaction 2 reads and 1 write. Using memcached combined with MySQL… accessing 100% of the data in memory in the DB ( part 1 benchmarked a 4GB bp as being able to handle… Cabinet.   So stop in next time for part 3 of this series where we will focus on running…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… is part 3 of our series. In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we talked about running 100% outside the data with memcached, and now in Part 3 we are going… ), mysql was 5.1 XtraDB. Each environment had 2 tables each with 2 million rows. The data was identical. memcached…
