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-rolling-restart.html
When performing a rolling restart to update the cluster's configuration, you can use the config_generation column of the ndbinfo.nodes table to keep track of which data nodes have been successfully restarted with the new configuration. This section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
You can also check the status column of the ndbinfo.nodes table (see Section 21.6.15.28, “The ndbinfo nodes Table”, for more information). Single user mode enables the database administrator to restrict access to the database system to a single ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
These start phases are also reported in the start_phase column of the ndbinfo.nodes table. This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. More complete information can be found in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
rehash, \# Rebuild the completion hash that enables database, table, and column name completion while you are entering statements. mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
Field types view, where information about the columns of a result set is shown, such as names, data types, character sets, and more. This section explains how to use MySQL Shell to script a server using MySQL for Visual Studio. Introduction MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an argument ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
You can check such tables using CHECK TABLE, and then upgrade them to the newer temporal column format, if necessary, using REPAIR TABLE in the mysql client; this must be done prior to taking the backup. The following two sections provide ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-types.html
For information about how MySQL handles assignment of out-of-range values to columns and overflow during expression evaluation, see Section 11.1.7, “Out-of-Range and Overflow Handling”. These types include the exact numeric data types (INTEGER, ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. Permitted values are 0 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...