Magento Performance: Know your database

Comments

Comments are closed.

Interesting ideas, I need to test them. Unfortunately I think there were too much numbers. And even some without context (if I understood correctly). If you don't have something to compare, numbers feel useless.

But nonetheless, I learned again a lot about MySQL

Rated 5

Anna Völkl at 11:56 on 7 Feb 2016

Cool tricks you shared, put that on my to-do list to check and optimize for some of our current shops.
You lost me on the numbers part of the last trick, but I will look that up in your cool slides again :)
I love (Magento) database talks in general, cannot get enough of it.

This talk made me remember a big lesson: how much sometimes You think You know and actually don't but most of all how important is to partecipate to this kind of talks/events. I'm quite sure I would have not found out all these things otherwise. It's one of the topics that I'm getting interested more and more lately and he definitively knows what he's talking about.

Rated 5

Sander Mangel at 18:08 on 8 Feb 2016

Great talk with some interesting findings. Nice to get my hands dirty on next time a shop is slow.
For me personally it could do with a little less numbers, maybe just a link to them but that was the only remark :)
Thanks for sharing the research!

Rated 4

Vinai Kopp at 12:54 on 11 Feb 2016

I enjoyed to hear the ideas and concepts Ivan applied. Some of them I wouldn't have thought of, especially splitting queries into simpler ones. Very interesting to see the resulting performance improvements quantified, too, even though all the stats where exhausting to follow after some time.

Rated 4

Nadia Sala at 16:16 on 11 Feb 2016

For me it's always interesting to discover new ways to solve performance problems related to access to data on the database. It was a very interesting talk and definitely prepared with patience and precision.