Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The INDEX_ID is an identifier for the index that is unique across all databases in an instance. Example 17.4 Joining InnoDB INFORMATION_SCHEMA Schema Object Tables This example demonstrates joining three InnoDB INFORMATION_SCHEMA schema object ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. In some cases of database corruption, it is enough to dump, drop, and re-create one or a few ...To ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.4, through release 8.4.6. Because this manual serves as a reference, it does not provide general instruction on SQL or relational database concepts. The MySQL Database Software ...Differences between minor versions of MySQL 8.4 are noted in the present text with reference to release numbers ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. --database, -d Specifies the name of the database in which the desired table is found. If this option is given, the name of a table must follow the database name. If this ...By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
To guard log files against unwarranted exposure, locate them in a directory that restricts access to the server and the database administrator. If the server logs to tables in the mysql database, grant access to those tables only to the database ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as a written record of all events that modify database structure or content (data) from ...Each replica that connects to the source requests a copy of the binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). Depending on the configuration, you can replicate all databases, selected databases, or even ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...