Hi All.....
I'm using Iserver who runs mSQL (version 2.0.5) and using perl with the
dbi module. I've recently run across a couple of problems.
Some one pointed out on the list about 6 months ago that Iserver seemed to
have a problem with the memory sync routine, and indeed msqladmin shows
that memory sync = 0. I tried to change mem sync via the conf file, and
restart the mSQL daemon, but my perl scripts could no longer connect to
the database via web server after the first time it tried to mem sync (but
the monitor still ran at the command line). The msqladmin program still
showed mem sync = 0, though. Changing the conf file to accept the default
and restarting got it working again.
The database files usually lag behind the current time somewhat, I haven't
watched it closely enough to figure out how long - I think I've seen it up
to two days behind. I've been thinking of using cron to stop (using
msqladmin) and restart the msql daemon every hour or so to force it to
update the disk. Anybody have any thoughts on that?
In a (possibly) related incident mSQL crashed and dumped core last week
and I lost 500 records out of the 3000 in the db (luckily I'm only testing
prior to converting from a flat file database). I'm not sure if it was
because of the mem sync problem or because I had a corrupted database.
In order to get it working I had to do a data dump (in which 1000 more
records went away), drop and recreate the database, refilling it from the
flat file db and now it seems OK again.
Apparently the database had been corrupted for some days, but I was still
able to add records, It was only when I tried to use the monitor to delete
all the records from a table that the server dumped. How can I check for
a corrupted database in the future, to minimize lost records? I'd hate to
have actually lost my data!
I do use cron to run msqldump and back up my data - sometimes it can't
connect to the database and fails - other times it runs OK.
Thanks.....
brew
==========================================================================
Strange Brew (brew@theMode.com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST