PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-limitations.html
As with SQL stored routines, JavaScript stored routines with a variable number of arguments are not supported; each argument and its type must be specified at creation time. MySQL JavaScript stored programs are subject to the limitations and ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-management.html
The syntax of the routine body is checked at creation time; any errors cause the CREATE statement to be rejected, and the stored program not to be created. The program body must be demarcated using the AS keyword plus dollar-quoted delimiters such ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html
getExecutionTime(): Retrieves the time spent executing this query, to the nearest whole second. An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods supported by ...
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
You can also use the UNTIL clause for debugging replication by processing transactions one at a time or in sections. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server-troubleshooting.html
(The default MySQL port number is 3306.) Then press Enter a couple of times. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.4, “Troubleshooting a ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server.html
(For Windows, see Section 2.3.3.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.9.3, “Testing the Server”. This section ...
https://dev.mysql.com/doc/refman/9.7/en/stop-replica.html
You can control how long STOP REPLICA waits before timing out by setting the system variable rpl_stop_replica_timeout. When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP REPLICA instruction ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. Certain optimizations are applicable to comparisons that use the IN (or ...