If you’re not a trained, experienced MySQL DB admin that knows all the ins and outs of MySQL, but still needs to reasonably admin and tune a MySQL server on Linux/Unix, these two tools, mysqltuner and tuning-primer, should come in handy. They’re sometimes a little difficult to find, which is why I include them right here:
Please see the code for copyright etc.