Search Results
https://dev.mysql.com/doc/refman/9.7/en/thread-commands.html
Refresh The thread is flushing table, logs, or caches, or resetting status variable or replication server information. Daemon This thread is internal to the server, not a thread that services a client connection. A thread can have any of the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-buffer-pool-tables.html
Much of the same information is provided by SHOW ENGINE INNODB STATUS output, or may be obtained using InnoDB buffer pool server status variables. Do not query these tables on a production system unless you are aware of the performance impact and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-installation-windows-path.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. Next select the ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. To set the initial plugin state explicitly, you can set the variable at server startup. Statements run by users with the SKIP_QUERY_REWRITE privilege are not ...The plugin asks the server to parse it, and returns the result to the server as the representation of the rewritten ...By default, the Rewriter plugin ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-linux-source.html
Building NDB Cluster from source is similar to building the standard MySQL Server, although it differs in a few key respects discussed here. MySQL NDB Cluster 9.7 is built from the MySQL Server 9.7 sources, available from the MySQL downloads page at ... This section provides information about compiling NDB Cluster on Linux and other Unix-like ...
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. Figure 10.22 Migration Overview Page Setting Up ODBC Drivers To verify that you have the ODBC driver installed, click Open ODBC ...General ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. Run the server with change buffering disabled (innodb_change_buffering=0) and do a slow ...
MySQL Enterprise Backup 9.7 User's Guide :: Chapter 8 Using MySQL Enterprise Backup with Replication
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-replication.html
Backup and restore operations are especially important in systems that use MySQL replication to synchronize data across a source server and a set of replica servers. In a replication configuration, MySQL Enterprise Backup helps you manage images ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-file-per-table-tablespaces.html
Changing the setting at runtime requires privileges sufficient to set global system variables. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. Disabling ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-prepare.html
To migrate schemas and data from Microsoft SQL Server for use with MySQL, ensure the following: The source SQL Server instance is running, and accepts TCP connections. You know the IP and port of the source SQL server instance. If you will be ...