Does the number of tables affect the speed of MySQL?

Question

MySQL

Let's say if there are a HUGE number of tables, several thousand or more? Example. There are attributes of goods - material, size. Attributes have SETs of unique values ​​(material - "plastic", "dihydro-ergo-cryptine"; size - "XM", "XL"). Question: how it is better to store the data (EXACTLY in terms of PERFORMANCE )? Option 1 - one table for all attributes and their values. Option 2 - a separate table for EACH attribute? (In this case, we have a bunch of tables BUT with a small number of records)

Answer 1

How about an option to store the most common attributes in fields and the rest in a JSON field? Clearly better than a few thousand tables.

Answer 2

MySQL has an enum field type. www.mysql.ru/docs/man/ENUM.html
Not suitable?