Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-compressed-connections-8020.html
For X Protocol connections and classic MySQL protocol connections, whenever you create a session object to manage a connection to a MySQL Server instance, you can specify whether compression is required, preferred, or disabled for that connection.
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-using-a-recommendation-model-similar-items.html
For known items, the output includes a list of predicted items that have similar ratings and are appreciated by similar users. You have the option to include item and user metadata when generating predictions. For the option to set the user name, ...
https://dev.mysql.com/doc/x-devapi-userguide/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/refman/9.7/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Contact your administrator to find out what connection parameters you should use to connect (that is, what host, user name, ...If the server runs on a machine other than the one where you log in, you must also specify a host ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. The first step of the example shows how to limit collection of ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-info-table.html
This includes option files not covered by EXPLICIT, EXTRA, LOGIN, PERSISTED, SERVER, or USER. LOGIN The variable was set from a user-specific login path file (~/.mylogin.cnf). USER The variable was set from a user-specific ~/.my.cnf option file.
https://dev.mysql.com/doc/refman/9.7/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-application-log-introduction.html
The location of the MySQL Shell application log file is the user configuration path and the file is named mysqlsh.log. For example: C:>echo %APPDATA% C:\Users\exampleuser\AppData\Roaming On Windows, the path is the %APPDATA% folder specific to the ...By default, MySQL Shell sends logging information at logging level 5 (error, warning, and informational messages) to this ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-model-load.html
A model remains loaded until the model is unloaded using the ML_MODEL_UNLOAD routine Use ML_MODEL_ACTIVE to check which models are active for which users. All active users and models share the amount of memory defined by the shape, and it might be ... The ML_MODEL_LOAD routine loads a model from the model ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...