Mysql disk - writes

[Anon]

hi,

i am making a small financial package in php and mysql. for this, i have to know how often mysql writes to the disk so that if the server should crash or power failure, i know that the data is safe.

also can someone pls tell me when i shut down the mysql daemon in windows, why does my harddisk get accessed for continous 10-20 secs?

thanks for any reply
steve

[[deleted]]

"i have to know how often mysql writes to the disk so that if the server should crash or power failure, i know that the data is safe."

question: how does knowing how often mysql writes to disk help?

If you want your data to be secure, you should:
a) forget all about running it on windows.
b) read about MySQL's binary logs and transaction support.
c) investigate PostgreSQL.

"also can someone pls tell me when i shut down the mysql daemon in windows, why does my harddisk get accessed for continous 10-20 secs?"

probably because it is flushing it's cache and because windows is completely crap at shutting down anything in a clean and controlled manner. I'm not just knocking windows because I like to (I do like to) but it just doesn't do things nicely. Ever.

PS Windows is NOT the platform to run databases on in the first place.

[Anon]

I have to agree with Vincent on all of the points. However, I suspect that you are only developing under Windows. Is that correct? One way or another, ANY Windows is not good for a db server.

As for the investigate Postgres part, check out the link below. Just keep in mind that it's a little date by now and many of the issues in either db has been addressed, either completely, or at least somewhat.

http://phpbuilder.com/columns/tim20000705.php3?page=1

Later on,
morpheus()

[Anon]

hi,

i am only developing under windows for now. but i may have to opt for a win NT Server. for this purpose i wanted to find out about mysql's performance under windows.

as for the disk writing question, the reason i asked it was becos if the trnasactions done are in main memory and the server goes ta-ta, the data is lost. in windows the flsh tie is set to 1800 secs and in linux it is 0. can u pls tell me if this is time gap between writing to disk or is it something else.

thanks for your reply
steve

[[deleted]]

Read about MySQL's binary log. spend some time in the manual searching for items on this subject. And most important, try ot forget about running any database on windows. It is simply a bad choice.