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/alter-tablespace.html
You cannot drop a data file from a tablespace which is in use by any table; in other words, the data file must be empty (no extents used). In addition, any data file to be dropped must previously have been added to the tablespace with CREATE ...The ...It can be used to add a new data file to, or to drop a data file from an NDB ...You may optionally follow size with a ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options: DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE DISABLE_PSI_IDLE DISABLE_PSI_MEMORY ...For example, ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. You ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...After deleting a large part of a ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. As of MySQL 8.0.19, the InnoDB storage engine provides its own sampling implementation ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
It was used to set the file name for the replica's connection metadata repository if master_info_repository=FILE was set. --master-info-file and the use of the master_info_repository system variable are deprecated because the use of a file for the ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
InnoDB support for two-phase commit in XA transactions ensures that the binary log and InnoDB data files are synchronized. From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...It also contains events for ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
For tables using MyISAM or other non-InnoDB storage engines, it does a “warm” backup, where the database continues to run, but those tables cannot be modified while being backed up. Is there an advantage to using the InnoDB storage engine ...Can ...Where can I obtain complete documentation for MySQL storage engines? ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
In addition, if --ndb-nodeid is used, then either a matching node ID must be found in a [mysqld] or [api] section of config.ini, or there must be an “open” [mysqld] or [api] section in the file (that is, a section without a NodeId or Id ...For ...For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. There are three means of integrity checking: MD5 checksums Cryptographic signatures using ...