Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-prepare.html
Preparing Data To prepare the data for topic modeling: Connect to the MySQL Server. mysql> CREATE DATABASE topic_modeling_data; mysql> USE topic_modeling_data; Create the table to use for both training and testing. mysql> CREATE TABLE movies ( ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...The table shows the C variable types that you can use, the corresponding type codes, and the SQL data types for which the supplied value can be used without ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The InnoDB INFORMATION_SCHEMA table interface allows you to query this data using SQL. The data in this table is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. mysql> INSERT INTO t1 VALUES(5, 'abc', ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
To view undo tablespace names and paths, query INFORMATION_SCHEMA.FILES: SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; A MySQL instance supports up to 127 undo tablespaces including the two default ...Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be ... Undo tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
On the source server, the output from SHOW PROCESSLIST looks like this: mysql> SHOW PROCESSLIST\G *************************** 1. On a replica server, the output from SHOW PROCESSLIST looks like this: mysql> SHOW PROCESSLIST\G ...For replica states, ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
Caution Passwords or other sensitive values supplied as arguments to encryption functions are sent as cleartext to the MySQL server unless an SSL connection is used. The derived key is used to encrypt and decrypt the data, and it remains in the ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that represent EOF. An OK packet is sent from the server to the client to signal successful completion of ...07 00 00 02 00 00 00 02 00 00 00 ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-33.html
If the libmysql client library or MySQL Server version being used lack support for query attributes, then returning related connection-attribute errors is not possible. (WL #15481) Functionality Added or Changed The Connector/C++ legacy JDBC ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
If validate_password rejects the new password, it reports an error indicating the minimum number of characters that must differ. If the file is named as a relative path, it is interpreted relative to the server data directory. This section ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
To use the functions to read the audit log, follow these principles: Call audit_log_read() to read events beginning from a given position or the current position, or to close reading: To initialize an audit log read sequence, pass an argument that ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it ...