PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
The processes table contains the following columns: node_id The node's unique node ID in the cluster node_type Type of node (management, data, or API node; see text) node_version Version of the NDB software program running on this node. The ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-operations.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
Use the directional arrows to move each product from the Available Products column to the Products To Be Installed column. The Reconfigure link in the Quick Action column next to each installed server loads the current configuration values for the ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
This column can be modified, although setting ENABLED has no effect for instruments that have already been created. This column can be modified, although setting TIMED has no effect for instruments that have already been created. For memory ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
The socket_instances table has these columns: EVENT_NAME The name of the wait/io/socket/* instrument that produced the event. This combination value is used in the OBJECT_NAME column of the events_waits_xxx tables, to identify the connection from ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Check this by executing mysql -u root mysql and issuing this SQL statement: SELECT * FROM user; The result should include a row with the Host and User columns matching your client's host name and your MySQL user name. If you do not know the IP ...
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
ANALYSE() examines the result from a query and returns an analysis of the results that suggests optimal data types for each column that may help reduce table sizes. PROCEDURE ANALYSE([max_elements,[max_memory]]) For example: SELECT col1, col2 FROM ... ANALYSE([max_elements[,max_memory]]) Note PROCEDURE ANALYSE() is deprecated as of MySQL 5.7.18, and is removed in MySQL ...