Add algorithm/lock Support for alter columns in mysql #1516

Job	Run time
Windows - PHP 8.1 & SQL Server	2m 22s
Coding Standard & Static Analysis	28s
testsuite (8.1, mysql)	38s
testsuite (8.1, sqlite)	29s
testsuite (8.1, pgsql)	42s
testsuite (8.4, sqlite)	29s
testsuite (8.4, pgsql)	47s
testsuite (8.2, mysql)	1m 10s
testsuite (8.4, mysql)	1m 22s
testsuite (8.1, sqlite, prefer-lowest)	33s
	9m 0s

Provide feedback