Search Results
https://dev.mysql.com/doc/refman/8.4/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for specifying a value ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. For example, you can retrieve numeric values from a SET column like this: mysql> SELECT set_col+0 FROM tbl_name; If a number is ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/dashboard-overview-database-availability-ref.html
Unreachable: The percentage of time a monitored MySQL Instance did not respond. Within those slices, the time within each availability state is aggregated across all MySQL Instances within the selected Group, and shown as the percentage of the total ... The Database Availability statistics show an aggregate of availability statistics, generated by the MySQL Availability Advisor, for all MySQL Instances within the selected group, and allows you to monitor your ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
This section provides configuration options that affect the modeling functionality in MySQL Workbench (see the figure that follows). Force use of software based rendering for EER diagrams MySQL Workbench uses OpenGL for rendering when available. On ...These issues can be resolved by selecting the software rendering option ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-source-configuration-options.html
Otherwise, the shared MySQL client library is loaded and mapped at runtime. This option is used only if MYSQLCLIENT_STATIC_LINKING is disabled to enable dynamic linking of the MySQL client library. In that case, if MYSQLCLIENT_STATIC_BINDING is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-oem-agent-logging.html
The collection-type logs, defined by the com.mysql.etools.emplugin.collection.* properties, which are at INFO level by default, log details of availability, metrics, response times, and so on. This section describes the Oracle Enterprise Manager ...
https://dev.mysql.com/doc/x-devapi-userguide/en/database-connection-example.html
The code that is needed to connect to a MySQL document store looks a lot like the traditional MySQL connection code, but now applications can establish logical sessions to MySQL server instances running the X Plugin. Sessions are produced by the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-asset-management-delete.html
The deletable asset types are as follows: MySQL Instances MySQL Enterprise Monitor Agents Hosts NDB Clusters: Clusters can be deleted in their entirety, or you can delete individual nodes by opening the NDB Cluster details view, and deleting the ...