June 18, 2013

Post: Upcoming Webinar - "Deploy MySQL Like a devops SysAdmin"

October 25, 2012 By Leave a Comment

… of the movement. Then I will explain the best practices on how to deploy MySQL in a large scale environment using tools coming…

Filed Under: Events and Announcements, MySQL

Post: Tools and Techniques for Index Design Webinar Questions Followup

October 4, 2012 By 5 Comments

… MySQL. Q: How do the upcoming changes in MySQL 5.6 change the best practices for index design? Fundamentally, index design best practices will not change.  MySQL… likely to improve the query. Q: Could you provide some best practices for partitioning and its effect on index design? The most…

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

Post: Analyzing Slow Query Table in MySQL 5.6

February 18, 2013 By 1 Comment

… Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time…(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in… Public License v3. Do you want to learn more about best practices for manipulating query logs and running reports on them?  Register…

Filed Under: Events and Announcements, Insight for DBAs, Live Virtual Training, MySQL, Percona Toolkit, Training Tagged With: , , , , , , ,

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

…, Marten, Lars, Russell and ex MySQL guys such as Zak. We had good chat. There was MySQL Best Practices BOF on the conference which surprisingly attracted very few people – there were more MySQL current and ex employees… AJAX and Web 2.0 including presentation from Zimbra on best practices and from Yahoo team on their UI library (looks pretty…

Filed Under: Events and Announcements Tagged With: ,

Post: Speaking at MySQL Meetups in Atlanta,GA and Charlotte,NC

January 2, 2013 By Leave a Comment

… first speaking tour. This time I will take my MySQL Indexing Best Practices presentation to Charlotte on January 14 and Atlanta on January… practical advice on picking MySQL indexes to people only starting to use MySQL, as well as going into the more advanced topics of MySQL… us more time to go into more details and more practical questions when useful. Bring your own indexing war stories if…

Filed Under: Events and Announcements, MySQL Tagged With: , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other… running ALTER TABLE foo ENGINE=InnoDB. In theory, yes. In practice, not even close. I tried one more Boolean search, this… important best practice even if FTS isn’t involved. Always test how your application behaves as a result of a major MySQL version…

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

Post: The Math of Automated Failover

September 18, 2012 By 9 Comments

… small case, have little discipline and, implement solution not following best practices and do not test in properly. Lots of unfortunate downtime… the art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as…

Filed Under: Insight for DBAs, MySQL

Post: Why don't our new Nagios plugins use caching?

February 19, 2012 By 1 Comment

… you are monitoring a system for failures” became a tacit best practice. I don’t know why, but I can speculate that… a misunderstanding — perhaps caching was understood to reduce load on MySQL, rather than reducing load on the Cacti server and speeding… useful, you should not monitor too many things inside of MySQL. If you take the typical mass-market monitoring program’s…

Filed Under: Insight for DBAs, MySQL

Post: Using Percona Server in Production at Percona Live London

November 20, 2012 By 1 Comment

… MySQL environment. I start this talk with many general features which MySQL and Percona Server share giving advice on best production configuration and best practices…

Filed Under: Events and Announcements, MySQL

Post: Oracle Technical Experts at the Percona Live MySQL Conference and Expo

March 12, 2013 By Leave a Comment

…, Oracle MySQL technologists will also lead three breakout sessions at the Percona Live MySQL Conference: • “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best‘ Practices” by Dmitri Kravtchuk, MySQL Performance Architect • “MySQL 5.6: What’s…

Filed Under: Benchmarks, Cloud and NoSQL, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona Software, Percona Toolkit, Training, XtraDB Cluster
« Older Posts
Newer Posts »