Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Where practical, wrap several related data change operations into a single transaction, by issuing SET AUTOCOMMIT=0 or a START TRANSACTION statement, followed by a COMMIT statement after making all the changes. Avoid performing rollbacks after ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. When a new row is inserted into a partitioned table, it is these ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
As an alternative to explicitly escaping special characters, many MySQL APIs provide a placeholder capability that enables you to insert special markers into a statement string, and then bind data values to them when you issue the statement. A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-index-statistics.html
insert_latency The total wait time of timed inserts into the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-28.html
(Bug #33461744) Running a PreparedStatement in the form of INSERT INTO ... With this fix, the object is encoded correctly into a DATE value. It was because Connector/J did not recognize VALUE as an alias for VALUES in an INSERT statement, and ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
Code First Features Following are new Code First features supported by Connector/NET: Code First Mapping to Insert/Update/Delete Stored Procedures supported: modelBuilder.Entity<EntityType>().MapToStoredProcedures(); Idempotent migrations scripts ...