Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation. Warning User-defined ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
mysql> UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name like 'events_waits%'; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 You can verify that wait event consumers are enabled by querying the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. MyISAM table maintenance can also be done using the SQL statements ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux.html
A host running an SQL node must have installed on it a MySQL Server binary (mysqld). It is not necessary to install the MySQL Server binary on management node hosts and data node hosts. Management nodes require the management server daemon ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-top.html
Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the cluster. --host[=name], -h Command-Line Format --host=string Type String Default Value localhost Host name or IP ...By default, it attempts to connect to a mysqld running on localhost and port 3306, as the MySQL root user with no password ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-runtime-configuration.html
If there are Performance Schema configuration changes that must be made at runtime using SQL statements and you would like these changes to take effect each time the server starts, put the statements in a file and start the server with the init_file ...This strategy can also be useful if you have multiple monitoring configurations, each tailored to produce a different kind of monitoring, such as casual server health monitoring, incident investigation, application behavior troubleshooting, and so ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs.html
A replica server creates several repositories of information to use for the replication process: The replica's relay log, which is written by the replication I/O (receiver) thread, contains the transactions read from the replication source server's ...For information about the relay log, see Section 19.2.4.1, “The Relay ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-threaded-clients.html
Two threads can share the same connection with the following caveats: Unless you are using the asynchronous C API functions mentioned previously, multiple threads cannot send a query to the MySQL server at the same time on the same connection. The ... This section provides guidance for writing client programs that use the thread-related functions in the MySQL C ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/tasks-access-within-k8s.html
Your MySQL connection id is 500 Server version: 8.4.0-cluster MySQL Cluster Community Server - GPL Copyright (c) 2000, 2022, Oracle and/or its affiliates. An application running inside the Kubernetes Cluster can use these extracted information and ...Oracle is a registered trademark of Oracle Corporation and/or its ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
MySQL Server 5.6 and higher can have CHAR columns with a length up to 255 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to 65535 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to ... The following table shows the mapping between PostgreSQL (source) data types and MySQL data ...BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION ...