Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
open_streams Open_streams ASYNC COUNTER The number of streams that are open, used mainly for logging open_table_definitions Open_table_definitions ASYNC GAUGE COUNTER The number of cached table definitions open_tables Open_tables ASYNC GAUGE COUNTER ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
There are various ways to create different kinds of partial backup with MySQL Enterprise Backup: Including or excluding specific tables by their names. Each table is checked against the regular expression specified with the --include-tables or ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. The SELECT statement can use a VALUES statement as its source, or can be replaced with a TABLE statement, ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-how-to-import-onnx.html
Import model as a string: For smaller models, you can copy the encoded string and paste it into a session variable or temporary table column. Import model directly from a table: For larger models, you can load the entire file into a table with the ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
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 privileges. They are actually views, not base tables, so there are no files ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
See Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. In ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...