Error updating primary drop
algorithm wait for other operations that are modifying the table to complete.
If this collation is inappropriate for the intended table use (for example, if it would change from a case-sensitive collation to a case-insensitive collation), specify a collation explicitly.While the operation begins are stalled until the new table is ready, then are automatically redirected to the new table.The temporary copy of the table is created in the database directory of the original table unless it is a blocks reads (not just writes) at the point where it is ready to clear outdated table structures from the table and table definition caches. To do so, it waits for current readers to finish, and blocks new reads and writes.For example, if you shorten a string column, values may be truncated.To prevent the operation from succeeding if conversions to the new data type would result in loss of data, enable strict SQL mode before using operation permits an index to be made visible or invisible. Modification of index visibility applies to indexes other than primary keys (either explicit or implicit).You then have tried to insert a value into the child table, but the corresponding value does not exist in the parent table.
To correct this problem, you need to insert the value into the parent table first and then you can insert the corresponding value into the child table.
to indicate ascending or descending sort order, respectively. Only column names are permitted as sort criteria; arbitrary expressions are not permitted.
This clause should be given last after any other clauses.
An algorithm on a table that resides in a shared tablespace can increase the amount of space used by the tablespace.
Such operations require as much additional space as the data in the table plus indexes.
By using this option after major changes to the table, you might be able to get higher performance.