https://dev.mysql.com/mysql-cluster-programs-ndbinfo-select-all.html
All NDB 8.0 releases --loops=#, -l Set the number of times to perform the select. --loops=number, -l number Property Value Command-Line Format --loops=# Type Numeric Default Value 1 Minimum Value 0 Maximum Value MAX_INT This option sets the number ... ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ndbinfo database Not all ndbinfo tables available in the mysql client can be read by this ...
https://dev.mysql.com/mysql-cluster-replication-schema.html
Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and the replication slave (whether the slave is a single server or a ...
https://dev.mysql.com/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. ShmSpinTime Table 22.277 This table ...
https://dev.mysql.com/mysql-command-options.html
(See Section 6.2.16, “Server Handling of Expired Passwords”.) --connect-timeout=value The number of seconds before connection timeout. A single reconnect attempt is made each time the connection is lost. This option can be given multiple times ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/mysql-enterprise-monitor.html
For example, you can view aspects such as server load, query numbers, or index usage information as a graph over time. The graph lets you pinpoint problems or potential issues on your server, and can help diagnose the impact from database or ...
https://dev.mysql.com/mysql-stmt-attr-set.html
This function may be called multiple times to set several options. STMT_ATTR_PREFETCH_ROWS unsigned long * Number of rows to fetch from server at a time when using a cursor. The following example opens a cursor for a prepared statement and sets the ... bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Can be used to affect behavior for a prepared ...
https://dev.mysql.com/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. Note When adding ...
https://dev.mysql.com/pam-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. If you installed the plugin at runtime using an INSTALL PLUGIN statement, it remains installed across server restarts. The PAM authentication plugin checks at ...
https://dev.mysql.com/partitions-table.html
UPDATE_TIME The time that the partition or subpartition was last modified. CHECK_TIME The last time that the table to which this partition or subpartition belongs was checked. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. Performance Schema displays event timer information in ... The ...
