Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-batch-code-execution.html
For example: #!/usr/local/mysql-shell/bin/mysqlsh --file print("Hello World\n"); The script file must be marked as executable in the filesystem. If you need to create a MySQL Shell script that is independent of the protocol used for connecting to ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-configuring.html
For example you can get online help, connect to servers, change the current language being used, run reports, use utilities, and so on. This section describes the commands which configure MySQL Shell from the interactive code editor. The commands ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-getting-started.html
This section describes how to get started with MySQL Shell, explaining how to connect to a MySQL server instance, and how to choose a session type. Important It is recommended that you always use the most recent version available. The latest ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-install-starting.html
Open a terminal window (command prompt on Windows) and start MySQL Shell by issuing: > mysqlsh This opens MySQL Shell without connecting to a server, by default in SQL mode. When MySQL Shell is installed you have the mysqlsh command available.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-plugins-examples.html
Example 11.3 MySQL Shell plugin containing a report and an extension object This example defines a function show_processes() to display the currently running processes, and a function kill_process() to kill a process with a specified ID.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-read-replicas-monitoring.html
This section describes how to monitor your Read Replicas, view topologies, and so on. Status Describe Status For detailed information on the Cluster.status() method, see Section 8.7, “Monitoring InnoDB Cluster”. Read Replica information is ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-builtin.html
A listing of the current threads in the connected MySQL server (threads. MySQL Shell includes built-in reports to display the following information: The results of any specified SQL query (query. As with user-defined reports, the built-in reports ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting.html
MySQL Shell enables you to set up and run reports to display live information from a MySQL server, such as status and performance information. MySQL Shell's reporting facility supports both built-in reports and user-defined reports. Reports can be ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-diagnostics.html
MySQL Shell diagnostic utilities enable you to analyze the performance of your servers and generate diagnostics reports on overall health, performance under load, and individual queries. If the user connects to an instance using X Protocol, and ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json.html
MySQL Shell's JSON import utility util.importJSON() enables you to import JSON documents from a file (or FIFO special file) or standard input to a MySQL Server collection or relational table. The utility checks that the supplied JSON documents are ...