15 Protips for MySQL users

Joshua Thijssen (17.Sep.2011 at 14:25)
Talk at PFCongres 2011 (English - US)

Rating: 5 of 5

Using MySQL is an art. Most of the time, the bottleneck of a website or application are database performance issues. For instance, did you know about the penalties for UTF-8 fields? Or about what can make or break your query caching? And what's the deal with cardinality and selectivity and why is it important? During this talk, Joshua will show you 15 practical MySQL tips found in his daily work that can help you speed up your database and/or queries.

Who are you?

Claim talk

By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.

If the claim is approved you will be able to edit the information for this talk.

Are you sure?

 
Comments closed.

Comments

Rating: 5 of 5

17.Sep.2011 at 15:24 by Michelangelo van Dam (223 comments) via api

Wow! Teacher like presentation, hitting hard with a cluebat. Thanks!

Rating: 5 of 5

17.Sep.2011 at 15:27 by Dick Rensema (5 comments) via api

Great tips. I learned a lot!

Rating: 5 of 5

17.Sep.2011 at 15:34 by Tjebbe Westendorp (20 comments) via api

Great talk, though I knew most of them through the MySQL Dev and DBA exams, it was a good refresher! +1 for the humor during the talk.

Rating: 4 of 5

17.Sep.2011 at 15:42 by Primeminister (1 comments)

Good talk. Bashing varchars and utf8 is always good

Rating: 5 of 5

17.Sep.2011 at 15:45 by Gerben (47 comments)

Thanks for the talk, very interesting! I knew some things already but picked up a few new things I'll be passing on to others. The information-density was pretty high but not too bad. Didn't quite agree on some assumptions, like limiting your range of countries and preferring latin-1 in some cases. These limit your scalability imho. At any rate the talk gave me something to think about.

Rating: 4 of 5

17.Sep.2011 at 15:48 by Jeroen van Dijk (56 comments) via api

hmmm joind.in doesn't have a delete comment feature yet....?!

Rating: 5 of 5

17.Sep.2011 at 15:49 by Jeroen van Dijk (56 comments) via api

Second time I saw the talk... It was already good, but it became a lot better! Good work!

Rating: 5 of 5

17.Sep.2011 at 15:55 by Tim de Pater (44 comments) via api

great talk with some good humor. I wonder who build that table with all the varchar 255 fields ;)

Rating: 5 of 5

17.Sep.2011 at 16:36 by Ghica van Emde Boas (4 comments)

Great talk. Many points to think about.

Rating: 5 of 5

17.Sep.2011 at 18:39 by Anonymous

Very interesting talk, learned a lot. Thx

Rating: 4 of 5

17.Sep.2011 at 20:19 by Michelle Sanver (170 comments)

This is the talk that I learnt the most from during the day. It was incredibly interesting and had many points to think about. The speaker was clear and funny in a nice way! Learning and laughing, I wish school would have been this fun :D

The only problem I had was that the speaker didn't plan the time correctly and seemed stressed and had to rush trough some points. Next time it could be nice if he plans the time a bit better. Maybe skip a tip or two so that he has good time for all of them without constantly saying he needs to rush it now. :)

Otherwise... Amazing!

Rating: 5 of 5

17.Sep.2011 at 22:36 by Anonymous

Thanks for this very great slide. Very good tips.

Rating: 4 of 5

18.Sep.2011 at 14:09 by Anonymous

Next time skip the obvious tips like "RTFM". You'll have more time for the interesting ones.
However, a very good presentation with a good sense of humor.

Rating: 3 of 5

18.Sep.2011 at 21:59 by Taco Vader (16 comments)

Interesting talk, sadly could not read the slides in the back of the room.

Rating: 5 of 5

19.Sep.2011 at 09:27 by Bart Stavenuiter (2 comments)

Good reminder of the most common mistakes made by developers.
Great presentation with lots of humor!

Rating: 5 of 5

19.Sep.2011 at 10:53 by Chase Sillevis (9 comments)

This session teached me stuff I can put to practice RIGHT NOW. I will never ever just go for UTF-8 again without thinking. I will make sure my queries are cached from now on. I actually know what Sharding is now.

Thanks! Nice session in front of a full audience.

© Joind.in 2014