Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-ioglobalbywaitbylatency-category.html
Event Name The IO event name Max Latency The maximum single wait time of timed occurrences of the IO event. Table 6.36 Sys Schema IO Global By Wait By Latency Metrics NameDescriptionAverage Latency The average wait time per timed occurrence of the ... Lists the Sys Schema IO Global By Wait By Latency metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
However, the effort required for data compression also increases, taking time and CPU and memory resources on the originating server. Note You can enable binary logging of compressed transactions for tables using the NDB storage engine at run time ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...
https://dev.mysql.com/doc/internals/en/myisammrg-directory.html
As with other table handlers, you'll find that the *.c files in the myissammrg directory have counterparts in the myisam directory. In fact, this general description of a myisammrg program is almost always true: The myisammrg function checks an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is not possible. To force a query to execute on MySQL HeatWave or fail if that is not possible, set ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
This ensures that the data node can run in a stable manner without using swap memory, so that NDB can be used for latency-sensitive (realtime) applications. The reserved memory area can be used only by the resource for which it is reserved and ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-introduction.html
The size of the buffer that is allocated initially (16KB) is automatically increased up to the maximum size (16MB by default). Because buffer sizes are increased only as demand warrants, simply increasing the maximum limit does not in itself cause ... The C API provides low-level access to the MySQL client/server protocol and enables C programs to access database ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-initialization.html
Keep in mind that, before you invoke this function, all Ndb_cluster_connection objects created in your NDB API application must be cleaned up or destroyed; otherwise, threads created when an Ndb_cluster_connection object's connect() method is ...
https://dev.mysql.com/doc/connector-net/en/connector-net-faq.html
Questions 10.1: Are all commands executed after a transaction begins automatically enlisted in the transaction? 10.2: How do I obtain the value of an auto-incremented column? Questions and Answers10.1: Are all commands executed after a transaction ...When a client begins a transaction in classic MySQL, all subsequent commands (on that connection) are part of that transaction until the client commits or rolls back the ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-intro.html
This section provides a gentle introduction to programming with MySQL Connector/NET. The code example is written in C#, and is designed to work on both Microsoft .NET Framework and Mono. This tutorial is designed to get you up and running with ...