June 19, 2013

Comment: How to calculate a good InnoDB log file size

June 14, 2013 By 38 Comments

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.

Filed Under: Insight for DBAs Tagged With: ,

Comment: Performance Schema overhead

June 12, 2013 By 22 Comments

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.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: Data mart or data warehouse?

June 17, 2013 By 14 Comments

Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.

Filed Under: Insight for Developers, MySQL

Comment: How to change innodb_log_file_size safely

June 13, 2013 By 17 Comments

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

Filed Under: MySQL

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

we use sphinx to our website where we have about 1200 tables each with … described here, but the search results have gone from milliseconds to more than 43 seconds

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Comment: Minimizing Downtime from Lengthy AWS Outages

June 12, 2013 By 7 Comments

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

Filed Under: Cloud and NoSQL, MySQL

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

May 30, 2013 By 6 Comments

…to have much easier failover than with file-based replication. We will see how to…to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count…? A ‘Last_Executed_GTID’ column would have been useful. In our case we …

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

May 29, 2013 By 2 Comments

…to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in…

Filed Under: MySQL, Percona Software Tagged With: ,

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

May 21, 2013 By 8 Comments

…in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to…. The manual describes very nicely how to switch to GTID-based replication, I …code: 1593 These simple tests answer the first two questions: replication works only if all servers have the same value…

Filed Under: MySQL Tagged With: , ,

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

…to analyze it in-depth.  If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql…columns (in the same order) and the server will not complain. If we execute the same sentences in MySQL…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,
« Older Posts
Newer Posts »