[Info-vax] Databases versus RMS

[Arne Vajhøj]

On 4/22/2012 6:06 PM, JF Mezei wrote:
> Arne Vajhøj wrote:
>
>> http://dev.mysql.com/doc/refman/5.5/en/innodb-configuration.html
>
> Thanks. Please realise that Apple had provided a turn-key MySQL
> installation on OS-X server with a GUI front end to manage it. So I
> focused more on creating tables and converting my data from RMS to MYSQL.
>
> The outage of dslreports.com (still out and no ETA on when it is to
> return) has raised the flag that I need to learn more about it. (and in
> doing so, realised I should be installing a more recent version of mysql
> and disabling the one provided by Apple)

Makes sense.

> BTW, the link you provided above has an interesting section exactly on
> the topic of power outages and possible corruption and ensuring data
> gets written to disk.

It is a relevant topic in the context.

>> I would create a /databases or /home/databases dir for the databases.
>
> Is there something inherently wrong with /var/mysql   for the data files ?
>
> (the software is in /usr/local/mysql-5.5.23-osx10.6-x86_64
>   with /user/local/mysql symlink to it)

I assume that /var/mysql conatins the mysql system database
and possible some other system stuff.

I would want to separate that from the user databases.

Less important for InnoDB than for MySQL but still.

>> Most of it is actually easy to read and easy to find.
>
> Maybe in time I will be able to go trhough a dump of one of the table
> files and understand it the same level as I can understand an RMS file
> with the way its index is built and the way records are stored. But this
> won't happen overnight and I suspect few datbase administrators these
> days really know what goes on under the hood.

Very few would want to do that.

You use the provided tools.

And if you really want to be prepared for the worst, then you
pay for a service contract.

>> And with the many MySQL users on the internet then GIYF.
>
> Well this is depressing. I had to use Google to get the meening of GIYF
> :-(

:-)

Arne