I have encountered an interesting problem using mysql. On both 3.23 and another 4.01 server when I try to batch load a file with sql statements (ex. mysql -u user -p < mysql_statements.SQL) and the file is greater that 500MB it never seems to finish. I have never had the patiences to see if it ever does. Last night I watched the tables as they were loading and as soon as the DB got to ~ 500 MB the inserts would slow down to a crawl. Before it gets to 500MB the server is loading 100's of records at a time, after 500MB the server may load 2 records/5minutes. When I broke the mysql_statements.SQL into smaller files and consecutively loaded these files, the load only took 5 minutes top. Any ideas what I can do to get these large files to load without breaking them down? Is there a server config value I missed?
James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
