ALTER TABLE table_1 ENGINE=Aria;
on a table created with ENGINE=Aria to rebuild index, will sometimes (I estimate 1 in 4 times) quickly run past 100% on second stage when seeing it from the client perspective. Server side the query will finish just fine, but client-side it appears to be stuck.
Stage: 2 of 2 'þ' 131% of stage done
To better illustrate what happens a timeline:
00m00s Client "ALTER TABLE table_1 ENGINE=Aria;" - Stage 1 commences
00m30s "Stage: 2 of 2 'Repair with 2 threads' 34.9% of stage done"
01m00s "Stage: 2 of 2 'z' 131% of stage done" - client never moves on from here
03m00s Table/Index has been rebuild and server is idling.
03m10s Ctrl-c to kill current connection thread, and re-connect to server, to continue to next query.
Never experienced the issue on 10.3.11
CREATE TABLE `table_1` (
`col1` binary(16) NOT NULL,
`col2` varchar(255) NOT NULL,
PRIMARY KEY (`col1`),
KEY `col2` (`col2`(8))
) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 ROW_FORMAT=DYNAMIC TRANSACTIONAL=0
CREATE TABLE `table_2` (
`col1` binary(8) NOT NULL,
`col2` varbinary(127) NOT NULL,
`col3` binary(8) NOT NULL,
UNIQUE KEY `col3` (`col3`),
KEY `col1` (`col1`)
) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 ROW_FORMAT=DYNAMIC TRANSACTIONAL=0;
Happens on both of these tables