Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). row ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-size-pl.html
If you do not wish to use an existing account, then creating one using GRANT USAGE ON db_name.*—where db_name is the name of the database to be examined—is sufficient for this purpose. Options that can be used with ndb_size.pl are shown in the ... This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-troubleshooting-egress-privatelink.html
Table 6-2 Egress PrivateLink: Common Issues and Resolutions Deployment Step Error Summary Steps to Resolve Create Egress PrivateLink Could not Create PrivateLink. Troubleshooting an Egress PrivateLink 6.2.3 Troubleshooting an Egress PrivateLink ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-replcation-setup.html
This section provides sample steps for setting up a MySQL NDB Cluster replication with a single replication channel using the MySQL Cluster Manager. Before trying the following steps, it is recommended that you first read NDB Cluster Replication to ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode ... This section lists environment variables that are used directly or indirectly by ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
(The SPN and same key also must be created in the Kerberos server.) The file may contain multiple service principal names and their respective key combinations. The client-side authentication_ldap_sasl_client plugin communicates with the SASL ...The ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...