Generic questions

[Andrzej Janczyszyn]

Where may I find more detail information about MySQL DBA?

How MySQL handle very large table (>10,000,000 records)?
How can I give direction where store data files? 
 example:
                /var/lib/mysql
                                |
                                MYDATABASE
                                                    |
                                                    ---- SPACE1      (/dev/sda3)
                                                    |
                                                    ---- SPACE2     (/dev/sdb1)
                                                    |
                                                    --- SPACE3       (/dev/sdc2)

Is it possible specify size and location of designated data files for a specific 
tables (like 
in Oracle create a table space and give a location of datafiles)?
What are MySQL limits?

All the questions relate to MySQL on Linux.

Thanks,
AMJ