PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. Name locking is used for operations such as dropping or renaming ... SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table ...
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/caching-sha2-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to MySQL 8.0 from an ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
This requirement permits database administrators to control where tablespace data files are created and ensures that data files can be found during recovery (see Tablespace Discovery During Crash Recovery). In this case, you can restore the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
Pages, Extents, Segments, and Tablespaces Each tablespace consists of database pages. Dropping a table or deleting all rows from it is guaranteed to release the space to other users, but remember that deleted rows are physically removed only by the ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
For example: --innodb-temp-data-file-path=../../../tmp/ibtmp1:12M:autoextend As of MySQL 8.0, enabling innodb_read_only prevents table creation and drop operations for all storage engines. These operations modify data dictionary tables in the mysql ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...