title: Memory allocation in MySQL datatypes?
body: <p>I am new to the MySQL. I have little bit confusion about memory allocation for datatypes. If I initialize type as bigint it will take 8 bytes of memory. If I initialize bigint(10) then would it take 80 bytes or same 8 bytes with limitations. what is use of initializing 10 over the datatype? And also I have bit confused in varchar as well. what would be the memory size of varchar(10) and varchar(100)? will it differ in memory size? Am using InnoDB engine.</p>