What’s the difference between INT(2) and INT(20) ? Not a lot. It’s about output formatting, which you’ll never encounter when talking with the server through an API (like you do from most app languages). The confusion stems from the fact that with CHAR(n) and VARCHAR(n), the (n) signifies the length or maximum length of that [...]
Filed under: Good practice / Bad practice by arjen on Monday, March 29, 2010 | Social tagging: birthdate > data types > database > date-of-birth > int > integer > mariadb > mysql > year
No Comments »
We don’t often see this option configured (default: unlimited) but it might be a good idea to set it. What it does is limit the amount of disk space the combined relay logs are allowed to take up. A slave’s IO_Thread reads from the master and puts the events into the relay log; the slave’s [...]
Filed under: Good practice / Bad practice by arjen on Wednesday, March 24, 2010 | Social tagging: mariadb > mysql > relay-log-space-limit > replication
No Comments »