Performance Q

[Rus]

Hi!
Does MySQL open all tables in database when I select data from one table?
Will it be faster to split db to number of smaller db associated with concrete PHP 
scripts?