I added more tables to my mysql server. 20% increase in tables that are all innodb. I have 200 + databases that use the same schema.
Does adding more tables increase memory usage? I am using about 1.7 gb of ram for mysql where before I was using 1.4-1.5gb
Best Answer
Does it increase memory ??? Absolutely !!!
I wrote a post about INFORMATION_SCHEMA (
Jun 15, 2011
: How is INFORMATION_SCHEMA implemented in MySQL?)In that post I explained how metadata for MySQL tables are stored in temporary tables using the MEMORY storage engine. For example, when you create a table
mydb.mytable
, look at what gets populated into these tables:mydb.mytable
)mydb.mytable
is partitioned, one row for each partition)mydb.mytable
mydb.mytable
mydb.mytable
In short, all these tables have to increase in memory usage for each table you create. In your particular case, that would be multiplied by 200.