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/innodb-performance-schema.html
This section provides a brief introduction to InnoDB integration with Performance Schema. This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. DBAs can also use this feature for ...For comprehensive Performance Schema documentation, see Chapter 25, MySQL Performance ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. This means that a plugin is installed with INSTALL PLUGIN only once, not every time the server starts. This enables the plugin to pick up any relevant ...It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
--pid-file=file_name This option indicates the path name of the file in which the server writes its process ID. This causes each instance to automatically use a different data directory, log files, and PID file because the default for each of those ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
This section first describes the basic operation of the MyISAM key cache. If this variable is set equal to zero, no key cache is used. This size can be equal to, greater than, or less than the size of a table index block. If it happens that a block ... To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-installation.html
This section describes the basics for planning, installing, configuring, and running an NDB Cluster. This section covers hardware and software requirements; networking issues; installation of NDB Cluster; basic configuration issues; starting, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
It is highly recommended that you make use of this utility when filing reports of bugs in NDB Cluster. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format --connection-timeout=# Type Integer ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installation-windows-path.html
Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were opened have been dismissed. This includes the servers, the mysql client, and all MySQL command-line utilities such as mysqladmin and mysqldump.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. But this ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. Without this option, mysqldump treats the first name as a database name and those following as table names. This ensures that when the dump file is reloaded, it creates ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Does each table use an appropriate row format? This choice also depends on the storage engine used for the table. With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. This time ...