… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users … be good if your async master can use ROW based binlog format as well to achieve better consistency, if you…fixed on latest release (5.5.30-23.7.4), table without PK imposes an additional overhead, and because cluster performance…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… engine (also known as HEAP) in MySQL has been one of the long-… that the performance and memory usage is about the same for both row formats. (Speaking very…rows inserted). In the second test we check if the dynamic row format delivers the memory savings for VARCHAR fields agains the fixed row format…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…MySQL DBA team where it belongs instead of by by Application Developers. Sometimes a good workaround is not even possible; dynamic row format…performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… math the row scan speed is significantly affected. I also decided to see how longer rows affect performance and…=latin1 mysql> show table status like “m4″ \G *************************** 1. row *************************** Name: m4 Engine: MEMORY Version: 10 Row_format: Fixed Rows: 5000000 Avg_row_…
Post: Percona Server 5.5.15-21.0
August 31, 2011 By 10 Comments
… Engine As of MySQL 5.5.15, a Fixed Row Format (FRF) is still being used in the MEMORY storage engine. The fixed row format imposes restrictions… and VARBINARY. For performance reasons, a mixed solution is implemented: the fixed format is used at the beginning of the row, while the dynamic…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
…rows/sec ; 653MB/sec) t99v1 – 12.36 sec (1M rows/sec ; 93MB/sec) This shows there is surely the problem with dynamic row format…mysql [localhost] {msandbox} (test) > select max(t1+0) from t99v1; +———–+ | max(t1+0) | +———–+ | 0 | +———–+ 1 row in set (3.26 sec) mysql…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… with logs. You can fix this by modifying shard…mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…column store performs about 8x-10x better than a row store …
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… to be fixed in some of next version but it is so as of MySQL 5….MySQL had to perform and so number of row combinations really examined. LIMIT is not taken into account while estimating number of rows… etc. Simple table like output format is good but with growing MySQL Server complexity it is getting …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… – does it uses dynamic or static record format ? (static record format for sort used by MyISAM may cause… In MySQL 5.1+ it is also possible to fix this problem for cases when number of rows in… offering more performance benefits in MySQL 5.1 It also should be possible to start unlocking rows if they…
