Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

major connection spike during "source dumpfile.sql" [message #1547] Mon, 23 July 2007 17:23  RichardBronosky Messages: 20 Registered: June 2007 Junior Member I have a master server (with one slave) that I have noticed this on. When I connect to the master from my workstation via: mysql -h master and then try to load a 80MB to 500MB SQL file generated from mysql dump, like so: source dumpfile.sql It takes several minutes to load because of the effected indexes. But during that time I see my connection go from in the 20's to in to 250's even 500's at one point. (According to the MySQL Network Monitoring and advisory server tool.) Has anyone ever seen anything like this? .+# Richard Bronosky #+. MySQL DBA, MythTV User Report message to a moderator

	major connection spike during "source dumpfile.sql" By: RichardBronosky on Mon, 23 July 2007 17:23
	Re: major connection spike during "source dumpfile.sql" By: Peter on Thu, 16 August 2007 11:04
	Re: major connection spike during "source dumpfile.sql" By: RichardBronosky on Thu, 16 August 2007 15:10
	Re: major connection spike during "source dumpfile.sql" By: Peter on Fri, 17 August 2007 06:22
	Re: major connection spike during "source dumpfile.sql" By: RichardBronosky on Sat, 18 August 2007 01:42

Previous Topic:	Benchmark needed: WHERE id='$id' ... vs. WHERE id=$id
Next Topic:	Difference between Falcon's and InnoDB's row level locking/MVCC

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]