MySQL Tuning Primer Script

host option

Asked by willky

There is no $host option in the scripts. I want to use this script for checking the remote mysql server also.
In some case, I can't copy this script on the remote host running mysql server.
How can I check the mysql server on remote host in this case?

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Tuning Primer Script Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
TodoInTX (matt-day32) said : 		#1

tuning-primer must only be run locally since it relies upon the OS for some information about the system and MySQL.
For example, in MySQL versions pre-5.0 tuning-primer has to read the size of files from disk to calculate data/index size for MyISAM tables. Also, for all MySQL versions tuning-primer must rely upon the local OS to expose the amount of physical RAM available in the system for the MEMORY USAGE tests.

Alternatively, the project https://launchpad.net/mysqltuner which was derived from my work here is able to connect to a remote servers and make similar recommendations.

Can you help with this problem?

Provide an answer of your own, or ask willky for more information if necessary.

To post a message you must log in.