Search Results
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. Users: You may need (or want) to create a specific mysql user to own the MySQL directory and data. You can do this ...The installation and upgrade process is for MySQL packages provided by ... You should keep the following issues and notes in mind: Other MySQL installations: The installation ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pem.html
In your application, add a connection string using the test database and the sslclient user account (created previously). using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "SslMode=VerifyFull" Add the ...For ... The direct use of PEM format certificates was introduced to simplify certificate management in multiplatform environments that include similar MySQL ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pem.html
In your application, add a connection string using the test database and the sslclient user account (created previously). using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "SslMode=VerifyFull" Add the ...For ... The direct use of PEM format certificates was introduced to simplify certificate management in multiplatform environments that include similar MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
MySQL also supports setting the histogram of a single column to a user-defined JSON value. In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use ...ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Therefore, users should be careful in identifying which tables are “inactive” and which are “busy” when trying to perform an optimistic backup. Optimistic backup is a feature for improving performance for backing up and restoring huge ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
row *************************** Id: 5 User: root Host: localhost db: test Command: Query Time: 44 State: Waiting for table metadata lock Info: ALTER TABLE t1 ADD COLUMN x INT, ALGORITHM=INPLACE, LOCK=NONE ... When evaluating the techniques for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. A maximum ...The temporary tablespaces allocated to a session are used for all on-disk temporary tables created by the ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. However, if the user's privileges on t are subsequently revoked, the user can continue ...“Identical” means that all tables have identical column data types and index ... The MERGE storage engine, also known as the ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The workaround to the problem is for the administrator to manually grant the SHOW VIEW privilege to users who are granted CREATE VIEW, since MySQL doesn't grant it implicitly when views are created. If a user is granted the basic privileges ... The ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. Stored procedures can be particularly useful in situations such as the following: Stored procedures ...