snippetsqlMinor
How to use mysqltuner from remote host
Viewed 0 times
mysqltunerhosthowremotefromuse
Problem
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
Is it possible to use mysqltuner from remote host?
If yes, please provide guidelines. We are using mysql5.6
Solution
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:
You will still have to connect like a mysql client:
Connection and Authentication
--host Connect to a remote host to perform tests (default: localhost)
--socket Use a different socket for a local connection
--port Port to use for connection (default: 3306)
--user Username to use for authentication
--pass Password to use for authenticationSince you are using a remote host, use parameters to supply values from the OS
--forcemem Amount of RAM installed in megabytes
--forceswap Amount of swap memory configured in megabytesYou 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:
--skipsize Don't enumerate tables and their types/sizes (default: on)
(Recommended for servers with many tables)Code Snippets
Connection and Authentication
--host <hostname> Connect to a remote host to perform tests (default: localhost)
--socket <socket> Use a different socket for a local connection
--port <port> Port to use for connection (default: 3306)
--user <username> Username to use for authentication
--pass <password> Password to use for authentication--forcemem <size> Amount of RAM installed in megabytes
--forceswap <size> Amount of swap memory configured in megabytes--skipsize Don't enumerate tables and their types/sizes (default: on)
(Recommended for servers with many tables)Context
StackExchange Database Administrators Q#95286, answer score: 5
Revisions (0)
No revisions yet.