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/upgrade-troubleshooting.html
In this case, check the date for your mysql.h file and libmysqlclient.a library to verify that they are from the new MySQL distribution. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can ...If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and following LTS release series, as well as in MySQL 8.0. Since changing character sets can be a complex and time-consuming task, you should begin to prepare for this change now by ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
A CREATE LOGFILE GROUP statement has one and only one ADD UNDOFILE clause. This means that each Disk Data object must be uniquely named (and not merely each Disk Data object of a given type). For example, you cannot have a tablespace and a log file ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement creates a new log file group named logfile_group having a single UNDO file named ...
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
The error log contains a record of mysqld startup and shutdown times. For information about selecting the error message character set and language, see Section 12.6, “Error Message Character Set”, and Section 12.12, “Setting the Error Message ... This section discusses how to configure the MySQL server for logging of diagnostic messages to the error ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition ...The table type of the remote table may be any type supported by the remote mysqld server, including MyISAM or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read view. In this case, attempting to make changes to the database (for InnoDB, MyISAM, ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
(Also, for general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.) To use a keyring component instead, begin with Section 8.4.4.2, “Keyring Component Installation”. Note Only one keyring ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. (In other words, any condition in the WHERE clause is not used.) All standard join optimizations are performed, ...Table A is set to depend on all tables (except B) that are used in the LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
If you modify the grant tables indirectly using an account-management statement, the server notices these changes and loads the grant tables into memory again immediately. If you modify the grant tables directly using statements such as INSERT, ...