Hello.
On Tue 2002-06-18 at 14:29:38 +0300, [EMAIL PROTECTED] wrote:
> Hello,
>
> Does anybody know how and when mysql writes records and indexes to
> harddrive? The main purpose of this question is below.
>
> I am using mysql 4.0.1 on win98 for test purposes. During the tests my
> computer halted suddenly because of a hardware problem. After restarting
> my computer i have seen that some of my tables which i were using when
> the problem arises have been crashed. I have repaired the tables but
> then i have noticed that the records which i inserted in the last half
> hour was lost. Does anybody have any comments about this?
Well, mainly, don't use Windows 98 for any serious work. It is *not*
suitable for production use of a database.
It is difficult to make garantuees on when data is actually written to
disks, but I seldom lost more than the few last seconds on outages,
with different flavors of UNIX (including Linux).
InnoDB type tables an be tuned to have a low risk of losing unwritten
data (more precisely: to have few unwritten data) at the cost of
speed.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
