Is there any difference in speed, tinyint or int?

Question

MySQL

Good day! Tell me if there is a difference in speed or size between tinyint, smallint, mediumint, int, bigint. Does it make sense to use them for example for id where the value will be small or do they go as limiters in size?

Answer 1

Yes, the difference in speed is visible if there is a lot of data, and they also take up space in different ways
www.mysql.ru/docs/man/Storage_requirements.html
int is 4 times larger than tinyint