nick at leippe.com
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 (127.0.0.1), 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