afaik meta (who are very large btrfs user) do not use it with mysql but do use it with rocksdb backends.

i think you can tweak it to make high random write load less painful but it generally will struggle with that.