PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d container-registry.oracle.com/mysql/community-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts the MySQL Server with utf8mb4 as the default character set and ...A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.45. 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.0 are noted in the present text with reference to release numbers ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Does MySQL permit CJK characters to be used in database and table names? A.11.18. Make sure that the database is actually using the desired character set. Does MySQL permit CJK characters to be used in database and table names? Yes. This set of ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
NAME The name of the table, preceded by the schema (database) name where appropriate (for example, test/t1). Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.