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/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. STRICT_TRANS_TABLES If a value could not be inserted as ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
For example, if you execute an INSERT statement with 100 rows of data, then the insert-row-start and insert-row-done probes are triggered 100 times each, for each row insert. insert-row-start(database, table) insert-row-done(status) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 12.15, “Information Functions”). The ...For stored functions and triggers that change the value, the value is restored when the function or trigger ends, so following statements do not see a changed ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. If you are using a recent version of ... The ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
bulk_insert_buffer_size Command-Line Format --bulk-insert-buffer-size=# System Variable bulk_insert_buffer_size Scope Global, Session Dynamic Yes Type Integer Default Value 8388608 Minimum Value 0 Maximum Value (64-bit platforms) ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
Here is an example that uses GET DIAGNOSTICS and an exception handler in stored procedure context to assess the outcome of an insert operation. If the insert was successful, the procedure uses GET DIAGNOSTICS to get the rows-affected count. Within a ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
The locks are normally next-key locks that also block inserts into the “gap” immediately before the record. If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
This results in faster inserts when the dump file is reloaded. This option does not work with parallelism because INSERT statements from different tables can be interleaved and UNLOCK TABLES following the end of the inserts for one table could ...