Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 5.10 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...The following tables list Connector/ODBC API calls grouped by task: Table 5.5 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, statement, or descriptor ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 7.6 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...The following tables list Connector/ODBC API calls grouped by task: Table 7.1 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, statement, or descriptor ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-binarylogs-category.html
Binlog Max Flush Queue Time How long in microseconds to keep reading transactions from the flush queue before proceeding with the group commit (and syncing the log to disk, if sync_binlog is greater than 0). If the value is 0 (the default), there is ... Lists the Binary Logs configuration metrics and provides a brief description of ...Table 7.2 Binary Logs Configuration Metrics NameDescriptionBinlog ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Which version of MySQL is production-ready (GA)? MySQL 9.4, 8.4, and 8.0 are actively supported for production use. It became a bugfix series as of MySQL 8.0.34 ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). Some versions of Windows have a boot time setting to ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-syntax.html
Only online topology members are considered when forming a candidate pool. routes: expressions which match incoming client sessions with appropriate destination candidates. { "destinations": [destinationDefinitions], "name": [Name of the routing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog and mysql to restore the changes that occurred after the backup was made. If all changes are flushed from the buffer pool to the tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. The string contains the decimal time rounded to ... MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Isolate and tune any part of the query, such as a function call, that takes excessive time. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster because the results are retrieved from ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-connections.html
These connections can be used in the modes where you created them, and one of them at a time can be assigned as MySQL Shell's global session so it can be used in all modes. Certain operations that open many connections to servers can take a long ...