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/environment-variables.html
The AND operation may remove read and write permissions from the directory mode, but not execute permissions. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. When each change is followed by a commit (as with the default autocommit ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). Clients can prevent installation of SIGPIPE handlers by specifying the ... On Unix and ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key to reduce the set of rows selected, RAND() is executed fewer times, which diminishes the effect of nondeterminism on optimization. The ...A ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
If you use any of those statements but specify an xid value that does not correspond to some existing XA transaction, an error occurs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. This statement transfers the GTIDs for the transactions executed on the source ...In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. Once START SLAVE has been executed, the value of the ...