Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
For example, consider the following stored routine: CREATE PROCEDURE test_routine() BEGIN SELECT name FROM TestTable ORDER BY name; SELECT COUNT(name) FROM TestTable; END This routine actually needs to be executed on the MySQL Server as a single ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful on a database server), you can mount your file systems with the -o noatime option. The ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To avoid this interval when a direct query to the replica could return stale data, you can set the init_file system variable to name a file containing statements that populate the MEMORY table on the source at startup. (The method just described is ... When a replication source server shuts down and restarts, its MEMORY tables become ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
model_handle: Specifies the model handle or a session variable containing the model handle. Syntax Examples A typical usage example that specifies the fully qualified name of the table to generate predictions for, the session variable containing the ... ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data and saves the results to an output ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. | wait/synch/mutex/sql/LOCK_global_read_lock | YES | YES | | wait/synch/mutex/sql/LOCK_global_system_variables | YES | YES | | ...
https://dev.mysql.com/doc/refman/8.4/en/shutdown.html
Because status variables are initialized for each server startup and do not persist across restarts, Com_shutdown normally has a value of zero, but can be nonzero if SHUTDOWN statements were executed but failed. Another way to stop the server is to ...SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown ...
https://dev.mysql.com/doc/refman/8.4/en/components.html
System and status variables implemented by a component are exposed when the component is installed and have names that begin with a component-specific prefix. For example, the log_filter_dragnet error log filter component implements a system ...See ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-8.html
(Bug #38417986) Configuration Notes The mysqlx_port server variable was not persisted in the my.ini file when set through the Type and Networking configuration page. (Bug #118705, Bug #38310595) Running SET PERSIST on a system variable after an ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting-mysql-client.html
Connecting with MySQL Command-Line Client 5.2.2 Connecting with MySQL Command-Line Client This topic describes how to connect to a MySQL DB System using a MySQL Command-Line Client. Prerequisites: A machine or compute instance with internet ...A ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting-mysql-shell.html
Connecting with MySQL Shell 5.2.1 Connecting with MySQL Shell This topic describes how to connect to a MySQL DB System using MySQL Shell. Prerequisites: A machine or compute instance with internet connectivity for connecting to the MySQL DB System.