Search Results
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
(By default mounting is done without this option.) Failing to do so causes a significant drop in performance when using the InnoDB storage engine on this platform. Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
If this is not desired, you can drop the sys schema manually after initialization if it is unneeded. MySQL 8.4 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
If a TEMPORARY is created with the same name as an existing non-TEMPORARY table, the non-TEMPORARY table is hidden until the TEMPORARY table is dropped, even if the tables use different storage engines. Temporary tables created with CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/views.html
The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Views are stored queries that when invoked produce a result set. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not be defined or dropped explicitly. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
Now all operations that involve using the invalid index are rejected with ER_INDEX_CORRUPT until the index is dropped. It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
(Bug #37602657) If the row size exceeded the maximum allowed size due to innodb_strict_mode=OFF, confusing warning messages similar to "Cannot add field" could appear in certain situations, such as selecting from a table or dropping a column. Audit ...