Improper Shutdown Problem

Hello
I am using MySQL from 2 and half years. In every
version, there is a problem regarding improper
shutdown.
My product is developed using J2EE technologies. In
almost half of the cases, If I am using the product
and computer shuts down improperly due to power
failure, a huge amount of data in the form of Nulls,
blank fields and invalid entries in numbers and
strings of special characters enters in tables. Thanks
God it do not effect existing data. To correct the
problem, I have to search for those rows and delete
them.

Thank You
Anas Wahab


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Improper Shutdown Problem

Anas Wahab writes:
> Hello
> I am using MySQL from 2 and half years. In every
> version, there is a problem regarding improper
> shutdown.
> My product is developed using J2EE technologies. In
> almost half of the cases, If I am using the product
> and computer shuts down improperly due to power
> failure, a huge amount of data in the form of Nulls,
> blank fields and invalid entries in numbers and
> strings of special characters enters in tables. Thanks
> God it do not effect existing data. To correct the
> problem, I have to search for those rows and delete
> them.
>
> Thank You
> Anas Wahab

Hi!

This list is dedicated to the repeatable test cases, and yours is not
the one.

Avoiding corruption in power failures requires usage of ACID level
security storage engine, like BDB or InnoDB.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org