PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Each row in this table corresponds to a table being replicated, determines how to log changes to the table and, if a conflict resolution function is specified, and determines how to resolve conflicts for that table. conflict_fn column The conflict ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 23.1, “Defining Stored ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html
The auto-positioning function for synchronizing a replica and source that use GTIDs (see Section 16.1.3.3, “GTID Auto-Positioning”). Stored functions that you can use to work with GTIDs (see Section 16.1.3.7, “Stored Function Examples 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 ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Handler_external_lock The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance. Also, the count does not include files that storage engines open ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section 13.7.5.19, “SHOW FUNCTION CODE Statement”). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or literals. Warnings cannot be returned ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. Stored routines also enable you to have libraries of functions in the database server. Additional Resources You may find the Stored Procedures User Forum of use when ...A stored routine is a set of SQL statements that can be stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
See the description of the LIKE operator in Section 12.8.1, “String Comparison Functions and Operators”. You can do this in two ways: Process the string with a function that escapes the special characters. In a C program, you can use the ... A ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” functions. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...