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. http://www.ivarch.com/programs/pv.shtml http://www.slashzero.com/2008/07/linux-commands-i-never-knew-existed-pipe- viewer/ It's in portage stable, apt unstable, and yum extras. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
