Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-datetime-fractional.html
For fractional second handling in MySQL 5.6.4 and higher, see Fractional Seconds in Time Values. In your C# or Visual Basic code, refer to the Millisecond member to retrieve the fractional second value from the MySqlDateTime object returned by the ... MySQL Connector/NET supports the fractional seconds feature in MySQL, where the fractional seconds part of temporal values is preserved in data stored and retrieved through ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete rs.Open "SELECT * FROM my_ado" rs.MoveNext rs.MoveNext rs.Delete rs.Close 'fetch the updated table .. The following ADO (ActiveX Data ...
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
If a target schema is not specified, Advisor analyzes all schemas in the MySQL HeatWave Cluster. For the most accurate recommendations, specify one schema at a time. query_insights: Provides runtime information for successfully executed queries and ...Produces summarized output and sends it to stdout and to the heatwave_autopilot_report ...
https://dev.mysql.com/doc/refman/8.4/en/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. The IGNORE modifier causes MySQL to ignore ignorable errors during the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. Statistics are collected again the next time the table is accessed. This column is reset each time table statistics are recalculated AUTOINC The ... The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
To dig deeper into performance considerations for compressed tables, you can monitor compression performance at runtime using the Information Schema tables described in Example 17.1, “Using the Compression Information Schema Tables”. This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any internal ...To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The following sections describe the Performance Schema tables associated with the thread pool ...They provide information about thread pool operation: tp_connections: Information about thread pool ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO. Suitable values are SOURCE_RETRY_COUNT=3 and ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...