….10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer… in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs Fixed: Fix for bug #1131187 introduced a regression that could cause a memory…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the… is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… was placed on the storage engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential… scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins are available for MySQL. Facebook mentions they have over… Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences on Twitter – directing…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… regarding to memory allocation. So we did some memory allocation setting in my.cnf file. On first day after doing memory allocation setting….1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared… \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
… memcached engine as the backstore (cache-only), or both (caching). In the last case, if memcached cannot find a key in memory…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… much memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory‘; +——————————-+ | sum…_length+index_length) from information_schema.global_temporary_tables where engine=’memory‘; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one… in the documentation. What of course interests us is the MEMORY engine performance with this feature added. For that we run a…_INCREMENT, c VARCHAR(4096) NOT NULL DEFAULT ”, PRIMARY KEY (id)) ENGINE=MEMORY ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1; Also we modify the…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults…` tinyint(4) default NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=MEMORY and populated it with 1.000.000 rows ALL of… could delay writes and do all the changes directly in memory. MyISAM however had to perform number of random writes to…
