throttling mysqldump

Ryan Byrd ryanbyrd at gmail.com
Mon Dec 29 16:06:20 MST 2008


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?

-r



More information about the PLUG mailing list