Tema: Re: db backup be downtime
Autorius: ABLomas
Data: 2009-07-26 19:41:39
On 2009.07.26 17:29, Laimis wrote:
>> Yra DB ~5GB su ~10M irasu
>> Darant per tarkim mysqldump backup'a uzlockinamos lenteles todel 
>> svetaine nustoja funkcionuoti (kaupiasi insertai, updeitai kol gaunam 
>> too many connections)
>>
>> Kaip to isvengti ?
> 
> --single-transaction --quick
> (innodb)

Arba naudot mysqlhotcopy MyISAM'ui. Tas aišku nepašalins tos lockinimo 
problemos, bet - 5GB yra nedaug, tai galima sukopijuoti per keliolika 
sekundžių (jei diskai normalūs), o jei dar "pasmulkinus" gabalais per 
lenteles - gaunas ir visai normaliai ;-)
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser
+Debian Eth ownershipo keitimasDuimaN2009-08-20 18:55
+Input nukreipimasDonatas2009-08-20 11:42
+lt domenainerijus2009-08-19 14:21
+squid ir dansguardlens2009-08-18 20:10
SambaValentinas2009-08-18 10:07
+spamas is saves paciomeandog2009-08-17 10:47
Negaliu pakeisti rusu koduote i "phonetic"Donatas2009-08-16 03:38
Q: koks yra soft'as sysadmin'ui,Ingodas Vytrastas2009-08-12 12:36
+Freebsd portupgrade on Freebsdatlaikes antanas2009-08-11 16:25
+sendmail smtptOMZY2009-08-11 10:56
+USB web kameros ir komandine eilute.Levas2009-08-06 19:19
+jabber serveris ant centos 5.2stakka2009-08-06 18:33
+Q: ext3 klaidoskrx2009-08-04 10:54
+Wi-fi signalo stiprinimasolis2009-08-03 16:16
kaip paziuret original mac?locked2009-08-03 09:30
+iptables apacheSleepy2009-07-30 09:43
+sysadmine Juoze - atsiliepk!johnrembo2009-07-29 22:41
+audio transliavimasnoname2009-07-29 12:44
+apie postfixemnt2009-07-28 18:51
-db backup be downtimeAWeX2009-07-26 15:14
Re: db backup be downtimeLaimis2009-07-26 17:29
Re: db backup be downtimeABLomas2009-07-26 19:41
Re: db backup be downtimeVaidas Zlotkus2009-07-27 01:02
+del proxy ant hostingoAgent2009-07-25 01:12
WEB PHP filemanagerSleepy2009-07-24 11:45
+Sumasciau as cia upgreida...Levas2009-07-22 20:27
+CRMPluss2009-07-22 08:42
Fluendo kodekaiAndrius2009-07-19 13:11
+squid url_rewrite_programSigun2009-07-15 11:46
+Mac fontaim.k.2009-07-14 07:59
+pureftpd quota messageemnt2009-07-10 10:36
+del dnsazuolas2009-07-09 02:31
+lt spellingtobias2009-07-07 11:42
+BayesSleepy2009-07-07 09:18
+News readeris koks populiariausias ant ubuntuTuzas2009-07-02 09:27
+Kaip Ubuntu pakeisti ekrano rezoliuciją?-Lameris-2009-07-01 17:42
+Trendnet USB printserveris TE100-P1UMarius2009-06-29 08:44
+vpn hw -linuxMarius2009-06-25 14:56
+gnome remote filesSleepy2009-06-23 20:16
+prašau padėti Marius2009-06-19 16:16
+El. pasto archyvavimasKestas2009-06-15 11:08
+geriausias ir lengviausiai suprantamas/sukonfiguruojams userio stebejimo softas.Levas2009-06-12 21:28
+Q: Squid'as ir diferenciavimas LT/užsieniskrx2009-06-12 13:07
+Q: kas darosi su ameba.sc-uni.ktu.lt ?Ingodas Vytrastas2009-06-09 15:27
+Pan 0.132Zvaigzdzius2009-06-08 21:11
apartamentos apto casa 3 quartos 3qts em jardim camburi 0272272337apartamento 3 quartos jardim camburi2009-06-06 20:02
+raid + debianvaikis-paikis2009-06-04 12:07