PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated using row-based format. For most users, the mixed replication format should provide the best ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a bottleneck. One way to improve the performance of the replication process is to create a deeper replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Analytics - live data can be created on the source, while the analysis of the information can take place on the replica without affecting the performance of the source. Long-distance data distribution - you can use replication to create a local copy ... Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as ...
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
A new empty binary log file is created so that binary logging can be restarted. Issuing RESET MASTER without the optional TO clause deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse To create the initial TLS context, the server uses the values that the context-related system variables have at startup. To suppress the error message, and to establish the ...
https://dev.mysql.com/doc/refman/8.0/en/savepoint.html
A new savepoint level is created when a stored function is invoked or a trigger is activated. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored. SAVEPOINT identifier ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. The MySQL server uses an internal API that is accessed during DDL operations to create and maintain SDI records. In addition to ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...