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

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

I added the max-allowed-packet line, but looks like it fails again (not
sure,because I didn't receive the log mail yet). My server blocks because it
has a load of 13,94 during the backup. Is there a way to do the backup in
low-priority to minimize the load?

2011/6/6 Wipe_Out <wip...@us...>

> Try adding something like --max_allowed_packet=100M to the OPT= line in
> the backup script and see if that helps things along..
>
> Also is there anything being reported in the logs?
>
>
>
> On 6 June 2011 10:41, Ward Loockx <wa...@lo...> wrote:
>
>> It contains VARCHARS, INT, timestamp, DATETIME.
>>
>> This is the size info about the table
>> Data 815,0 MB  Index 226,0 MB  Total 1,041,0 MB
>> The individual size of a row = 815.000Kb / 777263 records = 1.05kb /
>> record
>>
>>
>> 2011/6/6 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
>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>
>>
>
>
> ------------------------------------------------------------------------------
> 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
>
>