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:

https://www.percona.com/blog/2014/05/22/comparing-webscalesql-percona-server/

My my.cnf template download: http://www.speedemy.com/17

On innodb_io_capacity: http://www.speedemy.com/17-key-mysql-config-file-settings-mysql-5-7-proof/#innodb_io_capacity

More on MySQL handler counters: http://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Handler_read_first

On using Threads_running: http://www.speedemy.com/mysql-troubleshooting-crash-course/

Cacti: http://www.cacti.net
Zabbix: http://www.zabbix.org

Percona Monitoring Plugins: https://www.percona.com/software/mysql-tools/percona-monitoring-plugins

Percona Toolkit: https://www.percona.com/software/mysql-tools/percona-toolkit

Innotop manual: http://innotop.googlecode.com/svn/html/manual.html
Innotop source: https://github.com/innotop/innotop

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

Видео MySQL Performance Tuning: Part 1. Configuration (Covers MySQL 5.7) канала Speedemy