Hi. We have quite a buzy MySQL/InnoDB server. There is a lot activity on the servers and the tables get quite fragmented. In order to fight this we use the "alter table foo type=innodb"-trick.
Today, ~100 tables are active. I was thinking of hashing the data out to approx 1100 tables. This will reduce the inpact of defragmenting the tables as well as increase the cache hit rate (due to less frequent invalidation of the cache). Are there any performance penalties for using many tables? -- There are only 10 different kinds of people in the world, those who understand binary, and those who don't. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
