PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
Matching performed by the LIKE clause is dependent on the setting of the lower_case_table_names system variable. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database.
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
As a source of data for experimentation: To make a copy of a database that you can use without changing the original data. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation . Table 2.4 Default MySQL Installation Layout for Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs.html
Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. For example, assuming that the data directory is located under ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
fq_name is a fully qualified database object name in database/schema/name format, such as test/def/t1 or sys/def/10/b$unique. The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. Results for queries that refer to tables in the performance_schema database are not saved in the query cache. The Performance Schema avoids ...
https://dev.mysql.com/doc/refman/5.7/en/channels-naming-conventions.html
Because channel names are used in replication metadata repositories, the character set used for these is always UTF-8. Although you are generally free to use any name for channels, the following names are reserved: group_replication_applier ... This ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that ...