We do not have access to our servers with operating system console. Our production environment is Ubuntu 12.
Is it possible to use mysqltuner from remote host?
If yes, please provide guidelines. We are using mysql5.6
MySQL – How to Use mysqltuner from Remote Host
MySQLmysqltuner
Related Question
- MySQL: Show full processlist has empty Host name. Why
- Mysql – How and where do I upload a thesql database
- Mysql – tmp_table_size with mostly InnoDB tables
- MySQL Remote Host – Security of Connecting to Port 3306
- MySQL – How to Migrate Schema Structure from One Server to Another
- MySQL – How to Verify if User@Host with Password Exists in MySQL 8.0+
- Mysql – Remote accessing a MySQL server for non-root user
Best Answer
What I am about to show you comes from lines 89-122 of the mysqltuner.pl code:
You will still have to connect like a mysql client:
Since you are using a remote host, use parameters to supply values from the OS
You may have to contact your remote SysAdmin to ask how much RAM and swap you have
If the database has too many tables, or very large table, use this: