Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.4/en/custom-benchmarks.html
Benchmark your application and database to find out where the bottlenecks are. A free benchmark suite is the Open Source Database Benchmark, available at http://osdb.sourceforge.net/. In most cases, performance problems turn out to be due to issues ...After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next ...
https://dev.mysql.com/doc/refman/8.4/en/document-store.html
Traditionally, relational databases such as MySQL have usually required a schema to be defined before documents can be stored. This differs from working with a relational database and storing products in a table, when all columns of the table must ... This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
These indicate issues of interest to database administrators or that require DBA action. It is MySQL-specific and is not portable to other database systems. This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-c-api.html
What is “MySQL Native C API”? What are typical benefits and use cases? libmysql is a C-based API that you can use in C applications to connect with the MySQL database server. It is also itself used as the foundation for drivers for standard ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. It is important to understand that although the database service is available, in the event of an unexpected server exit, those clients connected ... Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the unqualified table name. HANDLER enables you to traverse a database in a manner that is difficult (or even impossible) ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...