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/innodb-enabling-monitors.html
Note To enable the InnoDB Lock Monitor for SHOW ENGINE INNODB STATUS output, you are only required to enable innodb_status_output_locks. Obtaining Standard InnoDB Monitor Output On Demand As an alternative to enabling the standard InnoDB Monitor for ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
Consider modifying the setting when encountering the following issues: Statistics are not accurate enough and the optimizer chooses suboptimal plans, as shown in EXPLAIN output. Where stat_name=n_diff_pfxNN, the stat_description column shows a comma ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
Displaying Buffer Pool Load Progress To display progress when loading the buffer pool, issue the following statement: SHOW STATUS LIKE 'Innodb_buffer_pool_load_status'; If the operation has not yet started, “not started” is returned. The ... To ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
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 XML. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-initial-start.html
The output should appear similar to what is shown here: C:\mysql\bin> ndb_mgmd 2010-06-23 07:53:34 [MgmtSrvr] INFO -- NDB Cluster Management Server. (See Section 21.3.2.4, “Installing NDB Cluster Processes as Windows Services”, where we show how ... Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Whether or not explicit assignments are made, they can be viewed in the output of the management client's SHOW command. When the number of local scan records is not provided, it is calculated as shown here: 4 * MaxNoOfConcurrentScans * [# data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-arbitrator-validity-detail.html
The arbitrator_validity_detail table shows the view that each data node in the cluster has of the arbitrator. All nodes should show the same arbitrator and arb_ticket values as well as the same arb_state value. arb_connected shows whether the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-membership.html
If the president fails or becomes disconnected, the current node expects the node whose ID is shown in the successor column to become the new president. The succession_order column shows the place in the succession queue that the current node views ... The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
The total free space available on all variable-sized pages in the fragment is shown by the var_elem_free_bytes column; because this space may be spread over multiple pages, it cannot necessarily be used to store an entry of a particular size.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
Only nodes that are connected to the cluster are shown in this table. For an executable shipped with the NDB Cluster distribution, node_version shows the two-part MySQL NDB Cluster version string, such as 5.7.44-ndb-7.5.36 or 5.7.44-ndb-7.6.36, that ... This table contains information about NDB Cluster node processes; each node is represented by the row in the ...