Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
mysql> CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on opening_lines(FTS_DOC_ID); If you do not create the FTS_DOC_ID_INDEX, InnoDB creates it automatically. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up ...A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1); SELECT LAST_INSERT_ID(); The SELECT ... If ...InnoDB supports two types of locking reads that offer extra safety: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-views.html
SQL statements are truncated to a maximum display width using format_statement(). The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-usage.html
The limitations discussed in this section occur by intention or design in MySQL Cluster Manager 8.4.6. It cannot be used for changing a cluster node's type (for example, you cannot change a data node to an SQL node, management node, or NDB API ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-replicationreplica-activity-category.html
Running This is ON if this server is a replication replica that is connected to a replication source, and both the I/O and SQL threads are running; otherwise, it is OFF. Replica Error: Unknown or Incorrect Time Zone In order to use time zone names ...Exec Source Log Pos The position in the current source binary file up to which the SQL thread has read and ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-libraries.html
Note This section may be skipped when using a MySQL Workbench binary that is provided by Oracle. Linux iODBC: MySQL Workbench binaries provided by Oracle already include iODBC and no additional action is required. pyodbc: is the Python module used ...If you compile it yourself, you must install iODBC or ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows.html
To add or configure a Connector/ODBC 5.x or 8.x DSN on Windows, use either the ODBC Data Source Administrator GUI, or the command-line tool myodbc-installer.exe that comes with Connector/ODBC.
https://dev.mysql.com/doc/connectors/en/connector-python-installation.html
Make sure Python is installed on your platform: Python comes preinstalled on most Unix and Unix-like systems, such as Linux, macOS, and FreeBSD. If your system does not have Python preinstalled for some reasons, use its software management system to ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows.html
To add or configure a Connector/ODBC 5.x or 8.x DSN on Windows, use either the ODBC Data Source Administrator GUI, or the command-line tool myodbc-installer.exe that comes with Connector/ODBC.
https://dev.mysql.com/doc/connector-python/en/connector-python-installation.html
Make sure Python is installed on your platform: Python comes preinstalled on most Unix and Unix-like systems, such as Linux, macOS, and FreeBSD. If your system does not have Python preinstalled for some reasons, use its software management system to ...