17.Sep.2011 at 13:27 by Dick Rensema (5 comments) via api
Great tips. I learned a lot!
15 Protips for MySQL users
Joshua Thijssen (17.Sep.2011 at 14:25)
Talk at PFCongres 2011 (English - US)
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.
Quicklink: https://joind.in/3662
Track(s): English Room
Slides: 15 Protips for MySQL users
Who are you?
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
17.Sep.2011 at 13: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.
17.Sep.2011 at 13:42 by Primeminister (1 comments)
Good talk. Bashing varchars and utf8 is always good
17.Sep.2011 at 13:45 by Gerben (38 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.
17.Sep.2011 at 13:48 by Jeroen van Dijk (43 comments) via api
hmmm joind.in doesn't have a delete comment feature yet....?!
17.Sep.2011 at 13:49 by Jeroen van Dijk (43 comments) via api
Second time I saw the talk... It was already good, but it became a lot better! Good work!
17.Sep.2011 at 13:55 by Tim de Pater (31 comments) via api
great talk with some good humor. I wonder who build that table with all the varchar 255 fields ;)
17.Sep.2011 at 16:39 by Anonymous
Very interesting talk, learned a lot. Thx
17.Sep.2011 at 18:19 by Michelle Sanver (94 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!
17.Sep.2011 at 20:36 by Anonymous
Thanks for this very great slide. Very good tips.
18.Sep.2011 at 12: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.
18.Sep.2011 at 19:59 by Taco Vader (16 comments)
Interesting talk, sadly could not read the slides in the back of the room.
19.Sep.2011 at 07:27 by Bart Stavenuiter (2 comments)
Good reminder of the most common mistakes made by developers.
Great presentation with lots of humor!
19.Sep.2011 at 08: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.
17.Sep.2011 at 13:24 by Michelangelo van Dam (192 comments) via api
Wow! Teacher like presentation, hitting hard with a cluebat. Thanks!