[Info-vax] Databases versus RMS

[Arne Vajhøj]

On 4/22/2012 2:40 PM, JF Mezei wrote:
> 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.

You should not guess.

http://dev.mysql.com/doc/refman/5.5/en/innodb-configuration.html

>> 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)

I would create a /databases or /home/databases dir for the databases.

>> Have you read the MySQL documentation?
>
> Have not gotten to or see portions that explain the file structures and
> purposes.

See above.

>           It is a steep learning curve and I wonder how many people go
> through it to really underetand what happens under the hood.

Most of it is actually easy to read and easy to find.

And with the many MySQL users on the internet then GIYF.

Arne