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/mysql-cluster-ndbinfo-cpustat-20sec.html
The cpustat_20sec table provides raw, per-thread CPU data obtained each 20 seconds, for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_1sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a ...
https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html
For maximum portability, code requiring storage of approximate numeric data values should use FLOAT or DOUBLE PRECISION with no specification of precision or number of digits. The FLOAT and DOUBLE types represent approximate numeric data values.
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...The intent is to handle each such statement in its own special transaction because it cannot be rolled back ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
Primary key values are included in secondary indexes, which takes up unnecessary space if the primary key is a long string value. You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. Changes ...This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
Assume also that the MySQL server is under load at the time of the crash. Information about this recovery process is conveyed to the user through the MySQL error log. You should include such options as necessary to enable client programs to connect ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. If the values in this table for a given timer name are NULL, that timer is not supported on ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. Aliases for column names in CREATE VIEW statements are checked against the maximum column length of 64 characters (not the maximum alias length of 256 ...View ...