PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-collections.html
Simple document format for JavaScript: {field1: "value", field2 : 10, "field 3": null} An array of documents consists of a set of documents separated by commas and enclosed within [ and ] characters. When you are using MySQL as a Document Store, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. The accounts table contains a row for each account that has connected to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-atom-molecule-events.html
For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile 10001 10002 2 wait/io/table/sql/handler 10000 NULL The row fetch causes a file read. In ... For a table I/O event, there are usually two rows in events_waits_current, not ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress table shows progress information for the current or last executed cloning operation only. The stages of a cloning operation include DROP DATA, FILE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
LOCKED_BY_THREAD_ID When a thread currently has a mutex locked, LOCKED_BY_THREAD_ID is the THREAD_ID of the locking thread, otherwise it is NULL. When a thread unlocks a mutex, mutex_instances shows that the mutex now has no owner (the THREAD_ID ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
FROM performance_schema.events_transactions_current AS parent INNER JOIN performance_schema.data_locks AS child WHERE parent.THREAD_ID = child.THREAD_ID AND parent.EVENT_ID < child.EVENT_ID AND ( child.EVENT_ID <= parent.END_EVENT_ID OR ...Rows of ...