Search Results
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
For example: "filesort_summary": { "rows": 100, "examined_rows": 100, "number_of_tmp_files": 0, "peak_memory_used": 25192, "sort_mode": "<sort_key, packed_additional_fields>" } peak_memory_used indicates the maximum memory used at any one time ...An ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
Note Products covered under Oracle Lifetime Sustaining Support, if installed, may appear in the dashboard. Select the MySQL products you want to remove (uninstall) and then click Execute to begin the removal process. During the operation, an ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Without the FOR QUERY n clause, the output pertains to the most recently executed statement. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
A reference to a user variable in a prepared statement has its type determined when the statement is first prepared, and retains this type each time the statement is executed thereafter. Similarly, the type of a user variable employed in a statement ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...Make the initialization function return zero for success, nonzero for an ...It enables ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. The so-called phantom problem occurs within a transaction when the same query produces different ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 ...