Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table is offloaded and loaded into the MySQL HeatWave Cluster Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ... To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES ...
https://dev.mysql.com/doc/connector-j/en/connector-j-YEAR.html
Connector/J follows the same rules that govern how values are inserted by a mysql client; see explanations in The YEAR Type for details. Treatments of zero values depend on whether they are strings or numbers, and on the value of yearIsDateType: If ... How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If yearIsDateType is true (the default), YEAR is mapped to the Java data type ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Audit log implements the dynamic_loader_services_loaded_notification service and listens for new registrations of mysql_scheduler so that audit log can register its scheduled task into the newly loaded scheduler. Audit log only registers itself into ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer perform inserts. Where possible, rows stored in the binary log are grouped into events with a size not ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. It implements the required ADO.NET interfaces ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. CREATE FUNCTION has these effects: It loads the function into the server to make it available immediately. For this reason, CREATE FUNCTION requires ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. You can filter, sort, concatenate, and transform the results ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. If the flag is on, invisible indexes remain ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
The mysql client parser does not take the ANSI_QUOTES SQL mode into account. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive History ...