Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-shell.html
For example to connect to the instance ds1.example.com on the default X Protocol port of 33060 use the network string user@ds1.example.com:33060. If MySQL Shell is not already running, open a terminal window and issue: mysqlsh ... This quick-start ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-shell.html
For example to connect to the instance ds1.example.com on the default X Protocol port of 33060 use the network string user@ds1.example.com:33060. If MySQL Shell is not already running, open a terminal window and issue: mysqlsh ... This quick-start ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. The accounts table has these indexes: Primary key on (USER, HOST) . The ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
Setting a session value limits the effect of the change to your current session and does not affect other users. Changing a global-only variable (key_buffer_size, myisam_max_sort_file_size) affects other users as well. For key_buffer_size, you must ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. The function is intended to be invoked by the stored procedure, not directly by ...Note The rules table is loaded into the plugin by the flush_rewrite_rules stored ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
For example: $> bin/mysqld_safe --user=mysql & If mysqld_safe fails, see Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”. After the data directory is initialized and you have started the server, perform some simple tests ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training.html
@census_model is the session variable previously set that defines the model handle to the name defined by the user: census_test. mysql> SELECT model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG; ... Run the ML_TRAIN routine on a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. Online operations are noncopying; that is, they do ...
https://dev.mysql.com/doc/connectors/en/connector-python-connection-pooling.html
The size of a connection pool is configurable at pool creation time. To create a connection pool implicitly: Open a connection and specify one or more pool-related arguments (pool_name, pool_size). For example: dbconfig = { "database": "test", ...