RE: mysql setup compared to oracle

2003-07-17 Thread Rudy Metzger
nberg'; [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

RE: mysql setup compared to oracle

2003-07-17 Thread Jim Smith
> 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

RE: mysql setup compared to oracle

2003-07-17 Thread Jim Smith
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 a

RE: mysql setup compared to oracle

2003-07-17 Thread Rudy Metzger
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 co