June 19, 2013

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had…) be a good idea? A: Yes. This is a good practice. Normally I’d do something like CREATE TABLE LINK (id1… you usually would deal with it not overcome it. The best thing to start with is looking at the queries around…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Indexing: Best Practices Webinar

August 7, 2012 By 3 Comments

I’m hosting MySQL Indexes: Best Practices Webinar next week, Wednesday August 15. In which I will … they can be used, as well as go over the best practices in selecting correct indexes for your database workloads. Indexing looks…

Filed Under: Events and Announcements, MySQL

Post: Upgrading MySQL: Best Practices webinar, June 27th

June 18, 2012 By Leave a Comment

… carefully. On June 27, I’ll talk about some of best practices Percona had developed over years in relation to MySQL Upgrade…

Filed Under: Events and Announcements, MySQL

Post: Tools and Techniques for Index Design Webinar Questions Followup

October 4, 2012 By 5 Comments

… changes in MySQL 5.6 change the best practices for index design? Fundamentally, index design best practices will not change.  MySQL 5.6 is… 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… 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: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

… own all-day tutorial on Percona XtraDB Cluster / Galera in Practice, so naturally I think everyone should come see that one… going here, I’d probably end up in Galera Cluster Best Practices, though I’ve heard that talk from Seppo (Codership) before… you most like to attend at the conference and why?  Best answer in the comments below wins the pass.  Include a…

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

Post: Common MySQL traps webinar questions followup

January 17, 2013 By 1 Comment

… to time constraints. Q: Are there any technical considerations or best practice tips to have a replicated slave in the cloud, for… may be difficult if the table is big. So the best solution is sometimes to have an external tables to store… and wanted to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL 3rd…

Filed Under: MySQL

Comment: Why MySQL could be slow with large tables ?

May 1, 2008 By 141 Comments

Best Practice to deal with large DBs is to use a Partitioning … to my Large DB issues. As for Joins, its always best practice not to use joins over Large Tables. Instead use alternate…

Filed Under: Insight for DBAs Tagged With: ,

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

… such as Zak. We had good chat. There was MySQL Best Practices BOF on the conference which surprisingly attracted very few people… 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

… speaking tour. This time I will take my MySQL Indexing Best Practices presentation to Charlotte on January 14 and Atlanta on January… both providing a lot of very good ready to use practical advice on picking MySQL indexes to people only starting to… 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: , , , , , ,
« Older Posts
Newer Posts »