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/performance-schema-instrument-naming.html
For example, an insert might activate a trigger that causes an update. An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
When a metadata lock is requested and not obtained immediately, a row with a status of PENDING is inserted. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html
The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or WRITE. The Performance Schema exposes table lock information through the table_handles table to ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. Floating-point numbers ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
A table can be changed by many types of statements, such as INSERT, UPDATE, DELETE, TRUNCATE TABLE, ALTER TABLE, DROP TABLE, or DROP DATABASE. WHERE autoincrement_col IS NULL The last form is not cached because it is used as the ODBC workaround for ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. When the destination table exists and IF NOT EXISTS is given, MySQL 5.7 ignores the statement completely; nothing is inserted or logged.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. For example, since MyISAM ignores foreign key constraints, an INSERT or ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. It may also cause inserts into ...For ...