Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
DATE DATE TIME TIME TIMESTAMP DATETIME INTERVAL TIME BYTEA LONGBLOB TEXT LONGTEXT CIDR VARCHAR(43) INET VARCHAR(43) MACADDR VARCHAR(17) UUID VARCHAR(36) XML LONGTEXT JSON LONGTEXT TSVECTOR LONGTEXT TSQUERY LONGTEXT ARRAY LONGTEXT POINT POINT LINE ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-rowactivity-category.html
Table 6.15 InnoDB Row Activity Metrics NameDescriptionRow Queries Inside The number of queries executing inside InnoDB. Rows Deleted Per Sec (Delta) The number of rows deleted per second by InnoDB. Rows Inserted Per Sec (Delta) The number of rows ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
The document ID is a VARBINARY() with a maximum length of 32 characters. // using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); ... This section describes what a document ID is and how to work with ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
The document ID is a VARBINARY() with a maximum length of 32 characters. // using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); ... This section describes what a document ID is and how to work with ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
If the condition is not met, it sleeps for 0.1 second and retries. This is much better than the 'sleep' method, but could still waste a little time. Like 'sleep', this method can also be used, when all but one thread reach a blocked state. If you ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Figure 1.23 Status And System Variables: Custom SQL Editor Views Additional viewing options were added for executed statements: Result Grid Available previously, and it remains the default view. This section summarizes many of the new features ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...
https://dev.mysql.com/doc/refman/8.4/en/arithmetic-functions.html
* Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT 18014398509481984*18014398509481984.0; -> 324518553658426726783156020576256.0 mysql> SELECT 18014398509481984*18014398509481984; -> out-of-range error The last expression produces an error ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
To install the server-side auth_socket plugin: Add these options under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf): plugin-load-add=auth_socket.so auth_socket=FORCE_PLUS_PERMANENT plugin-load-add=auth_socket.so Loads the ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the account row from the mysql.user ...