Search Results
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error. The following statements cause that error because the named condition is associated with a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. If it is ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
When the source is using the row-based binary logging format, you should execute STOP REPLICA or STOP REPLICA SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
MySQL recognizes the escape sequences shown in Table 11.1, “Special Character Escape Sequences”. For the escape sequences that represent each of these characters, see Table 11.1, “Special Character Escape Sequences”. As an alternative to ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...The recommended way to do this is to symlink entire database directories to a different ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. For additional information, see the description of the Performance Schema threads table at Section ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
Alternatively, add the bin directory to your PATH environment variable setting. For more information about mysql, mysqladmin, and mysqlshow, see Section 6.5.1, “mysql — The MySQL Command-Line Client”, Section 6.5.2, “mysqladmin — A MySQL ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. With --tab, mysqldump produces two output files for each dumped table. The server ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This means that the same XA transaction can appear in the events_transactions_current ... XA transaction support is limited to the InnoDB storage ...