Performance Monitoring of MySQL Server: Following are the command which we can use for session or server level performance for MySQL server. SHOW GLOBAL STATUS – shows global server status SHOW LOCAL STATUS - This is used for session level server status Have to check following values to know how server works. Aborted_clients : Usually … Continue Reading
Tag Archives: Mysql Tuning
What to tune in MySQL Server after installation
Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance improvements. key_buffer_size – Very important if you use MyISAM tables. Set up to 30-40% of available … Continue Reading