Database Optimization for Web Developers

Steve Meyers (02.Mar.2013 at 10:30)
Talk at MidwestPHP Conference (English - US)

Rating: 5 of 5

Most developers are developers, not DBAs, yet many smaller companies have inadequate database experience in-house. This is largely because databases like MySQL and PostgreSQL don't necessarily require a full-time DBA to administer. It's become more important for developers at smaller companies to have some basic knowledge of how to keep their database happy.

Session notes: http://www.stevemeyers.net/2013/03/midwest-php-presentation-notes.html

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: 4 of 5

02.Mar.2013 at 13:14 by Joel Clermont (37 comments)

Note: I only attended part two.

Great information, speaker clearly knows his topic. Slides were a bit dense with text at times, but that was a relatively minor issue. I benefitted by attending.

Rating: 5 of 5

02.Mar.2013 at 13:29 by Jon Henderson (16 comments)

I attended both and while I think that session 1 was more pertinent to what I wanted to know, both were extremely informative. The speaker knew the topic very well and shared a great deal of very helpful information.

Sliders were hard to read but the projector wasn't very good so not sure it was his fault.

Speaker answered questions afterward and was knowledgable and helpful.

Very glad I attended.

Rating: 5 of 5

02.Mar.2013 at 13:34 by Jesse Donat (14 comments)

I learned a ton in the first 10 minutes, it got a little slow after the first bit but overall very interesting

Rating: 4 of 5

02.Mar.2013 at 15:40 by Max Schwanekamp (18 comments)

Learned a lot from this talk, but since the talk was pretty MySQL-specific anyway (also Maria/Percona) it would've been nice to get some more specific info about basic tuning my.cnf params for a web developer. As it stands, this talk could definitely fit into a single session.

Rating: 5 of 5

02.Mar.2013 at 19:05 by Nate Nolting (2 comments)

Learned a lot, sounds like I have some work to do now next week, thanks for that.

Rating: 4 of 5

03.Mar.2013 at 09:29 by Jeremy Ward (23 comments)

I attended the first session only, and Steve covered a lot of information in the time allotted. He clearly has a good awareness of the pitfalls to look out for when using MySQL, and I felt that I got a lot out of his talk. Hopefully the slides will find their way online!

Rating: 4 of 5

03.Mar.2013 at 09:50 by Mark Cyrulik (20 comments)

Very good talk. It was nice to hear about some of the tools methods that can be used to first FIND your problems.

Rating: 5 of 5

03.Mar.2013 at 10:00 by Jason Bird (8 comments)

Was a good talk. Wish I would have had it a few years ago before I had to learn many of the items the hard way. Was good to reinforce knowledge though.

Rating: 4 of 5

03.Mar.2013 at 11:15 by Kate Hanson (11 comments)

I only attended the first session. I picked up a couple of new things, but I was a little disappointed that the speaker didn't explain things in depth. The slides had too much text and were hard to read.

Speaker comment:

03.Mar.2013 at 13:40 by Steve Meyers (22 comments)

Kate - Thanks for the feedback. I apologize for the hard-to-read slides. I think the room did not contribute well to having easy-to-read text on the projector, which did not have great resolution (800x600). Please download the slides in order to see the detailed text.

Speaker comment:

03.Mar.2013 at 13:53 by Steve Meyers (22 comments)

Max - I've included a link to the Percona Configuration Generator in my session notes (linked above). I didn't include tuning of my.cnf in my talk for a few reasons:

(1) It is a very complex topic where the answer to most questions is "it depends"
(2) Just scratching the surface of it would take an extended amount of time (which I didn't have)
(3) The talk was geared to web developers, who are generally not responsible for this type of server tuning

I do appreciate your feedback, and I'll look into adding some basic my.cnf tuning into my talk in the future.

Rating: 5 of 5

03.Mar.2013 at 21:10 by Anonymous


Rating: 5 of 5

04.Mar.2013 at 08:44 by Brad Blix (5 comments)

One of the best sessions at Midwest PHP. Lots of good information and ideas on what to look for and do to make you database and queries more efficient.

Rating: 5 of 5

04.Mar.2013 at 10:21 by Chris Smith (10 comments)

Enjoyed the talk quite a bit! There is a lot of good information given in the talk and I can't wait to test out the pt-digest tools mentioned in the talk.

Thanks Steve!

© Joind.in 2014