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/ndb-restore-to-different-version.html
In addition, you should consult Section 25.3.7, “Upgrading and Downgrading NDB Cluster”, for other issues you may encounter when attempting to restore an NDB backup to a cluster running a different version of the NDB software. It is also ... The ...
https://dev.mysql.com/doc/refman/8.0/en/option-file-options.html
Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be given on the command line and not in an option file. On Windows, if the server is started with the ...To ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
In MySQL 8.0, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning handler. In MySQL 8.0, only the InnoDB and NDB storage engines provide native partitioning handlers.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
row *************************** SCHEMA_NAME: mydb DIGEST: bb3f69453119b2d7b3ae40673a9d4c7c BUCKET_NUMBER: 42 BUCKET_TIMER_LOW: 66069344 BUCKET_TIMER_HIGH: 69183097 COUNT_BUCKET: 1 COUNT_BUCKET_AND_LOWER: 1 BUCKET_QUANTILE: 0.058824 ... The ...To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. status_by_host has HOST and ... The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. You invoke it ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. The validate_password component implements these capabilities: For SQL statements that assign a password ...This component exposes system variables that enable you to configure password policy, and status variables for component ...(For general information about ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
row *************************** ID: 5 USER: event_scheduler HOST: localhost DB: NULL COMMAND: Daemon TIME: 137 STATE: Waiting on empty queue INFO: NULL *************************** 2. row *************************** ID: 9 USER: me HOST: ...Otherwise ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
When a given index value yields a large number of rows, the index is less useful and MySQL is less likely to use it. The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average ... Storage engines collect statistics about tables for use by the ...