You should use PostgreSQL
“MySQL is a pretty poor database, and you should strongly consider using Postgres instead.”— Ex-MySQL developer
“InnoDB rolls back only the last statement on a transaction timeout by default.”— innodb_rollback_on_timeout
“The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024”— GROUP_CONCAT()
“BLOB, TEXT L + 2 bytes, where L < 2^16 (64 Kilobytes)”
— Maximum length for MYSQL type text
“MySQL has a utf8 encoding, and it’s generally regarded as best practice to use that for all your text columns so you can store Unicode. But, oops, MySQL arbitrarily limits it to three bytes per character, which isn’t enough to encode most astral plane characters! What a great technical decision and not at all yet another thorn in the unusable sinkhole that is MySQL. Version 5.5 introduced a utf8mb4 encoding that fixes this, so have fun ALTERing some multi-gigabyte tables in production.”— Eevee