in the TRUNCATE TABLE t1
This is the documented behavior:
http://www.mysql.com/doc/en/TRUNCATE.html
You cannot use TRUNCATE on tables for which you hold locks.
On Monday 09 June 2003 10:57 am, you wrote:At 9:01 -0500 6/9/03, Todd Gruben wrote: >In an effort to speed up large batch deletes i devised this script. > >LOCK TABLES t1 WRITE; >SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09"; >TRUNCATE TABLE t1; >LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1; >UNLOCK TABLES; > >this script would work great without the LOCK TABLES clause. I receive an >error saying there active locked tables. This is a heap table and I am >running mysql 4.0.12
At which statement does the error occur?
>Any ideas? i need the lock tables because there are some updates that will > be happening to the current data, i just need to remove the old expired > data. This takes about 30secs and my delete scripts takes about 4 hours. > It is deleting about 500,000 rows out of a 4 million row table with > several indexes. >-Todd
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
