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/mysql-cluster-ndbinfo-threadblocks.html
The threadblocks table associates data nodes, threads, and instances of NDB kernel blocks. The threadblocks table contains the following columns: node_id Node ID thr_no Thread ID block_name Block name block_instance Block instance number Notes The ...Although the list of possible values is static for a given NDB Cluster release, the list may vary between ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. With the statement based logging format, all statements affecting BLACKHOLE tables are logged, but their effects ignored. When ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-table-from-file-name.html
Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names.
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
Table 8.11 Example authentication_policy Values authentication_policy Value Effective Policy '*' Permit only creating or altering accounts with one factor. Authentication involves one party establishing its identity to the satisfaction of a second ...Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
You can use the STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses with CREATE TABLE and ALTER TABLE statements to configure optimizer statistics for individual tables. You can manually modify the mysql.innodb_table_stats and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
Since there is currently no way using ndb_mgm or the mysql client to remove all data from a specific data node or node group, this means that the command succeeds only in the two following cases: After issuing CREATE NODEGROUP in the ndb_mgm client, ...TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be ...