sql - MySQL - Where can I find metrics on the performance of Blob vs file system? -

i know , understand there performance hits in storing blob data in database, blob portion of data going retrieved/viewed, smaller data (the vast majority under 256k max of 10mb), not going used customers, , total rows expected relatively low, under half million, if not less. of data dynamic , can change users, in it's not static images. in other words we're @ edge of whether or not it's worth it.

i keep reading it's better store in file system can't find actual metrics show performance difference, people repeating each other without concrete proof or metrics. may worth performance cost in exchange being acid guaranteeing our backups synched.

that being said know or have real world metrics show performance difference between storing items blobs vs in file system. i'm trying understand if performance penalty worth or not rather blindly following general rule of thumb , after spending @ least 2-3 hours i've yet able see show actual numbers...

update: mysql innodb table. actual data table has link blob data table, blob not in main able , retrieved when need avoid i/o issues. in other words instead of path data on filesystem, it's id table blobs. how compare in terms of performance? 25% worse? 100%? 200-500%? 1000%?

if cost 100%-200% worth because again data retrieved. if had 10,000 concurrent users, maybe 50 users retrieving blob data concurrently @ best. yes data specific each user, isn't images.