PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-mta.html
NDB records all changes occurring in all user transactions committing in an epoch (TimeBetweenEpochs, default 100 milliseconds), in one binary log transaction, referred to as an epoch transaction. It may be possible or desirable to modify ...To use ...
https://dev.mysql.com/doc/refman/9.7/en/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 Version (or later) NDB 9.7.0 ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-tls.html
Node private keys are stored unencrypted, so that they can be opened automatically at node startup time. Start ndb_mgmd with the --reload and --config-file options both times to ensure that each of the two configuration file changes is read by the ... This section discusses the implementation and use of Transport Layer Security (TLS) to secure network communications in MySQL NDB ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/performance-schema-error-summary-tables.html
Each error summary table has these summary columns containing aggregated values: SUM_ERROR_RAISED This column aggregates the number of times the error occurred. SUM_ERROR_HANDLED This column aggregates the number of times the error was handled by an ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-log-status-table.html
binary_log_position The current binary log position at the time the log_status table was accessed. gtid_executed The current value of the global server variable gtid_executed at the time the log_status table was accessed. relay_log_pos The current ... The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-prepared-statements-instances-table.html
COUNT_REPREPARE The number of times the statement was reprepared internally (see Section 10.10.3, “Caching of Prepared Statements and Stored Programs”). COUNT_EXECUTE, SUM_TIMER_EXECUTE, MIN_TIMER_EXECUTE, AVG_TIMER_EXECUTE, MAX_TIMER_EXECUTE ...
https://dev.mysql.com/doc/refman/9.7/en/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 ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-status-by-worker-table.html
The applier threads on a multithreaded replica are sometimes called workers. When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for applied transactions are zero.