1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one for index information).
InnoDB looks a bit similar, as it also uses the
I'm fairly new to mysql myself, but I'll have a go.
The mysql manual is at http://www.mysql.com/doc/.
I've only dipped into it, but it seems to be pretty good.
Questions:
1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance and
1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one for index information).
Actually the server is equivalent to an
'; [EMAIL PROTECTED]
Subject: RE: mysql setup compared to oracle
1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one