Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. When measuring backup performance, consider: The limits imposed by your ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-getschema.html
The following are the collections currently provided by Connector/NET, in addition to the common collections shown previously: Databases Tables Columns Users Foreign Keys IndexColumns Indexes Foreign Key Columns UDF Views ViewColumns Procedure ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-getschema.html
The following are the collections currently provided by Connector/NET, in addition to the common collections shown previously: Databases Tables Columns Users Foreign Keys IndexColumns Indexes Foreign Key Columns UDF Views ViewColumns Procedure ...
https://dev.mysql.com/doc/internals/en/calling-sequence.html
You cann use the CALLTRACE() procedure to check in which sequence the member functions are called on any query. This procedure will send one result row for each member function call, every row contains a single text field with one of the values add, ... The init callback is always called first at the beginning of a query, followed by a call to the Section 18.1.2, ...
https://dev.mysql.com/doc/internals/en/optimizer-order-by-clauses.html
In general, the optimizer will skip the sort procedure for the ORDER BY clause if it sees that the rows will be in order anyway. ORDER BY Optimization, provides a description of the internal sort procedure which we will not repeat here, but urge ...
https://dev.mysql.com/doc/internals/en/transformations-singlerow.html
But every Item_field and Item_ref of that expression will be marked for processing by a special fix_fields() procedure. The fix_fields() procedures for such Items will be performed in the same way as for items of an inner subquery.
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #90862, Bug #28020811) Cursors (both the pure Python and C extension versions) use a single SELECT to retrieve procedure result parameters following a procedure call, but one SET was used per parameter when setting the input parameters.
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The following procedures assume that mysql clients are available on remote client hosts. The procedures also assume that you have distributed client certificate and key files to the remote clients as described in Distributing Client Certificate and ...The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted ...