Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. The ndbd binary provides the single-threaded version of the process that is used to handle all the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbinfo-select-all.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not used, which can be helpful in cases such as when a range_optimizer_max_mem_size violation or type conversion occurs and the optimizer does not use an index even though a key ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' ...You can also solve the problem efficiently by using a UNION that combines the output of two separate SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you use a multiple-table UPDATE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. UPDATE is a DML ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-source-configuration-options.html
-DCMAKE_BUILD_TYPE=type The type of build to produce: Debug: Disable optimizations and generate debugging information. -DBUNDLE_DEPENDENCIES=bool This is an internal option used for creating Connector/C++ distribution packages.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Some external articles and tips that may be useful when using Access, ODBC and Connector/ODBC: Read How to Trap ODBC Login Error Messages in Access Optimizing Access ODBC Applications Optimizing for Client/Server Performance Tips for Converting ...
https://dev.mysql.com/doc/internals/en/cmake-build-types.html
The build type affects optimization and whether the result of the build is debuggable. RelWithDebInfo (optimizations are on, debug info is generated) is used in MySQL by default. Debug (optimizations are off, debug info is generated) is used if the ...CMAKE_BUILD_TYPE is not set when custom compile flags are used (see Section 4.4.6.2, “How to Specify Compilers and Compiler ...
https://dev.mysql.com/doc/internals/en/controlling-compilers-and-flags.html
For example: shell> CC=gcc shell> CXX=g++ shell> export CC CXX To specify your own C and C++ compiler flags, for flags that do not affect optimization, use the CMAKE_C_FLAGS and CMAKE_CXX_FLAGS CMake options: cmake .. -DCMAKE_C_FLAGS=-m32 \ ... To ...