Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. For information about ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
--keyring-migration-password[=password] Command-Line Format --keyring-migration-password[=password] Type String The password of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
When the Performance Schema instruments a request (server command or SQL statement), it uses instrument names that proceed in stages from more general (or “abstract”) to more specific until it arrives at a final instrument name. Statement ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. If you wish to make such information hidden from queries that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
They can be created outside of the MySQL data directory, are capable of holding multiple tables, and support tables of all row formats. Every tablespace in a MySQL instance has the same page size. By default, all tablespaces have a page size of ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not practical. Once your data reaches a stable size, or a growing table has increased by tens or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
When using a raw disk partition, ensure that the user ID that runs the MySQL server has read and write privileges for that partition. For example, if running the server as the mysql user, the partition must be readable and writeable by mysql. To do ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
This section discusses the implementation and use of Transport Layer Security (TLS) to secure network communications in MySQL NDB Cluster. To minimize the impact of certificate expiration on system availability, a cluster should have several ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON When the server starts, it sees performance_schema and attempts to initialize the Performance Schema. To enable or disable it explicitly, start the server with ...
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how to use them. You can also find information about functionality missing from MySQL Server, and how to work around some of the differences. We are ...