The Atlanta MySQL Meetup Group

MySQL Indexing: Best Practices

January 15 · 7:00 PM
Dell SecureWorks

Peter Zaitsev, the world's foremost expert in MySQL performance and scaling, of Percona will be showing us the best practices when it comes to Indexing. Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to discover indexes which are not needed.

Join or login to comment.

Rolf

http://www.percona.com/files/pr...

Slides from last nights presentation. Thanks to all for coming!

1 · January 16
Rolf

Another great talk from Peter!

1 · January 15
Aarsh

Thanks, @Tom Diederich for the opportunity to let us ask a question. I am trying to get started with entity framework using MySQL & C# .NET just like we do with MS SQL Server, and having some troubles. :-(

0 · January 8
- Tom Diederich
  
  Thanks for the question, Aarsh. I'll share this with Peter, and in the meantime, you can also search our forums -- and of course ask the question there, too at http://www.perconafor... I look to seeing you next week!
  
  1 · January 8
- Aarsh
  
  hi, I can not ask a question in "MySQL and Percona Server" somehow, I keep redirecting to my account's page :-(
  
  0 · January 15
Erik Webb

How to map different workloads to different sets of optimizations? For example, with a read-heavy, simple-query workload, X, Y, and Z parameters are most important.

0 · January 8
- Tom Diederich
  
  Hi Erik, I've shared this with Peter -- we see you next week!
  
  0 · January 8
Tom Diederich

Hi everyone, if you have a question for Peter in advance, please post it here. I'm Tom Diederich, Percona's community manager. I look forward to meeting you all next Monday!

0 · January 7
- Tom Diederich
  
  I'll also have a few t-shirts and copies of Peter's book, "High Performance MySQL" so get there early before they run out! :)
  
  0 · January 7