….6TB) and 128GB memory. For the hot test, the data fits in the buffer pool and has been loaded by the cold… in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to… table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…ve seen situations where even under just a moderate load on the host system, DRBD can end up …two of everything. Q: Is it possible to replicate only some tables from master to slave, and if so, how? A…watch your MySQL server’s memory usage and you see that it’s starting to swap, that might indicate …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…case DROP TABLE statement is used on a temporary table. Bug fixed #1084702…to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to… has been defined to throttle InnoDB access, and work load contained DDL …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
svar, I have done some tests with concurrent load but did not see performance drops. It is reasonable that … load will be a lot slower than 1 for some N. Eventually you change from having all index blocks for all tables in memory to not and then disk read stalls occur. Not sure…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… especially when the default glibc memory allocator is used. Bug fixed #1131187…Authentication Plugin couldn’t be loaded with Perl and Python …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… especially when the default glibc memory allocator is used. Bug fixed #1131187…Authentication Plugin couldn’t be loaded with Perl and Python …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
Thanks Vadim, I did the test on 5.6 and load data infile concurrently results for two threads is 20 times… could not be related to primary key worth distribution, memory or CPU as repeating the same test on uncompressed table scale as expected… more big data challenges where innoDB and TokuDB will have to be compare with LevelDB at some point
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… planned. Hardware Configuration If you need to load data quick do it on decent hardware. Especially memory size is important. If you need… had tables partitioned and so no table was more than 15GB in size (allowing to fit all BTREE indexes in memory) plus we loaded data in parallel and our rows were relatively long. In most cases I would expect load speed to be…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
…; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave… features to make it more convenient. It would be great to have MEMORY table option which would save table to on disk file on shutdown and load…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… disk MyISAM temporary table. What i decided to do is to see how much overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table… of time and when it has to perform them anyway which can cause IO bound load even with small data which can…
