PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-examples.html
With each iteration, investigation should lead closer and closer to the root cause of the problem, as the “signal/noise” ratio improves, making analysis easier. The Performance Schema is a tool to help a DBA do performance tuning by taking real ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-monitoring.html
If the server has insufficient resources for the plugin's instruments and you do not explicitly allocate more using --performance_schema_max_mutex_classes=N, loading the plugin leads to starvation of instruments. Names for these variables have ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
This is less efficient; it may also lead to the parameter's (or variable's) actual type to vary, and thus for results to be inconsistent, with subsequent executions of the prepared statement. PREPARE stmt_name FROM preparable_stmt The PREPARE ...
https://dev.mysql.com/doc/refman/9.7/en/privileges-provided.html
Prior to MySQL 9.7, any user could execute the XA RECOVER statement to discover the XID values for outstanding prepared XA transactions, possibly leading to commit or rollback of an XA transaction by a user other than the one who started it. The ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-float.html
Attempts to treat floating-point values as exact in comparisons may lead to problems. Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL ...
https://dev.mysql.com/doc/refman/9.7/en/program-variables.html
In an option file, variable settings are given without the leading dashes: [mysql] max_allowed_packet=16777216 Or: [mysql] max_allowed_packet=16M If you like, underscores in an option name can be specified as dashes. Many MySQL programs have ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-js-programs.html
If the replica has the MLE component installed, an error is raised when the replica attempts to execute such a statement, leading to a break in replication. A JavaScript stored program created on a server without the component installed is not ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transactions.html
That is, such transactions can lead to source storage engine-specific behavior with the possible effect of replication going out of synchrony. In MySQL 9.6 (and later), transactions that update both transactional tables and tables which are ...