PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. You can choose a setting that suits the workload of your group and your priorities for data reads and writes, taking into account the ...Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if they are issued ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication receiver thread is currently reading from the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The output contains lines beginning with ###: $> mysqlbinlog -v log_file ...These correspond to events ...# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
Organization of data on disk MySQL Server maps each database to a directory under the MySQL data directory, and maps tables within a database to file names in the database directory. Consequently, database and table names are case-sensitive in MySQL ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. The table therefore only ever contains seven rows of data, or is empty. Stages include DROP DATA, FILE COPY, PAGE_COPY, ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
The database structures are organized into physical files optimized for speed. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. Since computers are very good at ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
This is the number of 32-bit data words received in the last reporting interval for primary key operations using this TC as the transaction coordinator. For inserts and updates, this is proportional to the number of columns written, and the size of ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...Because some transactions committed in this reporting interval ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
From MySQL 8.0.27, you can set the GTID_ONLY option on the CHANGE REPLICATION SOURCE TO statement to stop a replication channel from persisting file names and file positions in the replication metadata repositories. However, because the file ...This ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data. Without an index, MySQL must begin with the first row and then read ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
Id Version (or later) NDB 8.0.13 Type or units unsigned Default [...] Range 1 - 255 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the ... The [ndb_mgmd] section is used to configure the behavior of the management ...Although Id continues to be supported for backward compatibility, it ...