Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-working-with-relational-tables.html
The X DevAPI SQL CRUD functions allow you to work with relational tables in manners similar to using traditional SQL statements. The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are ...
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-example-data.html
To create a copy of the entire world database on the SQL node, use mysqldump on the noncluster server to export the database to a file named world.sql (for example, in the /tmp directory). Running SELECT queries on the SQL node is no different from ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
dbSystemId Detailed mysql.stats.aborted_connects Count The number of failed attempts to connect to the MySQL server. dbSystemId Detailed mysql.stats.created.tmp_disk_tables Count The number of internal on-disk temporary tables created by the server ... CloudWatch Monitoring Metrics 17.1.1 CloudWatch Monitoring Metrics CloudWatch metrics can be used to monitor resources, diagnose issues, and troubleshoot your DB systems and their MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html
The recommendation initial setting for this system variable is the number of physical cores times 32. In addition, the value of the thread_pool_stall_limit system variable determines the handling of blocked and long-running statements. Of chief ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-nutshell.html
The default value for the binlog_transaction_dependency_history_size server system variable was increased in MySQL 9.5.0 from 25000 to 1000000 (one million). Server system and status variables removed in MySQL 9.7 are shown in the following list: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The MySQL server can be installed on a variety ', 'of operating systems, including ...Summarize Text To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to ... The following ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component.html
To use a different database, set the audit_log.database system variable at server startup. To change the name of the file, set the audit_log.file system variable at server startup. MySQL Enterprise Edition includes MySQL Enterprise Audit, ... Note ...