June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… optimizer take care the execution decisions? Since they are all logically the same, I believe it should…why it helped? When I did not use the STRAIGHT_JOIN, the query optimizer reordered the tables.  It …November 11-12, 2013. We also look forward to the Percona Live MySQL Conference and Expo in Santa…

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

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

May 31, 2013 By Leave a Comment

…potentially impact our performance, and should be avoided. By the way…when run on the same table, correctly identifying the redundancy: $ pt-duplicate-key-checker –tables …optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

….com. My apologies if we weren’t able to …optimal production deployment you want two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs should…specified set of databases and tables. With this method, every …: How do you monitor MySQL to determine when it’s not responsive?…

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

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

May 7, 2013 By Leave a Comment

…RC release, we will not…MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash when…Optimization has been implemented and XtraBackup now avoids loading non-relevant tablespaces when…version message which should include the revision …

Filed Under: MySQL, Percona Software Tagged With: , , ,

Post: Economics of Performance Optimization

March 13, 2008 By 9 Comments

… These questions are: Should we Optimize Application or get more Hardware ? Should we do things ourselves or…proper indexes or tuning couple of MySQL settings. When low hanging fruits are fixed you…application changes such as building summary tables, significant schema changes, use of replication, …

Filed Under: Insight for Developers Tagged With:

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

…MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL when…TABLE should fail in such a case when the table already exists and there is no other DDL like a DROP table…

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

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

…table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table-checksum plugin can alert when…or poorly optimized queries…any other, should only…when the problem has grown much more serious. You can use the pmp-check-mysql-status plugin to alert when… releases we …

Filed Under: Insight for DBAs, MySQL

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…: Should we change ROW replication to MIXED during Upgrade? I prefer simple solutions when possible…MySQL 5.5 do we really need all tables changed to Innodb and character set set to utf8? No. MySQL…by updating statistics (ANALYZE TABLE) or disabling some of the optimization/statistics related features…

Filed Under: Insight for DBAs, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…when I’m examining the status values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql…. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures, and the …changes that can or should be made at a much higher level. If we see that the …

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…when you don’t define a PRIMARY KEY, I assume) when I already have an INT UNSIGNED PK that should…optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts