PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
If you add a version number after the ! character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version number. The KEY_BLOCK_SIZE clause in the following comment is executed only by ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-source.html
Neither of these executables requires a specific location on the host machine's file system. The only executable required on a data node host is the data node binary ndbd or ndbmtd. If you want to run multiple SQL nodes, you can use a copy of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The plugin implements a thread pool that ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
Invoke mysql_ssl_rsa_setup like this: mysql_ssl_rsa_setup [options] Typical options are --datadir to specify where to create the files, and --verbose to see the openssl commands that mysql_ssl_rsa_setup executes. In the absence of this option, files ... This program creates the SSL certificate and key files and RSA key-pair files required to support secure connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
For example, instead of: mysql> CREATE TABLE tablea (columna int) Engine=MyISAM; Use this format: mysql> SET default_storage_engine=MyISAM; mysql> CREATE TABLE tablea (columna int); When replicated, the default_storage_engine variable will be ... It ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
The server executes the contents of the file named by the init_file system variable at startup, changing the 'root'@'localhost' account password. Start the MySQL server with the init_file system variable set to name the file: $> mysqld ... If you ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. MySQL Enterprise Edition includes a thread pool plugin that manages connection threads to increase server performance by efficiently managing ... MySQL supports an plugin API that enables creation of server ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
On each replica node, extract the INSTALL PLUGIN statement from the installation script and execute it manually. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; ... This section ...