Search Results
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is offline. For example, after relocating the data directory, you ...During startup, discovered tablespace files are used instead those referenced in the data dictionary, and the data dictionary is updated to reference the relocated ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-servers.html
You can run multiple servers on Windows by starting them manually from the command line, each with appropriate operating parameters, or by installing several servers as Windows services and running them that way. The following sections describe how ...General instructions for running MySQL from the command line or as a service are given in Section 2.3, “Installing MySQL on Microsoft ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
If this happens, you should check all your tables with myisamchk (see Chapter 7, MySQL Server Administration), and test the queries in the MySQL log files to see whether one fails. When the server detects MyISAM table corruption, it writes ... Note ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-ldap.html
LDAP pluggable authentication is a feature supported by the MySQL Enterprise Edition; the user by which mysqlbackup connects to the server can be authenticated using LDAP.
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
To explicitly cause the server to refuse or permit LOAD DATA LOCAL statements (regardless of how client programs and libraries are configured at build time or runtime), start mysqld with --local-infile disabled or enabled, respectively. The CMake ...Typically, you do this using options on the CMake command ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-get-server-version.html
This function is useful in client programs for determining whether some version-specific server capability exists. unsigned long mysql_get_server_version(MYSQL *mysql) Description Returns an integer that represents the MySQL server version. The ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reset-server-public-key.html
This might be necessary when the server has been restarted with a different RSA key pair after the client program had called mysql_options() with the MYSQL_SERVER_PUBLIC_KEY option to specify the RSA public key. void ...In such cases, connection ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-server-starting-unix-osx.html
The following services are installed by MySQL Enterprise Service Manager: MySQL Server Tomcat Server Access MySQL Enterprise Service Manager services using the script mysqlmonitorctl.sh/mysqlmonitor.bat which is installed in the root of your MySQL ... This section describes how to control MySQL Enterprise Service Manager services on UNIX, Linux and Mac ...