Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.3
-
None
Description
Updating a column in all rows of an InnoDB table has become slower in MariaDB 10.3, compared to 10.2. Test case
drop table if exists t1;
|
create table t1 (id serial, c1 int, c2 char(10) default 'foobar');
|
insert into t1 (c1) values (rand()*1000);
|
insert into t1 (c1) select rand()*1000 from t1;
|
... (19 more times)
|
update t1 set c2='x';
|
The final UPDATE touches 1 mio rows. There is no index involved. The update can be done in place. In 10.2.14 the updates takes 2 seconds on average, in 10.3.5 it takes 3 seconds on average. More numbers in related MDEV-15213.
Attachments
Issue Links
- relates to
-
MDEV-14425 Change the InnoDB redo log format to reduce write amplification
- Closed
-
MDEV-16041 Do not write for null update (properly fix MySQL Bug#29157)
- Closed
-
MDEV-15213 UPDATEs are slow after instant ADD COLUMN
- Closed