PHP's biggest bottleneck - MySQL

Liam Wiltshire (19.Feb.2015 at 14:40, 1 hr )
Talk at PHP UK Conference 2015 (English - UK)

Rating: 4 of 5

PHP's biggest bottleneck - MySQL

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

 
Comments closed.

Comments

Rating: 5 of 5

19.Feb.2015 at 15:25 by Timur Olzhabayev (2 comments)

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

Rating: 5 of 5

19.Feb.2015 at 16:50 by garethellis (28 comments)

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

Rating: 5 of 5

20.Feb.2015 at 09:12 by Tom (10 comments)

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

Rating: 4 of 5

20.Feb.2015 at 12:58 by Jamie Lovelock (40 comments)

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.

Rating: 5 of 5

20.Feb.2015 at 22:14 by Matthew Marcus (39 comments)

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

Rating: 5 of 5

21.Feb.2015 at 11:01 by David Carr (40 comments)

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!

Rating: 3 of 5

21.Feb.2015 at 11:12 by Jack Segal (23 comments)

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

Rating: 3 of 5

21.Feb.2015 at 12:58 by Richard John (5 comments)

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!

Rating: 5 of 5

21.Feb.2015 at 13:54 by Jack Parnell (3 comments)

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.

Rating: 3 of 5

21.Feb.2015 at 15:19 by Gareth Parmar (10 comments)

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.

Speaker comment:

21.Feb.2015 at 19:13 by Liam Wiltshire (114 comments)

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!

Rating: 5 of 5

23.Feb.2015 at 10:26 by David McCurdy (9 comments)

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

Rating: 4 of 5

23.Feb.2015 at 11:23 by Chris Hunt (5 comments)

Introduced some ideas to review even for experienced DBAs

Rating: 5 of 5

23.Feb.2015 at 11:57 by Matt Dawkins (38 comments)

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.

Rating: 3 of 5

23.Feb.2015 at 16:05 by Anonymous

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.

© Joind.in 2019