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

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 and

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 Rudy Metzger
'; [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