Search Results
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
This section describes how to install or uninstall the ddl_rewriter plugin. For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”. Note If installed, the ddl_rewriter plugin involves some ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-client.html
To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with -DWITH_DEBUG=1. Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export ...
https://dev.mysql.com/doc/refman/8.4/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...
https://dev.mysql.com/doc/refman/8.4/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to you.
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named function_name. (DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. The log file group must already exist or an error results. (For information on creating log file groups, see Section 15.1.16, ...