PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition-direct.html
Setting up a cluster using direct connections between data nodes requires specifying explicitly the crossover IP addresses of the data nodes so connected in the [tcp] section of the cluster config.ini file. In the following example, we envision a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-api-statistics.html
On platforms without sufficient (nanosecond) time resolution, small changes in the value of the WaitNanosCount NDB API counter due to SQL statements that execute very quickly may not always be visible in the values of ...Table 21.61 NDB API ... A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
You need this information when configuring the replica so that the replica knows where in the binary log to start executing events. When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log. The Logging Options step enables you to define custom file paths for ...Otherwise, the process stops and displays an error message if an individual action times ...Unlike the initial setup, which ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
The online DDL feature provides support for in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where GTIDs are in use (gtid_mode is ON), issuing RESET MASTER resets the GTID execution history. The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...