Re: [Automysqlbackup-users] Mysqlbackup fails an brings the server down

[Ward L. <wa...@lo...>]

I see that mysqlhotcopy is only available for myIsam and currently we use
innoDB tables..

Do you have another solution?

2011/6/2 Ward Loockx <wa...@lo...>

> Hello,
>
> Thanks for the reply. I have control over the mysql settings. I'll also
> take a look at mysqlhotcopy.
>
>
> 2011/6/2 Wipe_Out <wip...@us...>
>
>> Hi,
>>
>> It could be an issue with the server running out of memory while dumping
>> that large table.. The --opt switch is used which should disable memory
>> buffering when its dumping the database but perhaps its something else.. It
>> could also be that the table is being locked for a long time which is
>> causing a problem for your website..
>>
>> Are you able to change the MySQL server settings? eg buffers etc..
>>
>> An alternative would be to not use the script to backup that database and
>> instead use the mysqlhotcopy command which may work better for a larger
>> database thats always active..
>>
>>
>>
>> Does seem strange because
>>
>> On 2 June 2011 08:44, Ward Loockx <wa...@lo...> wrote:
>>
>>> Hello,
>>>
>>> I currently use automysqlbackup to backup 10databases. There is one big
>>> database that contains a table with +- 780.000records. When mysqlbackup
>>> executes it fails (on that table) and brings my websites down (maybe the
>>> load is so high that apache processes can't answer in time). Looks like
>>> there are a lot of query's executed at the moment of backup and maybe the
>>> query's are locking each other.
>>>
>>> I also get the following by email:
>>>
>>> mysqldump: Error 2013: Lost connection to MySQL server during query when
>>> dumping table `video` at row: 745740
>>>
>>> I think this are 2seperate problems:
>>>
>>>    - Mysql backup script failing
>>>    - Website's are down (because the use of too many resources?)
>>>
>>>
>>> Do you guys have any ideas how to fix this? Can you let the script run in
>>> low priority mode, so that it doesn't eat the resources and does not lock
>>> any tables ?
>>>
>>> Thanks!
>>> Ward
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Simplify data backup and recovery for your virtual environment with
>>> vRanger.
>>> Installation's a snap, and flexible recovery options mean your data is
>>> safe,
>>> secure and there when you need it. Data protection magic?
>>> Nope - It's vRanger. Get your free trial download today.
>>> http://p.sf.net/sfu/quest-sfdev2dev
>>> _______________________________________________
>>> Automysqlbackup-users mailing list
>>> Aut...@li...
>>> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Simplify data backup and recovery for your virtual environment with
>> vRanger.
>> Installation's a snap, and flexible recovery options mean your data is
>> safe,
>> secure and there when you need it. Discover what all the cheering's about.
>>
>> Get your free trial download today.
>> http://p.sf.net/sfu/quest-dev2dev2
>> _______________________________________________
>> Automysqlbackup-users mailing list
>> Aut...@li...
>> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users
>>
>>
>