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/role-names.html
As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column Properties. It is possible for a row in the mysql.user system table to serve as both an account and a role. Specifying a ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.0/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. InnoDB performs a bulk load instead of inserting one index record at a time when ...In ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
The server does not create threads to handle interfaces that it does not listen to. For example, a Windows server that does not have support for named-pipe connections enabled does not create a thread to handle them. Manager threads create a new ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. This section explains how to create a replication group with three MySQL Server instances on one ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
To start the MySQL server use systemctl: $> systemctl start mysqld The database tables are automatically created for you, if they do not already exist. During installation, the initial database is created, and you are prompted for the MySQL root ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
There are different methods of setting up a data directory for a new instance: Create a new data directory. Even when the preceding precautions are observed, this kind of setup works only with MyISAM and MERGE tables, and not with any of the other ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
To do this, create an option file for each server and tell the server the file name with a --defaults-file option when you run it. Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
This method is simple and effective, but requires the replica to read the binary log from the source; it can sometimes take a comparatively long time for the new replica to catch up with the source, so this method is not suitable for fast failover ... There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for ...