Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Currently, it is impossible to know whether bulk insert was used when inserting into empty table, or not. There is no indicator, no error log output, no "note" warning added, no status variable for that.
For the diagnostic purposes, there should be something at least. Perhaps, a global counter would be the easiest thing.
Attachments
Issue Links
- causes
-
MDEV-34963 INNODB_BULK_OPERATIONS status variable is not documented
-
- Closed
-
- relates to
-
MDEV-11369 Instant add column for InnoDB
-
- Closed
-
MDEV-11369introduced the global status variable innodb_instant_alter_column. For rare operations such as DDL, a global status variable should be fully acceptable.Also for this one we could simply introduce a global status variable, with the assumption that inserting into an empty table is a rare operation. This counter could also be updated on DDL operations that use the bulk insert mechanism. Maybe for clarity, it should also be updated by any table-rebuilding ALTER TABLE that uses the code path.
A suitable name could be something like innodb_bulk_operations.