PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/which-version.html
For example, distributions normally are compiled with support for all character sets. If you want a smaller MySQL server, you can recompile it with support for only the character sets you need. When preparing to install MySQL, decide which version ...First, decide whether to install a development release or a General Availability (GA) ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU utilization. Compression is especially valuable for read-intensive applications, on systems with enough RAM to keep frequently ... Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_users system table that provides persistent storage of firewall data; see MySQL Enterprise ...It lists names and operational modes of registered firewall account ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-server.html
The information in this section is appropriate for DBAs who want to ensure performance and scalability across the servers they manage; for developers constructing installation scripts that include setting up the database; and people running MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
Matching performed by the LIKE clause is dependent on the setting of the lower_case_table_names system variable. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database.
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
As a source of data for experimentation: To make a copy of a database that you can use without changing the original data. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation . Table 2.4 Default MySQL Installation Layout for Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
For example, you cannot have a management node running on a PowerPC which directs a data node that is running on an x86 machine. NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a ...