June 18, 2013

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

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

Post: Tools and Techniques for Index Design Webinar Questions Followup

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…

Post: Analyzing Slow Query Table in MySQL 5.6

… 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…

Post: EuroOSCON 2006 - High Performance FullText Search

…, 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…

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

… 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…

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

… 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…

Post: The Math of Automated Failover

… 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…

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

… 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…

Post: Using Percona Server in Production at Percona Live London

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

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

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