Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Uninstalling Loadable Functions To remove a loadable function, ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Note If the --auto-generate-sql option is also given, mysqlslap drops the schema at the end of the test run. --no-drop Command-Line Format --no-drop Type Boolean Default Value FALSE Prevent mysqlslap from dropping any schema it creates during the ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
(See Section 2.3.16, “The NdbEventOperation Class”.) dropEventOperation() Drops a subscription to a database event. Ndb::dropEventOperation() Description This method drops a subscription to a database event represented by an NdbEventOperation ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
When a database is dropped, all stored routines associated with it are dropped as well. Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
YourSQL','When comparing databases ...'), -> ('MySQL Security','When configured properly, MySQL ...'), -> ('Database, Database, Database','database database database'), -> ('1001 MySQL Tricks','1. | 0.36289870738983154 | | 1 | MySQL Tutorial | This ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
Dropped Fabric support in MySQL Workbench 6.3.9; support in older versions of MySQL Workbench is unchanged. Package and Build Related Changes Linux: Fedora 23 support dropped, Fedora 25 support added. OS X / macOS: Version 10.7 (Lion) and 10.8 ...