Search Results
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The import server uses /tmp/mysql-files as the directory named by its secure_file_priv ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB Enhancements and New Features For information about InnoDB enhancements and new features, refer to: The InnoDB enhancements list in Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”. Additional InnoDB Information and Resources For ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. For locking performed on MySQL files by other programs, see Section 10.11.5, ...This ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. For general information about plugin services, see Section 7.6.9, ...As a C language interface, callable as a plugin service from server plugins or loadable ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.4. The function may consist of any expression valid in MySQL that yields an integer value. This type of partitioning is similar to partitioning by HASH, except that ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. Use the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G ...For ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
The MySQL server maintains system variables that configure its operation. SET can also be used to persist certain global system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To ...A ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... If you are using the C API, the affected-rows count can be obtained using the mysql_affected_rows() function. MySQL uses the following ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...