PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Just remember to take down the server (or lock and flush the relevant tables) before you run myisamchk. Some operating ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool.html
As more clients connect to the server and execute statements, overall performance degrades. The thread pool plugin provides an alternative thread-handling model designed to reduce overhead and improve performance. The plugin implements a thread pool ... Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
Version token lists are established per server (for example, to specify the server assignment or operational state). The following sections describe the elements of Version Tokens, discuss how to install and use it, and provide reference information ... MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date ...
https://dev.mysql.com/doc/refman/5.7/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system database. This database and the access control system are discussed extensively in Chapter 5, MySQL Server Administration, which you should consult for additional details. This ...Important Some MySQL releases introduce changes to the grant tables to add new privileges or ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-c-api.html
It is also itself used as the foundation for drivers for standard database APIs like ODBC, Perl's DBI, and Python's DB API. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
You can obtain a listing of all triggers defined on database dbname using a query on the INFORMATION_SCHEMA.TRIGGERS table such as the one shown here: SELECT TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_STATEMENT FROM ...Where can I ...Can a table have multiple triggers with the same trigger event and action time? ...
https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html
This information is stored in several tables in the mysql database (see Section 5.3, “The mysql System Database”). Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. For example, you cannot have a tablespace and a data file with the same name, or an undo log file and a tablespace with the ...
https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html
This section discusses methods for starting and stopping the MySQL server. On Windows, you can set up a MySQL service that runs automatically when Windows starts. On Unix and Unix-like systems, you can invoke mysqld_safe, which tries to determine ...Generally, you start the mysqld server in one of these ways: Invoke mysqld ...