Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/setting-the-current-schema.html
var mysqlx = require('mysqlx'); // Direct connect with no client-side default schema specified var mySession = mysqlx.getSession('user:password@localhost'); mySession.setCurrentSchema("test"); Notice that setCurrentSchema() does not change the ... A ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-objects.html
Documents of the same type (for example users, products) are grouped together and stored in the database as collections.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/setting-the-current-schema.html
from mysqlsh import mysqlx # Direct connect with no client-side default schema specified mySession = mysqlx.get_session('user:password@localhost') mySession.set_current_schema("test") Notice that setCurrentSchema() does not change the session's ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
The network is disabled and user operations cannot be offloaded to RAPID. Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last started. The counter is reset to 0 when the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
When a MySQL HeatWave Cluster is enabled, queries that meet certain prerequisites are automatically offloaded from the DB System to the MySQL HeatWave Cluster for accelerated processing. Queries are issued from a MySQL client or application that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query performance. MySQL HeatWave supports two string column encoding types: variable-length and dictionary. MySQL HeatWave applies ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
If a target schema is not specified, Advisor analyzes all user defined schemas. Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...