throttling mysqldump

Nicholas Leippe nick at
Mon Dec 29 16:31:19 MST 2008

On Monday 29 December 2008 04:22:38 pm Nicholas Leippe wrote:
> On Monday 29 December 2008 04:06:20 pm Ryan Byrd wrote:
> > So, let's say there is this centos box is running a mysql database
> > that has db tables that are pretty big, (some > 1x10^6 rows)
> >
> > and when one runs mysqldump on the database, it spikes the load
> > average, as reported by top, on the box to about 15
> >
> > this box also is running apache
> >
> > when the load average spikes to 10, apache pages are SLOW to load.
> >
> > how can one throttle the mysqldump so it doesn't use as many system
> > resources?
> Well, if you force it to use tcp (, then you could set up tc
> rules for it and do it within the network layer.
> Over unix pipes, I don't know. I recall seeing an application like dd once
> that could rate limit a pipe, but I don't remember what it was.
> You could probably whip something up in perl or bash pretty easily to
> buffer it and limit it though.

Found it. It's called pipe viewer, the command is pv.

It's in portage stable, apt unstable, and yum extras.

More information about the PLUG mailing list