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?
More information about the PLUG