Search Results
https://dev.mysql.com/doc/refman/9.7/en/processlist-access.html
The sys schema session view presents information about user sessions like the sys schema processlist view, but with background processes filtered out. Privileges Required to Access the Process List For most sources of process information, if you ...
https://dev.mysql.com/doc/refman/9.7/en/set-role.html
} SET ROLE modifies the current user's effective privileges within the current session by specifying which of its granted roles are active. Granted roles include those granted explicitly to the user and those named in the mandatory_roles system ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-configuration-file-syntax.html
For example, the user option's meaning depends on its associated section. A user in the [DEFAULT] section refers to the system user that MySQL Router is run as, which is also controlled by the --user command line option. Unrelated to that is ... The ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-authentication-plugins.html
Authentication plugins enable the use of authentication methods other than the built-in method of passwords stored in the mysql.user system table. Also, authentication plugins can support the proxy user capability, such that the connecting user is a ... MySQL supports pluggable authentication, in which plugins are invoked to authenticate client ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-score.html
ML_SCORE Syntax mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['threshold', 'N'] ['topk', 'N'] ['remove_seen', ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
For example, this might be a file created by issuing the command mysqldump --no-data. MySQL Workbench handles the script as follows: If the script does not contain a CREATE DATABASE db_name; statement, the schema objects are copied to the initial ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
global indent indent = 0 # MySQL Connection arguments config = { "host": "127.0.0.1", "user": "root", "password": os.environ.get("MYPASS", ":("), "use_pure": True, "port": 3306, } async def job_sleep(n): """Take a nap for n seconds. Note While ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
global indent indent = 0 # MySQL Connection arguments config = { "host": "127.0.0.1", "user": "root", "password": os.environ.get("MYPASS", ":("), "use_pure": True, "port": 3306, } async def job_sleep(n): """Take a nap for n seconds. Note While ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-instruments-table.html
Instruments with a higher volatility index (for example, SESSION = 5) are created and destroyed for every user session. When an instrument is enabled and executed, instrumented instances are created, which are visible in the xxx_instances tables, ...