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/replication-rules.html
If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. Instead, use filtering on the replica to control the events that are executed on the replica. On the replica ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
Because processors and cache memories have increased in speed more than disk storage devices, many workloads are disk-bound. Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
If joe connects from hosta.example.com, the connection matches the second inserted row. The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
Temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet been executed on the replica. The ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, any rows preceding the error have already been inserted. The exception is that, for TIMESTAMP and DATETIME columns, you ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-service.html
Important When installing an NDB Cluster program as a Windows service, you should always specify the complete path; otherwise the service installation may fail with the error The system cannot find the file specified. Once you are satisfied that ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. Just edit your script to correct the error, then tell mysql to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...