Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
var res = mySession.sql('SELECT name, age FROM users').execute(); var row; while (row = res.fetchOne()) { print('Name: ' + row['name'] + '\n'); print(' Age: ' + row.age + '\n'); } SqlResult differs from results returned by CRUD operations in the way ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. User-defined attributes are ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
res = mySession.sql('SELECT name, age FROM users').execute() row = res.fetch_one() while row: print('Name: %s\n' % row[0]) print(' Age: %s\n' % row.age) row = res.fetch_one() SqlResult differs from results returned by CRUD operations in the way how ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
The names for the output files are auto-generated and based on the following format: file_prefix/universal unique number/nnode_ID-tthread_ID-cChunk_ID.compression.file_format File Name Parameters File_prefix: The user-provided prefix for the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
If there is no user context, this value can be NULL. The value need not actually be a “user”; the meaning depends on the application. Functions that implement the keyring function interface pass the value of CURRENT_USER() as the user_id value ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Optimize the use of spin delay by user threads waiting for flushed redo. innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Consider the following ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...