Try putting the data directory on a small partition and let it get filled 100%
with a single update that does not get fully committed due to disk full, then
turn the power off to the computer so there is no attempt for a nice shutdown.
You should also get a corruption in the master binary logs, if binary logging is
turned on.

If you use VMWare (vmware server is free) to virtualize a test OS with small
drives, it will be easier to do this.

-RG


Richard Edward Horner wrote:
> Hi,
> 
> I'm working on a program that will run in the event that tables are
> crashed or corrupt. Can anyone recommend a good method for crashing my
> tables or corrupting them so I have some test cases? I'm mostly
> interested in MyISAM and InnoDB table types.
> 
> I was thinking I would just start an infinite loop with an UPDATE
> statement in it and then kill -9 the mysqld process.
> 
> Any better ideas?
> 
> Thanks, Rich(ard)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to