Performance Tuning Files HOWTO
To gather the data for your free performance audit, login to your MySQL server as the "root" operator or at least
someone with SUPER privileges. Below are the commands to execute which will create two text files: variables.txt and
status.txt. These files will then be uploaded to Valcora's Perormance Audit engine and an immediate evaluation will be
available!
Don't worry, there is no personal data or company trade secrets in these status and variable values! These are just
diagnostics for your server that we can examine to determine how well or how poorly your server may be running.
You may also use something like MySQL Query Browser to get these values and save them out to your local hard-drive.
Whatever approach is easist for you!
To Get Variables Values:
mysql> TEE variables.txt;
mysql> SHOW VARIABLES;
+-------------------------+---------+
| Variable_name | Value |
+-------------------------+---------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
....
....
+-------------------------+---------+
mysql> NOTEE;
To Get Status Values:
mysql> TEE status.txt;
mysql> SHOW GLOBAL STATUS;
+-----------------------------------+----------+
| Variable_name | Value |
+-----------------------------------+----------+
| Aborted_clients | 2159 |
| Aborted_connects | 8577 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 3011 |
....
....
+-----------------------------------+----------+
mysql> NOTEE;
Finishing Up
The last step is to either SCP or FTP the files to somewhere where you can access them, such as a laptop or desktop
computer. You can then browse for the files on the Performance Audit page and you are finished!
|
|
