Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-restrictions.html
If you save event information in another table, you should not assume that the original events remain available later. For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. Monitoring occurs only for those ...
https://dev.mysql.com/doc/refman/9.7/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. This restriction is due to the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. Overview of ...
https://dev.mysql.com/doc/refman/9.7/en/select-into.html
SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these restrictions: The number of variables must match the number of columns in the table. If the table contains more than one row, ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Table 27.3 Type Conversion: JavaScript Dates to MySQL JavaScript TypeMySQL DATEMySQL DATETIME, TIMESTAMPMySQL YEARnull or undefined NULL NULL NULL Date Retain value as is, rounding off any time part to the closest second. Most MySQL data types are ...
https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The string data types are CHAR, VARCHAR, BINARY, ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json-run.html
If you specify none of the collection, table, or tableColumn options, the utility defaults to using or creating a target collection with the name of the supplied import file (without the file extension). tableColumn: "column_name" The name of the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities.html
importJSON() A JSON import utility that enables you to import JSON documents to a MySQL Server collection or table. importTable() A parallel table import utility that splits up a single data file and uses multiple threads to load the chunks into a ...To access the utilities from within MySQL Shell, use the util global object, which is available in JavaScript and Python modes, but not SQL ...