Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Storage engines are MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. 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 objects can be used for typical tuning and diagnosis use ...
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
This is an OUT parameter, so it must be a variable into which the table type can be stored. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
The following discussion further subdivides the set of system tables into smaller categories. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
The DATA DIRECTORY location will be ignored and the file will be put into the default datadir location. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To ...
https://dev.mysql.com/doc/refman/8.4/en/union.html
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple ...
https://dev.mysql.com/doc/refman/8.4/en/using-stack-trace.html
On glibc-based systems (Linux), the trace for an unexpected exit within a plugin looks something like: plugin/auth/auth_test_plugin.so(+0x9a6)[0x7ff4d11c29a6] To translate the relative address (+0x9a6) into a file name and line number, use this ...