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

[Wipe_Out <wip...@us...>]

What data is in the table thats failing?
--Just alphanumeric text fields?
--or something else?

How big is the table? (MB)
How big are the individual rows of data?



On 6 June 2011 07:32, Ward Loockx <wa...@lo...> wrote:

> 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
>>>
>>>
>>
>
>
> ------------------------------------------------------------------------------
> 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
>
>