Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-read_ahead.html
You can set the value of this parameter in the MySQL configuration file, or change it dynamically with the SET GLOBAL statement, which requires privileges sufficient to set global system variables. To enable this feature, set the configuration ... A ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-prompt-themes.html
In this example, the host is included in the environment variable PRODUCTION_SERVERS. "variables" : { "is_production": { "match" : { "pattern": "*;%host%;*", "value": ";%env:PRODUCTION_SERVERS%;" }, The background and foreground colors are defined ...To customize the prompt theme file, either set the MYSQLSH_PROMPT_THEME environment variable to a prompt theme file name, or copy a prompt theme file to the ~/.mysqlsh/ directory on Linux and macOS, or the %AppData%\Roaming\MySQL\mysqlsh\ directory on ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Both INSERT statements are stored in the variables called add_employee and add_salary. Next, we insert the new salary for the new employee, using the emp_no variable in the dictionary holding the data. Inserting or updating data is also done using ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Both INSERT statements are stored in the variables called add_employee and add_salary. Next, we insert the new salary for the new employee, using the emp_no variable in the dictionary holding the data. Inserting or updating data is also done using ...
https://dev.mysql.com/doc/internals/en/event-content-writing-conventions.html
A variable-length string may be preceded by a length field that indicates the length of the string. If there is a variable-length string at the end of an event and no length field precedes it, its length may be determined as the event length minus ... Event contents are written using these conventions: Numbers are written in little-endian format (least significant byte first), unless otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-limitations.html
A JavaScript variable, local or global, defined in one stored program is not accessible from any other connection executing the same program. As with SQL stored routines, JavaScript stored routines with a variable number of arguments are not ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-bind-named-param.html
To store both named and unnamed bind user variables, call mysql_stmt_bind_named_param() after mysql_stmt_prepare(). Subsequent to binding the variables, you can set and change them repeatedly. bool mysql_stmt_bind_named_param(MYSQL_STMT *stmt, ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/test-protocol-trace-plugin.html
Control the plugin using these environment variables: MYSQL_TEST_TRACE_DEBUG: Set this variable to a value other than 0 to cause the test plugin to produce diagnostic output on stderr. MYSQL_TEST_TRACE_CRASH: Set this variable to a value other than ... MySQL includes a test protocol trace plugin that serves to illustrate the information available from such plugins, and as a guide to writing other protocol trace ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
To define your natural-language query, set the @query variable: SET @query="AddYourQuery"; Replace AddYourQuery with your natural-language query. To define your natural-language query, set the @query variable: SET @query="AddYourQuery"; Replace ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
For example: mysql> SELECT COUNT(*) FROM LINEITEM_PART1; rapid_auto_create_materialized_view Variable MySQL 9.6.0 introduces the rapid_auto_create_materialized_view variable. When enabled, the MySQL HeatWave optimizer tries to automatically create ... This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL ...