PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
Example 4: Database, Table, and Column Definition CREATE DATABASE d1 DEFAULT CHARACTER SET latin2 COLLATE latin2_czech_cs; USE d1; CREATE TABLE t1 ( c1 CHAR(10) ); We create a column without specifying its character set and collation. In this ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 ...