Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Alternatively, you can drop and re-create such indexes immediately following the upgrade, but before making use of any of the tables in which they occur. The Performance Schema variables_info table shows, for each system variable, the source from ...
https://dev.mysql.com/doc/refman/8.4/en/use.html
The named database remains the default until the end of the session or another USE statement is issued: USE db1; SELECT COUNT(*) FROM mytable; # selects from db1.mytable USE db2; SELECT COUNT(*) FROM mytable; # selects from db2.mytable The database ... USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
(Exception: A user with access to the Performance Schema user_variables_by_thread table can see all user variables for all sessions.) All variables for a given client session are automatically freed when that client exits. (This is the same ... You ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
A relational database stores data in separate tables rather than putting all the data in one big storeroom. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. Alternatively, on any version of Windows supported by MySQL, you can create a symbolic link to a MySQL database by creating a .sym file in the data directory that ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of backup progress and history in logging tables inside the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
When working with a Group Replication setup, mysqlbackup makes the backup information available to all members of the server group by making sure that the backup_history, backup_sbt_history (when using the SBT API), and backup_progress tables are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-troubleshooting.html
As mysqlbackup proceeds, it writes progress information into the mysql.backup_progress table. When the command finishes the backup operation, it records status information in the mysql.backup_history table. You can query those tables to monitor ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
The unique ID for this backup job is recorded in special tables that mysqlbackup creates inside the MySQL instance, allowing you to monitor long-running backups and view information on previous backups. In the following illustration, we back up an ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/platforms.compatibility.html
However, because Identifier Case Sensitivity is dependent on the case sensitivity of the underlying operating system (which varies across platforms), data transfer problems might occur due to letter case issues with the database or table names. All ... MySQL Enterprise Backup is by nature cross-platform compatible when running on the Linux and Windows operating systems: backups on a Linux machine can, in principle, be restored on a Windows machine, and vice ...