Search Results
https://dev.mysql.com/doc/refman/9.7/en/cursor-restrictions.html
Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the max_heap_table_size and tmp_table_size system variables. Server-side cursors are implemented in the C API using the ...For example, ...
https://dev.mysql.com/doc/refman/9.7/en/using-log-files.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, you should check all your tables ... Note that before starting mysqld with the general query log enabled, you should check all your tables with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/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/mysql-installer/en/server-authentication-method.html
However, if you are unable to update your clients and applications to support this new authentication method, you can configure the MySQL server to use mysql_native_password for legacy authentication. It is recommended that all new MySQL server ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/heatwave-aws/en/heatwave-aws-upgrading-myql-server.html
Upgrade MySQL Version 3.4.9 Upgrade MySQL Version Note: It is not possible to roll back a DB System upgrade. It is recommended to perform a full backup of the DB System before upgrading. Updates happen automatically during the Maintenance Window ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
Checks on foreign keys are controlled by the foreign_key_checks system variable. MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/restoring.html
The ultimate purpose of backup data is to help recover from a database issue or to create a clone of the original database server in another location (typically, to run report queries or to create a new replica). If a hardware issue requires ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.