…people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are …to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the …table with a statement like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
…the full copy of data. That defines XtraDB Cluster behavior in many ways. And obviously there are …from one node to another (SST applies FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does …down. This is done using caching mechanism on nodes. Each node contains a cache, ring-buffer, (the …
Post: How much memory Innodb Dictionary can take ?
May 6, 2010 By 3 Comments
…. Innodb allocates this memory once table is accessed and keeps until server is shut down. In XtraDB we have an option to… per Table or 1.5KB per Index. These numbers will change a lot depending on your table structure – This given schema had many tables with 50+ columns but I believe it can be helpful as ballpark figure. Also note Dictionary Cache is not…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… going to have releases of Percona Server/XtraDB based on the MySQL 5.5 code line… etc. And again, that makes a prediction of how many I/O operations there are impossible. Furthermore, …capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…table – If ON, the table‘s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE…XtraDB shuts down in “crash resistent modeâ€. Bug #589484 – Adds reporting of the query cache…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…should look for? A: Percona XtraDB Cluster is a synchronous replication…or failover capability. For example tables used for logging less critical information…query-level. As you mentioned, many applications require different tolerance levels per… with using a write-through cache? A: The InnoDB buffer …
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
…some cases it makes sense, but in many we’ve seen that it causes … 10 controller w/battery backed write cache, the slave delay problem is actually …most cases unless you have a single table which by itself can’t fit …to be in the course – “XtraDB: The top 10 enhancements”, and in Part 3 “XtraDB: The …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…: Multiple bitmap file support for XtraDB changed page tracking has been … privileges to modify a table (any non-temporary table) can inject arbitrary… innodb_fake_changes would allocate too many extents on UPDATE. In some… Temporary files created by binary log cache were not purged after transaction …
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… Technologies have been showcasing their table grouping technology allowing to …solutions including our own Percona XtraDB Cluster. This synchronous replication … MySQL with automatic sharding, caching as well as get …appliance with great many enterprise features. ParElastic makes many MySQL Servers …
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace … its performance implications here. How many big writes does InnoDB do, and how many small writes? First, I… log files need to be in the OS cache for best performance (sorry, can’t find the…
