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/group-replication-the-group.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. If a server joins ...
https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/filename.frm' ... If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat-50ms.html
The cpustat_50ms table provides raw, per-thread CPU data obtained each 50 milliseconds for each thread running in the NDB kernel. Like cpustat_1sec and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
Attempts to access such objects may produce an error if they execute in definer security context. An error occurs if you try to drop an account that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each named ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. Example usage: innochecksum --version --verbose, -v Command-Line Format --verbose Type Boolean Default Value false Verbose mode; ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
In this case, error 1964 Multiple channels exist on the slave. When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
To make menagerie the current database, use this statement: mysql> USE menagerie Database changed Your database needs to be created only once, but you must select it for use each time you begin a mysql session. Note You can see at any time which ...