I should add that my test continually inserted and deleted records from a set of tables. At no point did any table have more than 101 records, but the test ran 348 times, so there were 348 * 100 rows INSERTed and DELETEd.
-ms ---------- Original Message ---------------------------------- From: "Michael S" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Thu, 3 Apr 2003 23:45:28 -0600 >My InnoDB file is set to 60MB, and is not set to autoexpand. > >When running stress tests against my server today, I got a message that the table was >full and the test stopped. Sure enough, the InnoDB file was about 62MB. > >My question: >I assume that the InnoDB file is the transaction log. Is there a command that I >should be running to truncate the transaction log periodically so it doesn't fill up? >On MS SQL Server, I can run with TRUNCATE LOG ON CHECKPOINT if running in a test >scenario. > >TIA, >-ms > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
