Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
This technique avoids duplicating database code, saving time and effort when you make updates due to schema changes, tune the performance of queries, or add new database operations for logging, security, and so on. Putting database-intensive ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
By logging only those columns required for uniquely identifying and executing changes on each row (as opposed to all columns) for each row change, it is possible to save disk space, network resources, and memory usage. If the position from which the ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. How the Clustered Index Speeds Up Queries Accessing ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the cache. However, restructuring does not block queries that need to use indexes assigned to the cache. File system caching is not as efficient ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. In this case, you must provide code in your application to pack and unpack information, ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. Query results can be saved in tables for further analysis, or ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...