Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
A sink may also write to the Performance Schema error_log table; see Section 29.12.22.2, “The error_log Table”. For a sink component, whether it supports an interface to the Performance Schema error_log table. Provides a parser for reading error ... This section describes the characteristics of individual error log ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-general.html
All NDB tables being replicated must be created using a MySQL server and client. Tables and other database objects created using the NDB API (with, for example, Dictionary::createTable()) are not visible to a MySQL server and so are not replicated.
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... In particular, INSERT or UPDATE statements ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The server also sends a CREATE TABLE statement for the table to mysqldump, which ...The output can be saved in a file and reloaded later using mysql to recreate the dumped ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
Example The following example demonstrates how to create and populate a table using mysql_stmt_init(), mysql_stmt_prepare(), mysql_stmt_param_count(), mysql_stmt_bind_named_param(), mysql_stmt_execute(), and mysql_stmt_affected_rows(). Metadata ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-store-overview.html
Then, it segments the parsed data, creates vector embeddings, and stores them for GenAI to perform semantic searches. About Vector Processing To create vector embeddings, GenAI uses in-database embedding models, which are encoders that converts ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-cloud.html
Only single-file backups can be created on and restored from a cloud storage. GCP object storage A cloud backup is created using the cloud options for mysqlbackup, which are described in details in Section 20.15, “Cloud Storage Options”. Here ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
You can set up a new connection or select a previously created stored connection. It has a section for each object type present in the schema that you can import (tables, views, routines, and so forth). Note Importing 250 or more objects could fail ... To reverse-engineer a live database, click Database and then Reverse Engineer from the ...