PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-schema.html
DBAs can also use this feature for capacity planning, to see whether their typical workload encounters any performance bottlenecks with a particular combination of CPU, RAM, and disk storage; and if so, to judge whether performance can be improved ... This section provides a brief introduction to InnoDB integration with Performance ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the following stored procedure, which adds .0001 to a variable 1,000 times. That is, for two ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time Functions”. The result is determined according to the following rules: In the case of -, +, and *, the result is calculated with BIGINT (64-bit) precision if both ... Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
This data includes timestamps showing how long it took the applier thread to apply the last transaction from start to finish (and when the transaction currently in progress was started), and how long this was after the commit on the original source ... The global value of the system variable replica_transaction_retries (from MySQL 8.0.26) or slave_transaction_retries (before MySQL 8.0.26) sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before ...
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 ...