Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
One file is always created per table by this utility, regardless of release version. If you create the table export file on your local system, you need to transfer it to the Oracle Cloud Infrastructure Compute instance using the copy utility of your ... MySQL Shell's table export utility util.exportTable() exports a MySQL relational table into a data file, either on the local server or in an Oracle Cloud Infrastructure Object Storage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ...ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is ... The following list includes command-line options, system ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ...ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Added the following columns to the tp_thread_state table: TIME_OF_ATTACH, MARKED_STALLED, STATE, EVENT_COUNT, ACCUMULATED_EVENT_TIME, EXEC_COUNT, and ACCUMULATED_EXEC_TIME Added the following columns to the tp_thread_group_state table: ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD ...
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-working-with-relational-tables.html
The X DevAPI SQL CRUD functions allow you to work with relational tables in manners similar to using traditional SQL statements. The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. When viewed in terms of events, the process of checking table options is the same for both row-based ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 19.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...