Search Results
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-prepare.html
To migrate schemas and data from Microsoft SQL Server for use with MySQL, ensure the following: The source SQL Server instance is running, and accepts TCP connections. You know the IP and port of the source SQL server instance. If you will be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
mysql> SET GLOBAL innodb_ft_aux_table = 'test/articles'; Query the INNODB_FT_INDEX_CACHE table, which shows information about newly inserted rows in a FULLTEXT index. mysql> DELETE FROM test.articles WHERE id < 4; Query the INNODB_FT_DELETED table.
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
This reduces the parsing that MySQL must do and improves the insert speed. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
If an error occurs, server startup fails and the administrator must correct any issues indicated by diagnostics in the server error log. The component_keyring_file keyring component stores keyring data in a file local to the server host. To use ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of results when multiple transactions are making changes and performing ...
https://dev.mysql.com/doc/refman/8.4/en/optimization.html
Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single database server, or multiple networked database servers. This chapter explains how to ...Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release series. NDB Cluster 8.4 is ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
For SQL statements, the EVENT_NAME value initially is statement/com/Query until the statement is parsed, then changes to a more appropriate value, as described in Section 29.12.6, “Performance Schema Statement Event Tables”. To change this ...