PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
To avoid problems like this, benchmark your whole application under the worst possible load: The mysqlslap program can be helpful for simulating a high load produced by multiple clients issuing queries simultaneously. Benchmark your application and ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
A menagerie distribution containing some of the queries and sample data used in the following sections can be obtained from the MySQL website. Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-client.html
To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with -DWITH_DEBUG=1. Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export ...
https://dev.mysql.com/doc/refman/5.7/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 13.7.5.5, “SHOW COLUMNS Statement”, and Section 13.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
In terms of MySQL this means: Create a new entry (insertion or addition) Read entries (queries) Update entries Delete entries X Plugin The MySQL Server plugin which enables communication using X Protocol. This section explains the concepts ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol clients cannot connect to the server. The X Plugin is supplied with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/5.7/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...