MySQL Performance Tuning: Part 1. Configuration (Covers MySQL 5.7)

I've prepared this mysql config file tuning tutorial for you - it has pretty much all you need to know about configuring MySQL for best performance.

On the agenda:

1. Essentials of MySQL Configuration
2. Differences between:
- MySQL versions (5.1, 5.5, 5.6, 5.7) and
- Distros (Community MySQL, Percona Server, MariaDB, WebScaleSQL)
3. 17 Key Settings for High Performance MySQL Server

And a bonus section: how to look at MySQL status variables.

Enjoy!

P.S. Some links from the video:

Article by Laurynas Biveinis about WebScaleSQL:

If I forgot to include some link, please be kind and report that in the comments so I update this.

[ernestoborges]

Gracias!!, Excelente Video, solo con la primer variable, la respuesta del servidor cambió notablemente.

[edvinhe]

Could've probably been the best MySQL tuning video here.

[jeffherdzina]

That was a great tutorial ! Hopefully, that part 2 will be out soon.

[mrkamranumer]

Very helpful and informative. Excellent video tutorial for MySQL DBAs

[devdeckardCain]

This video was actually INCREDIBLY helpful! I couldn't thank you enough for sharing your knowledge!

[ThunderPantaloons]

I've been looking for this for a long time. Answered my biggest questions that I've had for years.

[seonwookim]

one of the greatest videos I've ever seen !!!

[MrGramita]

definitely one of the most complete MySQL videos out there. Thank you Sir, really appreciated

[lky-tech]

I am looking this video since long time

[jonneyjunmu]

helpful and can get many handy things which is not included in the official ref .

[salehhoushangi]

excellent video and all of things you need to optimize mysql database mentioned. thank you so much man.

[dubereal]

This is simply awesome. Please keep up the great work

[prozacsf]

thank you friend. better than most of the resources - more clear, informative, true.

[lky-tech]

seems the author of this video is very busy or changed the line.
Thank you so much for this highly knowledgeable video ever on MySQL

[katineko]

This was amazing!!! Thank you for your hard work and deep understanding!

[Icedgarr]

Thank you for your resources, they are great and you are a very good tutor!

[bhaskarjadapalli]

really awesome...great explanation and very useful, thanks for uploading

[frankhk]

Luckily found this video. It helps me a lot.

[piyushjoshi]

superb, nailed it!!
hope I'll find more videos from speedemy

[dawidpopiela]

Great explained and great speaker! Kudos!