Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
format: string The model can be in one of the following formats (MySQL 9.0.0 and later): HWMLv1.0 HWMLv2.0 ONNXv1.0 ONNXv2.0 For MySQL 8.4.0 and earlier, MySQL HeatWave AutoML models are in HWMLv1.0 format, and ONNX models are in ONNX format. The ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. MySQL provides functions for doing date arithmetic, so this is not difficult. Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet ...You want a table that contains a record for each of your ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the privilege system at runtime. The mysqladmin utility provides a command-line interface to some ...| ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not persisted when the server is shut down, and may be reused. $> cd BASEDIR/data/#innodb_temp $> ls ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. The best strategy for provisioning such a replica is therefore to use ...In a ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
Section 6.9, “Environment Variables”, lists all environment variables that affect MySQL program operation. For example, on Windows, you can set the USER variable to specify your MySQL account name. Suppose that you want to specify the TCP/IP ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. You can find the queries that take a long time to execute by starting mysqld with the slow query log enabled. Note ...If this works, you should also test all complicated queries that did not ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
Issue: mysql-py> \sql SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments WHERE NAME LIKE 'statement/%' AND NOT (ENABLED and TIMED) If this statement reports at least one row, you need to enable the instruments. We use MySQL Shell ... For general X Plugin monitoring, use the status variables that it ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.dfs-san.html
A failure occurs also if mysqlbackup reads a corrupted log block at any time during the copying of the redo log. When system administrators attempt to set up MySQL and MySQL Enterprise Backup in an environment that uses a distributed file system ...
https://dev.mysql.com/doc/connectors/en/connector-j-logging-slf4j.html
Besides its default logger com.mysql.cj.log.StandardLogger, which logs to stderr, Connector/J supports the SLF4J logging facade, allowing end users of applications using Connector/J to plug in logging frameworks of their own choices at deployment ...In the code of your application, obtain an SLF4JLogger as a Log instantiated within a MysqlConnection Session, and then use the Log instance for your ...