MySQL storage types and their limits

Below are some of the most used data types and its storage requirements:

Data type Storage required
TINYINT 1 byte
SMALLINT 2 bytes
MEDIUMINT 3 bytes
INT 4 bytes
 BIGINT 8 bytes
FLOAT 4 bytes
DOUBLE, REAL 8 bytes
VARCHAR(x) x+1 byte if value is less than 255 bytes and x+2 bytes if over 255 bytes.
TINYTEXT 255 bytes
TEXT 65 535 bytes
MEDIUMTEXT 16 777 215 bytes
LONGTEXT 4 294 967 295 bytes

Notes:

  • Characters can take up different amount of space depending on character encoding. Regular English ASCII characters only take 1 byte per character, meaning that a TEXT column can fit 65 535 characters (a-Z, 0-9 and some special signs)
  • VARCHAR(180) will require 181 bytes of space, regardless if it’s empty or not.

Date formats:

Data type < MySQL 5.6.4 > MySQL 5.6.4
YEAR 1 byte 1 byte
DATE 3 bytes 3 bytes
TIME 3 bytes 3 bytes + fractional seconds storage
DATETIME 8 bytes 5 bytes + fractional seconds storage
TIMESTAMP 4 bytes 4 bytes + fractional seconds storage

Sources:

Format disk with diskpart

Below is a quick guide to illustrate how we can format a disk using diskpart.

First open the command prompt (if booting from Windows install media you may be able to open the command prompt by pressing F8 or Shift+F10).

In your command prompt, type diskpart to enter the diskpart utility. Your input cursor should now look like DISKPART> and you are ready to run the commands below:

list all disks connected to your computer

list disk 


select the disk you wish to format. Replace X below with the number you see from list disk

select disk X 

marks everything on the disk to be deleted – you could also use “clean all” to actually delete it, but this will take a while

clean 



convert disk to MBR – you could also change mbr with gpt

convert mbr 



create a new primary partition

create partition primary 


select the newly created partition

select part 1 



make it active if this is the boot partition

active 



format it to NTFS fileystem and set label to whatever you wish

format fs=ntfs label=X quick 



assign a letter to the partition, typically C for the Windows drive

assign letter C 



list volumes to verify the results

list vol

For more information about Diskpart, see:
https://technet.microsoft.com/en-us/library/cc766465(v=ws.10).aspx