Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines.
https://dev.mysql.com/doc/internals/en/synchronization-pattern.html
It is possible that the condition variable is signaled multiple times without the wait condition to be true. If the killing thread would kill us when we are after the second test, but still before sleeping, we hold the mutex, which is registered in ...This is done to allow the thread to be interrupted (killed) from its ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has ...A ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column maximum length. If you use the IGNORE modifier, ignorable errors that occur while executing the INSERT statement are ignored. If any of the rows to be ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The second method uses RSA key pair-based password exchange over an unencrypted connection. The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted connection. The following procedures assume that mysql clients ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-to-one-of-multiple-hosts.html
You can provide multiple MySQL Router or server endpoints (as host and an optional port, or Unix sockets) when creating a session. You specify a URI-like string which contains multiple hosts, ports, and optional priority. This enables the connector ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ...Type The ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. If this value is missing, the line corresponds to the second or later column of a multiple-column key. For the ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the EER Diagram tab is selected, then right-click the table icon on the vertical toolbar. Clicking the mouse on this icon changes the mouse ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Example Statements: (Displayed only if Example Query is enabled) distribution chart of the statement by Execution Time, in milliseconds, and time and date, within the selected time range. Graphs: displays the average execution time, number of ...