https://dev.mysql.com/c-api-prepared-statements.html
Then it is executed one or more times at a later time, using the statement handler returned by the initialization function. In the case of direct execution, the query is parsed every time it is executed. The MySQL client/server protocol provides ...
https://dev.mysql.com/cast-functions.html
Table 12.14 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...
https://dev.mysql.com/clone-plugin-replication.html
To initiate replication, the binary logs required for the recipient to catch up to the donor must not be purged between the time that the data is cloned and the time that replication is started. A cloned instance should therefore be added to a ...In ...
https://dev.mysql.com/converting-tables-to-innodb.html
The time when autocommit=1 is suitable for InnoDB tables is when running a sequence of queries for generating reports or analyzing statistics. If deadlock detection is disabled using the innodb_deadlock_detect configuration option, InnoDB relies on ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/delete.html
To ensure that a given DELETE statement does not take too much time, the MySQL-specific LIMIT row_count clause for DELETE specifies the maximum number of rows to be deleted. For example, the following statement finds rows matching the WHERE clause, ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/error-log-format.html
It writes messages using this format: timestamp thread_id [priority] [err_code] [subsystem] message The [ and ] square bracket characters are literal characters in the message format. For example: { "prio": 3, "err_code": 10051, "subsystem": ...
https://dev.mysql.com/error-summary-tables.html
Each error summary table has these summary columns containing aggregated values: SUM_ERROR_RAISED This column aggregates the number of times the error occurred. SUM_ERROR_HANDLED This column aggregates the number of times the error was handled by an ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/explain-output.html
The content of the derived table is rematerialized to bring it up to date each time a new row of t is processed by the top query. This eliminates the need to send nonmatching rows over the network, and can speed up such queries by a factor of 5 to ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/files-table.html
For NDB: The date and time when the file was created. For NDB: The date and time when the file was last modified. For NDB: The date and time when the file was last accessed by the server. The CREATION_TIME, LAST_UPDATE_TIME, and LAST_ACCESSED values ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/group-by-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Multiple ...
