Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. Here is a simple example that shows data-conversion warnings for INSERT. With strict mode enabled, the ...
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
write Handler_write ASYNC COUNTER The number of requests to insert a row in a table. rows_deleted Innodb_rows_deleted ASYNC COUNTER The number of rows inserted into InnoDB tables. system_rows_inserted Innodb_system_rows_inserted ASYNC COUNTER Number ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics mysql.mle Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/9.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. Inserts for v2 are checked against its LOCAL check option, then the check recurses to v1 and ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-rest-api-reference.html
Example 200 response data: { "numberOfEntries": 12, "numberOfTemporaryEntries": 1, "cache": { "hits": 100, "misses": 25, "inserts": 20, "evictions": 3, "expiredPurges": 5 } } GET /host_cache/entries Get host_cache LRU entries and in-flight ...For ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/c-api/9.7/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. Note mysql_real_escape_string() fails and produces an ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-audit-plugins.html
Applicable Events Event Data Format MYSQL_AUDIT_COMMAND_START MYSQL_AUDIT_COMMAND_END command_id="id_value" MYSQL_AUDIT_GLOBAL_VARIABLE_GET MYSQL_AUDIT_GLOBAL_VARIABLE_SET name="var_value" value="var_value" MYSQL_AUDIT_QUERY_NESTED_START ... This ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-0-0.html
This has been done for the following reasons: Ignoring such errors sometimes led to insertion of NULL into non-nullable columns (for untransformed subqueries), or of no row at all (subqueries using subquery_to_derived). Following an upgrade to this ...It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-6-0.html
(Bug #110485, Bug #35221441) Fixed an issue related to bulk inserts. You can explicitly specify allowed DML operations (INSERT, UPDATE, DELETE) per table when defining a JSON duality view. Restrictive tags (NO INSERT, NO UPDATE, NO DELETE) are also ... Note These release notes were created with the assistance of MySQL HeatWave ...