PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
Check the server error log for information about what went wrong. The number of Performance Schema tables increases over time as implementation of additional instrumentation proceeds. row *************************** THREAD_ID: 0 EVENT_ID: 5523 ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multicurve.html
A MultiCurve is a geometry collection composed of Curve elements. A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A ...
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
The following error is raised if you try to execute such a statement: ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state Statements to which the preceding remark applies are listed at ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. [Occurred during startphase start_phase.] [ Initiated by signal.] ... The following table lists the most common NDB cluster log ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. You can monitor these status variables to access runtime performance characteristics. mysqld, also known as MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. If the system performs DML operations on compressed tables, and the way the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...