Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Option file: [mysqld] innodb_file_per_table=ON Using SET GLOBAL at runtime: mysql> SET GLOBAL innodb_file_per_table=ON; File-Per-Table Tablespace Data Files A file-per-table tablespace is created in an .ibd data file in a schema directory under the ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
FOR SHARE statements do not acquire read locks on MySQL grant tables. In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = ... If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. Reduced locking and waiting for MySQL ...An exclusive metadata lock on the table may be taken briefly during the execution phase of the ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea. Create a New Data Directory With this method, the data directory is in the same ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. Most tables manage with 2 bytes, but this cannot be controlled from MySQL yet. Most tables manage with 2 bytes, ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...Use ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
This section describes a process for configuring and starting GTID-based replication in MySQL 8.4. The mysqld options necessary to start the servers as described are discussed in the example that follows later in this section. In the following ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent ...