throttling mysqldump

William Attwood wattwood at gmail.com
Mon Dec 29 16:18:16 MST 2008


You may also try just tarballing the entire data folder for MySQL; may be
faster if you have that much data to export.
-Will

On Mon, Dec 29, 2008 at 4:11 PM, William Attwood <wattwood at gmail.com> wrote:

> Hmmm.  You can set the MySQLDump memory usage in your MySQL Configuration
> file.  [mysqldump]
> quick
> max_allowed_packet = 16M
>
>
> That should help with the processor load spike, hopefully.
>
> -Will
>
>
> On Mon, Dec 29, 2008 at 4:06 PM, Ryan Byrd <ryanbyrd at gmail.com> 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?
>>
>> -r
>>
>> /*
>> PLUG: http://plug.org, #utah on irc.freenode.net
>> Unsubscribe: http://plug.org/mailman/options/plug
>> Don't fear the penguin.
>> */
>>
>
>



More information about the PLUG mailing list