Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. If you want to direct the output to the console window rather than to the error log, ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster Replication”). Ensure that each MySQL server acting as a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-security-procedures.html
In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
-h host_name Type String Default Value * Host name of MySQL server for *-slow.log file name. -i name Type String Name of server instance (if using mysql.server startup script). The MySQL slow query log contains information about queries that take a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/standard-options.html
Full descriptions for these options can be found in the MySQL reference manual, for example in Server Option, System Variable, and Status Variable Reference. These options must be specified ahead of any other mysqlbackup options, including the rest ... The general options are options of a general nature, or options that are not classified under any other specific option group: The following general options also exist for the mysql ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
The currently bound parameter marker values are sent to server during this call, and the server replaces the markers with this newly supplied data. For more information, see Caching of Prepared Statements and Stored Programs. CR_SERVER_LOST The ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. Setting Up Target Parameters Next, set up the target (MySQL) database parameters by defining the parameters that connect to your MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note Authentication Yes Yes Yes Yes Auto_Increment Yes Yes Yes Yes PostgreSQL uses sequences for Auto_Increment. The ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
This example migrates a Microsoft SQL Server database to MySQL and includes an image for each step. The Open ODBC Administrator option will load odbcad32.exe, and is used to confirm that the ODBC Driver for SQL Server is installed, and to make ...