Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html
Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the relay log (including all statements modifying data that have been ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you would like MySQL to start automatically, you can copy support-files/mysql.server to /etc/init.d and create a symbolic link to it named /etc/rc3.d/S99mysql.server. If too many processes try to connect very rapidly to mysqld, you should see ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
To enable recursion, set the max_sp_recursion_depth server system variable to a value greater than zero. If you increase the value of max_sp_recursion_depth, it may be necessary to increase thread stack size by increasing the value of thread_stack ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
Note The more instruments and consumers enabled, the more impact on MySQL server performance. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version.html
This view provides the current sys schema and MySQL server versions. For example, use the VERSION() function to retrieve the MySQL server version. Note This view is deprecated, and subject to removal in a future MySQL version. Applications that use ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. mysql may also be used in batch mode: you place your ...If ...
https://dev.mysql.com/doc/refman/8.4/en/uln-installation.html
Both Community and Commercial packages are supported, and each offers three MySQL channels: Server: MySQL Server Connectors: MySQL Connector/C++, MySQL Connector/J, MySQL Connector/ODBC, and MySQL Connector/Python. Once MySQL has been installed ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
The server executes the plugin's deinitialization function and removes the row for the plugin from the mysql.plugin system table, so that subsequent server restarts do not load and initialize the plugin. UNINSTALL PLUGIN plugin_name This statement ...You cannot uninstall a plugin if any table that uses it is ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...