PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-overview.html
The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. It is not practical to list all the ...
https://dev.mysql.com/doc/refman/5.7/en/recovery-from-backups.html
| mysql For more information about using mysqlbinlog to process binary log files, see Section 7.5, “Point-in-Time (Incremental) Recovery”. Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 a.m. To recover, first we ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. If the automatic_sp_privileges system variable is 0, the EXECUTE ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-options.html
To specify an option file for a C program, use the --defaults-file option as one of the elements of the second argument of the mysql_library_init() function. Any options that may be given with the mysqld server daemon, may be used with an embedded ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
If any views named in the argument list do not exist, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all views in the list that do exist. To avoid this failure scenario, use IF EXISTS ...Note In MySQL 8.0, DROP VIEW fails if any views named in the argument list do not ...
https://dev.mysql.com/doc/refman/5.7/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. For frequently executed events, it is possible for this to result in many logged messages. INTO var_list ...See ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate-node.html
The disk_write_speed_aggregate_node table provides aggregated information per node about the speed of disk writes during LCP, backup, and restore operations.
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
INNODB_LOCKS: Each transaction in InnoDB that is waiting for another transaction to release a lock (INNODB_TRX.TRX_STATE is LOCK WAIT) is blocked by exactly one blocking lock request. That blocking lock request is for a row or table lock held by ...