PHP's biggest bottleneck - MySQL

Comments

Comments are closed.

Are there any overhead in logging slow queries? Woukd you consider using it in production servers?

Rated 5

Anonymous at 16:50 on 19 Feb 2015

This was great - practical advice for those of us who aren't "DB ninjas".

This talk was great, learnt a whole bunch of stuff within 5 minutes. I can't wait to benchmark all the things and watch the YouTube video for the bits I missed

You always hope for a silver bullet in one of these talks and obviously there never are any. Plenty to investigate.

I do need to benchmark more. Great advice.

Fun talk full of really useful tips. I would recommend a picture of the Twin Peaks log lady to illustrate the "slow log query".

An excellent talk, I liked the humour and the knowledge shared really useful practical examples. Lots of great tips and of course benchmark as much as possible!

Very good for beginners but only discussed handling tables with up to 50k records. In the age of 'big data', where we have to work with tables with well over 1m records, a lot of things he talked about don't stand true.

Overall enjoyed it

Objectively a good talk, but the description definitely needs tweaking! From the mention of how MySQL handles things "under the hood", I went into this thinking it would delve into the inner workings of the query optimiser. It was however, just basic tips on indexes etc... stuff that anyone who's worked on anything of any scale (hopefully) already knows!

A very good useful talk with some useful information. One tip Liam gave me will likely save the company I'm currently working for thousands of pounds, and their users many millions of valuable microseconds.

This talk should include a mention of 'for beginners' somewhere. Though an entertaining talk it was a basic one.

For beginners, it would be an invaluable talk! For an intermediate.... Nothing new.

Thanks to everyone who has provided feedback - really appreciate it, all valid comments, and I will take them into account when I am thinking about talks in the future! With this talk I was trying to make it useful and accessible for as many people as possible - certainly there is another level to look at here for more advanced optimisations / performance improvements, and hopefully that's another talk that I can submit for next year!

Lots of useful tips and insights on the best ways to approach optimising your databases.

Also showing the limits of things like indexing and when they cease to be as useful.

Thanks

Introduced some ideas to review even for experienced DBAs

Great set of advice, very well delivered. It didn't go into unnecessary detail, but did give tantalising hints at more complex stuff we should look into on our own, so I felt it was pitched at the right level. Very well delivered.

Rated 3

Anonymous at 16:05 on 23 Feb 2015

A bit too basic for me and I would hope that most developers already know about indexes and data types but none the less I enjoyed it.