VIVO Documentation
Page History
Table of Contents
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: |
...
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.
Overview
Content Tools