[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [linux_var] problema mysql

To: linux_var - LUG di Varese e Provincia Mailing List <talking@ml.linuxvar.it>
Subject: Re: [linux_var] problema mysql
From: Alessandro Lorenzi <alorenzi@alorenzi.eu>
Date: Sun, 06 Nov 2016 18:30:33 +0100
Authentication-results: linuxvar.it; dkim=pass reason="1024-bit key; unprotected key" header.d=alorenzi.eu header.i=@alorenzi.eu header.b=gxlz5yjc; dkim-adsp=pass; dkim-atps=neutral
Delivered-to: diegor@tiscali.it
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ml.linuxvar.it; s=mail; t=1478453439; bh=DfWRVJ90r/6cDZhCMewwxYQKiHpGIeYYAdE8XrMbMkg=; h=In-Reply-To:References:From:Date:To:Subject:List-Id: List-Unsubscribe:List-Archive:List-Post:List-Help:List-Subscribe: Reply-To; z=In-Reply-To:=20<CAGod1SAA9kbOVcamEB7xyWwWQk3T5ZxXr-JTNMBtVno6k1xU QQ@mail.gmail.com>|References:=20<20161104154248.dcf0de84552d51b30 f4beb46@gmx.co.uk>=0D=0A=20<d43b72c5-6482-57e6-e5b8-ddc51e3644c2@g mail.com>=0D=0A=20<CAHFzxniXCF09t=3DxVzAnT0ViGQ+AODa8jDZtx0cL_Cs3a 5=3De9JQ@mail.gmail.com>=0D=0A=20<a0994efb-7f74-e38a-8f7d-f799dc28 9be6@gmail.com>=0D=0A=20<CAHFzxnhx7schT20eMjpLMHqR4EcO0G=3D60FstNf Ey8_TUMzm8iQ@mail.gmail.com>=0D=0A=20<CAHFzxnid6OGsdD_nvbn0LF-j7We khXpHaO5HkezT6qnrq31qkA@mail.gmail.com>=0D=0A=20<CAHFzxniRheYZMk_W sdSHtew_mQsr2pNfGmaaiWLdJSfp2X-jkw@mail.gmail.com>=0D=0A=20<CAGod1 SBAqWMRZ_zCDtQ0bH2nAjmUsqYLPYg0giwmjM2YkNu6HA@mail.gmail.com>=0D=0 A=20<CAGod1SAx=3DYM+4Df6hh+Fg=3DSw_DEpeG+xff4ycBY2gYo5QnXDFA@mail. gmail.com>=0D=0A=20<CAGod1SABc_gzEM4U9V8oLp9Ud-gsht2FZ4zbXwez1UBrE 67WLg@mail.gmail.com>=0D=0A=20<20161105134849.GA5446@alorenzi-dell .lorenzi.lan>=0D=0A=20<CAGod1SAA9kbOVcamEB7xyWwWQk3T5ZxXr-JTNMBtVn o6k1xUQQ@mail.gmail.com>|From:=20Alessandro=20Lorenzi=20<alorenzi@ alorenzi.eu>|Date:=20Sun,=2006=20Nov=202016=2018:30:33=20+0100|To: =20linux_var=20-=20LUG=20di=20Varese=20e=20Provincia=20Mailing=20L ist=20<talking@ml.linuxvar.it>|Subject:=20Re:=20[linux_var]=20prob lema=20mysql|List-Id:=20linux_var=20-=20LUG=20di=20Varese=20e=20Pr ovincia=20Mailing=20List=0D=0A=20<talking.ml.linuxvar.it>|List-Uns ubscribe:=20<http://ml.linuxvar.it/cgi-bin/mailman/options/talking >,=0D=0A=20<mailto:talking-request@ml.linuxvar.it?subject=3Dunsubs cribe>|List-Archive:=20<http://ml.linuxvar.it/pipermail/talking/>| List-Post:=20<mailto:talking@ml.linuxvar.it>|List-Help:=20<mailto: talking-request@ml.linuxvar.it?subject=3Dhelp>|List-Subscribe:=20< http://ml.linuxvar.it/cgi-bin/mailman/listinfo/talking>,=0D=0A=20< mailto:talking-request@ml.linuxvar.it?subject=3Dsubscribe>|Reply-T o:=20linux_var=20-=20LUG=20di=20Varese=20e=20Provincia=20Mailing=2 0List=0D=0A=20<talking@ml.linuxvar.it>; b=ik5Wps3Ra4SUJ2L66QPlUrYxtDhhD7Ufgh1hWNtoVlZSknLL6FHgyxqI6xVma5jHS JYNdf9nLQFTRe92SfJu9yJwl1EdYfL9HCCurrMmXN+bMWUXS5YGvV0HchDw/4PwrWB th0VxKr0vKy1GkiKoshuSimX1h8zh6n6P6NsEb/s=
Dkim-signature: a=rsa-sha256; v=1; c=relaxed/relaxed; d=alorenzi.eu; q=dns/txt; s=mx; t=1478453435; h=Message-ID: To: Date: From: Subject: Content-Type: Content-Transfer-Encoding: MIME-Version: References: In-Reply-To: Sender; bh=F8TtSKcUMu1NLw0+HGlyz4Anlat+6aT8Eyji9liYrsw=; b=gxlz5yjctsv1OwZlS9Xdje8rWCwp697BjBQ9+DFG6eqMyfaqWZqqB5vu/OFt8ZA61dkmxwIb HB5kDPGgfMOnBXk+3yA2K+OZFogwHIWiZ2dFLQRIaif2loX294uW6zSPdC6AbE7HizK/Rr9l 0G3UG31drG54RBbbpJc9n0QBUrY=
Domainkey-signature: a=rsa-sha1; c=nofws; d=alorenzi.eu; s=mx; q=dns; h=Sender: In-Reply-To: References: MIME-Version: Content-Transfer-Encoding: Content-Type: Subject: From: Date: To: Message-ID; b=SeBqMFGo7JNNXBAiSkjr5wEPF+yHDbGSsC5xhRDNEFxPmz/wfsakuNSxlOvxNfjLZHylB+ zSZONHD8MFc6AHiUOVBkGo74YtzUFHXyDGl8h1nipfaWAtwCBHOTIuH41dxyPZahpHk5N3+r HPt79V6fv/1bhoEQba1Tj3nHZmYQU=
In-reply-to: <CAGod1SAA9kbOVcamEB7xyWwWQk3T5ZxXr-JTNMBtVno6k1xUQQ@mail.gmail.com>
List-archive: <http://ml.linuxvar.it/pipermail/talking/>
List-help: <mailto:talking-request@ml.linuxvar.it?subject=help>
List-id: linux_var - LUG di Varese e Provincia Mailing List <talking.ml.linuxvar.it>
List-post: <mailto:talking@ml.linuxvar.it>
List-subscribe: <http://ml.linuxvar.it/cgi-bin/mailman/listinfo/talking>, <mailto:talking-request@ml.linuxvar.it?subject=subscribe>
List-unsubscribe: <http://ml.linuxvar.it/cgi-bin/mailman/options/talking>, <mailto:talking-request@ml.linuxvar.it?subject=unsubscribe>
References: <20161104154248.dcf0de84552d51b30f4beb46@gmx.co.uk> <d43b72c5-6482-57e6-e5b8-ddc51e3644c2@gmail.com> <CAHFzxniXCF09t=xVzAnT0ViGQ+AODa8jDZtx0cL_Cs3a5=e9JQ@mail.gmail.com> <a0994efb-7f74-e38a-8f7d-f799dc289be6@gmail.com> <CAHFzxnhx7schT20eMjpLMHqR4EcO0G=60FstNfEy8_TUMzm8iQ@mail.gmail.com> <CAHFzxnid6OGsdD_nvbn0LF-j7WekhXpHaO5HkezT6qnrq31qkA@mail.gmail.com> <CAHFzxniRheYZMk_WsdSHtew_mQsr2pNfGmaaiWLdJSfp2X-jkw@mail.gmail.com> <CAGod1SBAqWMRZ_zCDtQ0bH2nAjmUsqYLPYg0giwmjM2YkNu6HA@mail.gmail.com> <CAGod1SAx=YM+4Df6hh+Fg=Sw_DEpeG+xff4ycBY2gYo5QnXDFA@mail.gmail.com> <CAGod1SABc_gzEM4U9V8oLp9Ud-gsht2FZ4zbXwez1UBrE67WLg@mail.gmail.com> <20161105134849.GA5446@alorenzi-dell.lorenzi.lan> <CAGod1SAA9kbOVcamEB7xyWwWQk3T5ZxXr-JTNMBtVno6k1xUQQ@mail.gmail.com>
Reply-to: linux_var - LUG di Varese e Provincia Mailing List <talking@ml.linuxvar.it>
Sender: "Talking" <talking-bounces@ml.linuxvar.it>
User-agent: K-9 Mail for Android


On 5 November 2016 16:22:52 CET, Giovanni Orlandi <orlangio@gmail.com> wrote:.
>
>Per inciso, con myisam ho sempre trovato 3 file per ogni tabella
>dentro la directory-db
>che contenevano (ad occhio) i dati, la struttura, gli indici. Copiati
>quelli, tabella salva.
>
>Invece con innodb c'è un enorme file nella directory var lib mysql
>e quando il filesistem si corrompe ho perso tutto.
>

Vero, però si può abilitare innodb_file_per_table per separare le tabelle si file diversi. Non ho mai capito perché sia disabilitato di default visto che ha più vantaggi che svantaggi. 

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
_______________________________________________
Talking mailing list
Talking@ml.linuxvar.it
http://ml.linuxvar.it/cgi-bin/mailman/listinfo/talking

References:
- Re: [linux_var] problema mysql
  - From: Riccardo Macoratti <r.macoratti@gmx.co.uk>
- Re: [linux_var] problema mysql
  - From: Cristian Gaiatto <g.crinux@gmail.com>
- Re: [linux_var] problema mysql
  - From: Roberto Zedda <zedrob@gmail.com>
- Re: [linux_var] problema mysql
  - From: Cristian Gaiatto <g.crinux@gmail.com>
- Re: [linux_var] problema mysql
  - From: Roberto Zedda <zedrob@gmail.com>
- Re: [linux_var] problema mysql
  - From: Giovanni Orlandi <orlangio@gmail.com>
- Re: [linux_var] problema mysql
  - From: Alessandro Lorenzi <alorenzi@alorenzi.eu>
- Re: [linux_var] problema mysql
  - From: Giovanni Orlandi <orlangio@gmail.com>

Prev by Date: Re: [linux_var] problema mysql
Next by Date: Re: [linux_var] lettore smartcard
Previous by thread: Re: [linux_var] problema mysql
Next by thread: Re: [linux_var] problema mysql
Index(es):
- Date
- Thread