June 19, 2013

Comment: Sample datasets for benchmarking and testing

the links here are useful and informative…

Comment: How to calculate a good InnoDB log file size

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

Comment: How to change innodb_log_file_size safely

@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.

Comment: Performance Schema overhead

Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering :) Thanks for sharing.

Comment: Sphinx search performance optimization: attribute-based filters

…, but memory consumption is exaggerated, so we applied the technique described here, but the search results have gone from milliseconds to more…

Comment: Minimizing Downtime from Lengthy AWS Outages

Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

the master has GTID_MODE ON and this server has GTID_MODE OFF, Error_code: 1593 These simple tests answer the first two questions: replication works only if all servers have the same value for gtid_mode, so you should restart them at the

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… asked the great questions.  I answered as many as we had time for  during the session, but here are all the questions with my complete answers: Q… range with equal frequency as any other range, then the movie immediately following the “gap” will be picked more frequently. Nearly every solution…

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

… an effect on performance of the benchmark.  There was some discussion in the comments and I promised to follow up with more SSB tests at a later date. I also promised more low concurrency SSB tests when Peter blogged about the… is faster than InnoDB, but usually only when the buffer pool is cold. Please don’t take away that you should be…

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

… this may fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size… not, decrease some variables in the equation. Thread pointer: 0x7f9234000990 Attempting backtrace. You can use the following information to find out where mysqld…