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-restarting-group.html
Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned issues. For Group ...In ...As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
NDB Cluster imposes a maximum length of 63 characters for names of databases and tables. Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each ...The sizes of the identifier string columns in the grant tables are measured in ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...See ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ...--defaults-extra-file=file_name, --extra-file=file_name, -e file_name Read this option file after the global option file but (on Unix) before the user option ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
If the MySQL server is started with --innodb-read-only but the data directory is still on writeable media, the root user can still perform DCL operations such as GRANT and REVOKE. To prepare an instance for read-only operation, set ...How to Enable ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
For example: SET time_zone = 'MET'; Unique UTC values stored in the TIMESTAMP column are not unique in the session time zone due to DST shifts. (This is the same type of conversion performed by the CONVERT_TZ() function. If the session time zone is ... Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
As a result, there are possible performance improvements when using file-per-table tablespaces in conjunction with this setting. The innodb_autoextend_increment variable, which defines the increment size for extending the size of an auto-extending ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
For more complicated setups, you may want to remove some of the arguments and instead rely on a MySQL configuration file, such as my.cnf. Additional launchd related information: The plist entries override my.cnf entries, because they are passed in ... macOS uses launch daemons to automatically start, stop, and manage processes and applications such as ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. This is common for options that you want ...List the options in an option file that the program reads when it ...