Tuning MySQL

Panel

From Stony Brook –

By popular request, I've been asked to re-send information about the MySQLTuner tool. It helped give us feedback on several key mysql tuning parameters. And it gives suggestions on settings that may help your system run more efficiently, and thus your VIVO run a little bit faster.

The mysqltuner.pl script can be found at:

https://github.com/rackerhacker/MySQLTuner-perl

...

If performance is abysmal on a simple query, check for missing or corrupted MySQL indexes that may cause the query engine to do full table scans.

TCMalloc and MySQL

...

Interesting GitHub blog post (https://github.com/blog/1422-tcmalloc-and-mysql) describing debugging MySQL performance issues, and using tools like the open source Percona Toolkit and the Google-contributed TCMalloc from gperftools.

Page tree

Versions Compared

Old Version 13

New Version Current

Key

Table of Contents

Tuning MySQL

TCMalloc and MySQL

Interesting GitHub blog post (https://github.com/blog/1422-tcmalloc-and-mysql) describing debugging MySQL performance issues, and using tools like the open source Percona Toolkit and the Google-contributed TCMalloc from gperftools.

Page tree

Page History

Versions Compared

Old Version 13

New Version Current

Key

Table of Contents

Tuning MySQL

TCMalloc and MySQL

Interesting GitHub blog post (https://github.com/blog/1422-tcmalloc-and-mysql) describing debugging MySQL performance issues, and using tools like the open source Percona Toolkit and the Google-contributed TCMalloc from gperftools.