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/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
If you need to refer to the value later, save it: mysql> SELECT SQL_CALC_FOUND_ROWS * FROM ... It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Then modify the table definitions as just described and import the file into the SQL node of the cluster like this: $> mysql world < /tmp/world.sql If you save the file to a different location, adjust the preceding instructions accordingly. Running ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
A dedicated temporary tablespace also means that it is no longer necessary to save temporary table metadata to the InnoDB system tables. A large data file can also result from long running queries that use temporary tables. For example: [mysqld] ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Writing a good bug report takes patience, but doing it right the first time saves time both for us and for yourself. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
Save the test2_libmysqld.c source and the GNUmakefile in the directory, and run GNU make from inside the test2_libmysqld directory. These two example programs should work without any changes on a Linux or FreeBSD system. For other operating ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Statements and Functions Full operator and function support in the SELECT list and WHERE clause of queries. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
By default, pages read by queries are immediately moved into the new sublist, meaning they stay in the buffer pool longer. The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits ...