What are the optimum varchar sizes for MySQL?

by

To answer the question, on disk MySql uses 1 + the size that is used in the field to store the data (so if the column was declared varchar(45), and the field was “FooBar” it would use 7 bytes on disk, unless of course you where using a multibyte character set, where it would be using 14 bytes). So, however you declare your columns, it wont make a difference on the storage end (you stated you are worried about disk optimization for a massive table). However, it does make a difference in queries, as VARCHAR’s are converted to CHAR’s when MySql makes a temporary table (SORT, ORDER, etc) and the more records you can fit into a single page, the less memory and faster your table scans will be.

More Related Contents:

  1. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  2. MySQL: Large VARCHAR vs. TEXT?
  3. What is the MySQL VARCHAR max size?
  4. Equivalent of varchar(max) in MySQL?
  5. Difference between VARCHAR and TEXT in MySQL [duplicate]
  6. MySQL VARCHAR Lengths and UTF-8
  7. MySQL varchar index length
  8. MySQL too long varchar truncation/error setting
  9. SQL unique varchar case sensitivity question
  10. What to do when you need integers larger than 20 digits on mysql?
  11. SQL Print the name of all Employees together with the name of their supervisor
  12. Change MySQL default character set to UTF-8 in my.cnf?
  13. MySQL offset infinite rows
  14. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  15. How do write IF ELSE statement in a MySQL query
  16. mysql – making a mechanism similar to Oracle’s seqences
  17. How do you uninstall MySQL from Mac OS X?
  18. UUID performance in MySQL?
  19. MySQL: NULL vs “”
  20. MySQL Error 1264: out of range value for column
  21. Like Case Sensitive in MySQL
  22. What is the best way to delete old rows from MySQL on a rolling basis?
  23. What are the known ways to store a tree structure in a relational DB? [closed]
  24. Illegal mix of collations error in MySql
  25. mysql equivalent data types
  26. Get difference in years between two dates in MySQL as an integer
  27. Check if a column exists in a table with MySQL
  28. Connect to Docker MySQL container from localhost?
  29. What is the best way to do incremental backups in MySQL?
  30. MySQL’s lower_case_table_names won’t change

Leave a Comment