How does this help me? the tables are locked, and I can not write. how do I test?
Shmuel. On 2011/08/18 0:08, Issac Goldstand wrote: > |FLUSH TABLES WITH READ LOCK| <flush.html>; > http://dev.mysql.com/doc/refman/5.0/en/flush.html > > On 17/08/2011 17:24, Shmuel Fomberg wrote: >> hi all. >> >> at work we have a test suit that run against a database. so in the >> beginning of the test it populate the database with a predefined data. >> the problem is that this process is way too long, making the test suit >> take a long time to run. >> so I'm looking for options to cut this time. >> >> is there any ability to freeze a database? so all the changes will be >> temporary and disappear in the end of the test, leaving the database in >> a clean state for the next test? >> maybe some kind of middleware? >> maybe using transactions? (mysql supports transactions, right?) >> can transaction hold a large amount of operations / data? (I don't want >> to limit the test of what it can do to the data...) >> >> Shmuel. >> _______________________________________________ >> Perl mailing list >> [email protected] >> http://mail.perl.org.il/mailman/listinfo/perl > > > > _______________________________________________ > Perl mailing list > [email protected] > http://mail.perl.org.il/mailman/listinfo/perl _______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
