[Info-vax] Databases versus RMS

[JF Mezei]

Arne Vajhøj wrote:

> The InnoDB data are in ibdata1.
> The InnoDB log is in ib_logfile*.
> The MySQL replication log is in mysql-bin.*.
> Using MySQL replication log is optional.

Thanks. I would not have guessed  "ib" was innoDB.


> I would seriously consider moving the InnoDB data and log to another dir
> than the MySQL software tree.

Apple originally put my data in /var/mysql  so I kept it there when I
moved to the real release of MySQL (now I have to figure out where the
apple supplied softwre is located, it appears to be spread with the
binaries in libexec.

My installation is in /usr/local/mysql (a link to the actual version
specific directory)


> Have you read the MySQL documentation?

Have not gotten to or see portions that explain the file structures and
purposes.  It is a steep learning curve and I wonder how many people go
through it to really underetand what happens under the hood.