Re: BTRFS and databases

2018-08-02 Thread Martin Raiber
On 02.08.2018 14:27 Austin S. Hemmelgarn wrote: > On 2018-08-02 06:56, Qu Wenruo wrote: >> >> On 2018年08月02日 18:45, Andrei Borzenkov wrote: >>> >>> Отправлено с iPhone >>> 2 авг. 2018 г., в 10:02, Qu Wenruo написал(а): > On 2018年08月01日 11:45, MegaBrutal wrote: > Hi all,

BTRFS and databases

2018-08-02 Thread Remi Gauvin
On 2018-08-02 03:07 AM, Qu Wenruo wrote: > For data, since we have cow (along with csum), it should be no problem > to recover. > > And since datacow is used, transaction on each device should be atomic, > thus we should be able to handle one-time device out-of-sync case. > (For multiple

Re: BTRFS and databases

2018-08-02 Thread Austin S. Hemmelgarn
On 2018-08-02 06:56, Qu Wenruo wrote: On 2018年08月02日 18:45, Andrei Borzenkov wrote: Отправлено с iPhone 2 авг. 2018 г., в 10:02, Qu Wenruo написал(а): On 2018年08月01日 11:45, MegaBrutal wrote: Hi all, I know it's a decade-old question, but I'd like to hear your thoughts of today. By

Re: BTRFS and databases

2018-08-02 Thread Qu Wenruo
On 2018年08月02日 18:45, Andrei Borzenkov wrote: > > > Отправлено с iPhone > >> 2 авг. 2018 г., в 10:02, Qu Wenruo написал(а): >> >> >> >>> On 2018年08月01日 11:45, MegaBrutal wrote: >>> Hi all, >>> >>> I know it's a decade-old question, but I'd like to hear your thoughts >>> of today. By now, I

Re: BTRFS and databases

2018-08-02 Thread Qu Wenruo
On 2018年08月02日 18:35, Andrei Borzenkov wrote: > > > Отправлено с iPhone > >> 2 авг. 2018 г., в 12:16, Martin Steigerwald написал(а): >> >> Hugo Mills - 01.08.18, 10:56: On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: I know it's a decade-old question, but I'd like to

Re: BTRFS and databases

2018-08-02 Thread Andrei Borzenkov
Отправлено с iPhone > 2 авг. 2018 г., в 10:02, Qu Wenruo написал(а): > > > >> On 2018年08月01日 11:45, MegaBrutal wrote: >> Hi all, >> >> I know it's a decade-old question, but I'd like to hear your thoughts >> of today. By now, I became a heavy BTRFS user. Almost everywhere I use >> BTRFS,

Re: BTRFS and databases

2018-08-02 Thread Martin Steigerwald
Andrei Borzenkov - 02.08.18, 12:35: > Отправлено с iPhone > > > 2 авг. 2018 г., в 12:16, Martin Steigerwald > > написал(а):> > > Hugo Mills - 01.08.18, 10:56: > >>> On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: > >>> I know it's a decade-old question, but I'd like to hear your >

Re: BTRFS and databases

2018-08-02 Thread Andrei Borzenkov
Отправлено с iPhone > 2 авг. 2018 г., в 12:16, Martin Steigerwald написал(а): > > Hugo Mills - 01.08.18, 10:56: >>> On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: >>> I know it's a decade-old question, but I'd like to hear your >>> thoughts >>> of today. By now, I became a heavy

Re: BTRFS and databases

2018-08-02 Thread ein
On 08/02/2018 11:16 AM, Martin Steigerwald wrote: > However I wonder: Is this it? Is there nothing that can be improved in > BTRFS to handle database and VM files in a better way, without altering > any default settings? Poor performance is not the biggest BTRFS problem, it's known for silent

Re: BTRFS and databases

2018-08-02 Thread Martin Steigerwald
Hugo Mills - 01.08.18, 10:56: > On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: > > I know it's a decade-old question, but I'd like to hear your > > thoughts > > of today. By now, I became a heavy BTRFS user. Almost everywhere I > > use BTRFS, except in situations when it is obvious

Re: BTRFS and databases

2018-08-02 Thread Qu Wenruo
On 2018年08月01日 22:33, Remi Gauvin wrote: > On 2018-07-31 11:45 PM, MegaBrutal wrote: > >> I know that with nodatacow, I take away most of the benefits of BTRFS >> (those are actually hurting database performance – the exact CoW >> nature that is elsewhere a blessing, with databases it's a

Re: BTRFS and databases

2018-08-02 Thread Qu Wenruo
On 2018年08月01日 11:45, MegaBrutal wrote: > Hi all, > > I know it's a decade-old question, but I'd like to hear your thoughts > of today. By now, I became a heavy BTRFS user. Almost everywhere I use > BTRFS, except in situations when it is obvious there is no benefit > (e.g. /var/log, /boot). At

Re: BTRFS and databases

2018-08-01 Thread Remi Gauvin
On 2018-07-31 11:45 PM, MegaBrutal wrote: > I know that with nodatacow, I take away most of the benefits of BTRFS > (those are actually hurting database performance – the exact CoW > nature that is elsewhere a blessing, with databases it's a drawback). > But are there any advantages of still

Re: BTRFS and databases

2018-08-01 Thread Adam Borowski
On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: > But there is still one question that I can't get over: if you store a > database (e.g. MySQL), would you prefer having a BTRFS volume mounted > with nodatacow, or would you just simply use ext4? > > I know that with nodatacow, I take

Re: BTRFS and databases

2018-08-01 Thread Mike Fleetwood
On 1 August 2018 at 04:45, MegaBrutal wrote: > But there is still one question that I can't get over: if you store a > database (e.g. MySQL), would you prefer having a BTRFS volume mounted > with nodatacow, or would you just simply use ext4? > > I know that with nodatacow, I take away most of

Re: BTRFS and databases

2018-08-01 Thread Hugo Mills
On Wed, Aug 01, 2018 at 05:45:15AM +0200, MegaBrutal wrote: > I know it's a decade-old question, but I'd like to hear your thoughts > of today. By now, I became a heavy BTRFS user. Almost everywhere I use > BTRFS, except in situations when it is obvious there is no benefit > (e.g. /var/log,

Re: BTRFS and databases

2018-08-01 Thread Duncan
MegaBrutal posted on Wed, 01 Aug 2018 05:45:15 +0200 as excerpted: > But there is still one question that I can't get over: if you store a > database (e.g. MySQL), would you prefer having a BTRFS volume mounted > with nodatacow, or would you just simply use ext4? > > I know that with nodatacow,

BTRFS and databases

2018-07-31 Thread MegaBrutal
Hi all, I know it's a decade-old question, but I'd like to hear your thoughts of today. By now, I became a heavy BTRFS user. Almost everywhere I use BTRFS, except in situations when it is obvious there is no benefit (e.g. /var/log, /boot). At home, all my desktop, laptop and server computers are