I am having to tune a client's MySQL server on a Windows machine but I only have access to the MySQL cli and some MySQLAdmin cli functions. I can't see how I can mysql-bench either because it needs to run on the same server as MySQL.
Is there a way I can benchmark or tune MySQL without having access to the OS? The Sysadmin who manages the server has told me just to send him any config changes and he will apply them but that will take forever going back and forth and I don't even know where the changes need to be made as I can't see anything on the system.
Anybody else had an issue like this?
Thanks.