Search Results
https://dev.mysql.com/doc/refman/9.7/en/disk-issues.html
You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful on a database server), you can mount your file systems with the -o noatime option. The ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...For ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/partial.html
IMPORTANT: Because the InnoDB system tablespace holds metadata about InnoDB tables from all databases in an instance, restoring a partial backup on a server that includes other databases could cause the system to lose track of those InnoDB tables in ...In particular, InnoDB tables have internal IDs and other data values that can only be restored to the same instance, not a different MySQL ... By default, all the files under the database subdirectories in the data directory are included in the backup, so ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-roles.html
This system is designed around the concept of membership, profile, and role providers, which together provide all of the functionality to implement a user system, that previously would have to have been created by the developer from scratch. It ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html
This system is designed around the concept of membership, profile, and role providers, which together provide all of the functionality to implement a user system, that previously would have to have been created by the developer from scratch. It ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation-linux.html
Download the source code and compile yourself: The source code is available as part of MySQL Server at https://dev.mysql.com/downloads/mysql. Installing MySQL Router using an official DEB or RPM package creates a local system user and group named ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mysql-ai-platforms.html
System administrators may want to prevent that from happening, especially if their systems are going on production. Possible measures that can be taken include: Disallow certain users (for example, the server administrator) from connecting by HTTP ...You have TLS certificates and keys that satisfy the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. There is also support for ...
https://dev.mysql.com/doc/refman/9.7/en/atomic-ddl.html
The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the operation. CREATE TABLE, ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-backups.html
We assume that the replication servers have already been configured as covered previously (see Section 25.7.5, “Preparing the NDB Cluster for Replication”, and the sections immediately following). This method requires that the cluster backup ...
https://dev.mysql.com/doc/refman/9.7/en/windows-choosing-package.html
The package formats described in this section are: MySQL Installation MSI MySQL noinstall ZIP Archives MySQL Docker Images MySQL Installation MSI This package has a file name similar to mysql-community-9.7.0.msi or mysql-commercial-9.7.0.msi, and ...