[Info-vax] Databases versus RMS

[JF Mezei]

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)

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.


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

Once I am comfortable that I have no conflicts between the Apple side of
things and the self installed mysql, then I might get more creative on
where I put the data.


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


> 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
:-( Maybe I should just flip burgers at a McDonalds and not have to
worry about any of that.