Search Results
https://dev.mysql.com/doc/refman/9.7/en/table-locking.html
Workarounds for Locking Performance Issues The following items describe some ways to avoid or reduce contention caused by table locking: Consider switching the table to the InnoDB storage engine, either using CREATE TABLE ... You might have to ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. The MySQL installation procedure creates the time zone tables, but does not load them. This section describes the time ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-troubleshooting.html
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use DROP FUNCTION to drop the loadable ... A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 9.7 to ...
https://dev.mysql.com/doc/refman/9.7/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The output can be saved in a file and reloaded later using mysql to recreate the ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...
https://dev.mysql.com/doc/refman/9.7/en/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-encryption-options.html
These options are for creating encrypted single-file backups and for decrypting them. --encrypt Encrypt the data when creating a backup image by a backup-to-image operation, or when packing a backup directory into a single file with the ...See ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-message-logging-options.html
mysqlbackup writes important progress and error information to the stderr stream. The information is often very valuable for tracking down problems that occur during an operation. Starting from MySQL Enterprise Backup 3.9, the output to the stderr ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-performance.html
See Section 4.3.4, “Making a Compressed Backup” and Section 20.6, “Compression Options” for information about creating compressed backups. (The copying and scanning mechanisms used by mysqlbackup do not rely on indexes to do their work.) For ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...