… filtering MyISAM tables though if you can leave them behind. Lastly, once that bug above is fixed, and you still have MyISAM tables you wish to keep running under PXC, wsrep_replicate_myisam allows you to… would be good if your async master can use ROW based binlog format as well to achieve better consistency, if you have…
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
… 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. … (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size …buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… of 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… this release however: MyISAM tables are still used for temporary tables where the MEMORY tables with dynamic row format could be used instead…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… NULL ) ENGINE=MyISAM mysql> show table status like ‘bbool’ \G *************************** 1. row *************************** Name: bbool Engine: MyISAM Version: 10 Row_format: Fixed Rows: 10 Avg_row_length: 7 Data… for MyISAM for same tables: mysql> show table status like “%bool%” \G *************************** 1. row *************************** Name: bbool Engine: MyISAM Version: 10 Row_format: Fixed Rows: 2097152 Avg_row_length…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
… is fixed length when it is being processed). This conversion process depends on number of columns while for fixed rows the MyISAM storage format matches…. Summary: Beware of dynamic row format tables with many columns they might bite you with surprise slowdown. MyISAM is much faster than Innodb…
Comment: Why MySQL could be slow with large tables ?
May 27, 2009 By 141 Comments
…` (`dateline`), KEY `ip_interval` (`ip_interval`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ROW_FORMAT=FIXED AUTO_INCREMENT=10100001 ; The country codes stored…) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `code` (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=91748 ; So the query to…
Comment: Why MySQL could be slow with large tables ?
April 6, 2007 By 141 Comments
… which will need some tables with about 200-300 million rows. Each row consists of 2x 64 bit integers. The table structure…=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; My problem is, as more rows are inserted, the longer time it takes to insert more rows. I insert rows in batches of 1.000.000 rows. First insertion takes 10 seconds, next…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE… – does it uses dynamic or static record format ? (static record format for sort used by MyISAM may cause sort files to be much….1+ it is also possible to fix this problem for cases when number of rows in auto-increment batch insert is not…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT…row-level lock for each row returned by the SELECT. These locks are all stored in RAM. The format… causes instabilities that then have to be fixed. How to optimize the program without …
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
… compared to MyISAM – it has page cache for rows (meaning no OS calls will be required to fetch/modify row data)…you should not be moving them around in binary format but it is often so convenient in practice. I… of these will be quite soon others will be fixed in one of the next Maria versions. We’ve…
