Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes.html
This program illustrates how to use secondary indexes in the NDB API. The source code for this example may be found in the NDB Cluster source tree, in storage/ndb/ndbapi-examples/ndbapi_simple_index/main.cpp.
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-mynode.html
To create an instance, use the Node.js require() function with the driver name, like this: var nosql = require("mysql-js"); ConnectionProperties can be used to retrieve or set the connection properties for a given session. You can get the mapping ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-faq.html
For example, if User1 is defined as a dba in MySQL Enterprise Monitor 3.0.x, User1 is created in MySQL Enterprise Monitor 3.1, but assigned to the dba Role. C.6: Why does the file apache-tomcat/logs/tomcat.log show error messages saying This is very ... Note MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-progress-tracking.html
For example: mysql> CALL sys.ML_PREDICT_TABLE('census_data.census_train', @census_model, 'census_data.census_train_predictions', NULL); While the routine runs, use the second MySQL Client session and create a session variable for QEXEC_TEXT. Before ... You can monitor the progress of MySQL HeatWave AutoML routines through Performance Schema queries made from a second MySQL Client ...
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 ...