PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
| +-----------------------------------------------------------------+ 1 row in set (9.17 sec) +------------------------------------------+-----------+ | event_name | latency | +------------------------------------------+-----------+ | stage/sql/init ... Traces all Performance Schema instrumentation for a specific statement ...This procedure disables binary logging during its ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits version tokens to be locked and unlocked. Interpretation of name_list and token_list arguments (including whitespace ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
Tables in the performance_schema database can be grouped according to the type of information in them: Current events, event histories and summaries, object instances, and setup (configuration) information. For example: mysql> UPDATE ...To enable or ... This section briefly introduces the Performance Schema with examples that show how to use ...row *************************** THREAD_ID: 0 EVENT_ID: 5523 END_EVENT_ID: 5523 EVENT_NAME: wait/synch/mutex/mysys/THR_LOCK::mutex SOURCE: thr_lock.c:525 TIMER_START: 201660494489586 TIMER_END: 201660494576112 TIMER_WAIT: 86526 SPINS: NULL OBJECT_SCHEMA: NULL OBJECT_NAME: NULL INDEX_NAME: NULL OBJECT_TYPE: NULL OBJECT_INSTANCE_BEGIN: 142270668 ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
MySQL represents each table by an .frm table format (definition) file in the database directory. For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
Several programs perform setup operations during MySQL installation or upgrading: comp_err This program is used during the MySQL build/installation process. mysql_install_db This program initializes the MySQL data directory, creates the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
This is a typical situation for many Web servers that generate many dynamic pages based on database content. The query cache is shared among sessions, so a result set generated by one client can be sent in response to the same query issued by ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. For view locking, LOCK TABLES adds all base tables used in the view to the set of tables to be locked and locks them automatically. Another use ...lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL Server has a practical set of features developed in close cooperation with our users. The database structures are organized into physical files optimized for speed. The database enforces these rules, so that with a well-designed database, your ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...