"James E Hicks III" <[EMAIL PROTECTED]> wrote: > 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
Looks quite strange: I have used to load gigabytes of data this way with no problem. Try to upgrade server to the latest binary release (4.0.13?) for your OS.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]