Mysql

Tuning

MySQLTuner

Run this perl script for recommendations: GitHub: major/MySQLTuner-perl

Code Snippets

Save last inserted ID into variable

SELECT LAST_INSERT_ID() INTO @last_user_id;