which is being constantly written to or is it
based on the concept what file should be idle for some time and when it is
going to be defragmented
Let me know if you have any information on these
--
Peter Zaitsev, CEO, Percona
Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev
--
To unsubscribe
rtin Raiber wrote:
>>> Hi,
>>>
>>> On 08.02.2017 03:11 Peter Zaitsev wrote:
>>>> Out of curiosity, I see one problem here:
>>>> If you're doing snapshots of the live database, each snapshot leaves
>>>> the database files like killing
ete database from time to time, only then it's safe to remove all
binlogs up to that point in time.
--
Regards,
Kai
On Tue, Feb 7, 2017 at 9:00 AM, Hugo Mills <h...@carfax.org.uk> wrote:
> On Tue, Feb 07, 2017 at 08:53:35AM -0500, Peter Zaitsev wrote:
>> Hi,
>>
>
total csum
bytes: 302861376 total tree bytes: 4492017664 total fs tree bytes:
1496743936 total extent tree bytes: 2126643200 btree space waste
bytes: 1389440305 file data blocks allocated: 345977790464 referenced
288756027392
Let me know if you have any ideas how to troubleshoot
--
Peter Zaitsev, CE
re at
> most 20% of RAM, which is an insane amount of data to buffer before starting
> writeback when you're talking about systems with 16GB of RAM.
>
--
Peter Zaitsev, CEO, Percona
Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev
--
To unsubscribe from this list: send the lin
Hi Hugo,
As I re-read it closely (and also other comments in the thread) I know
understand there is a difference how nodatacow works even if snapshot are
in place.
On autodefrag I wonder is there some more detailed documentation about how
autodefrag works.
The manual
more levers to pull if you're
having some troubles.
On Tue, Feb 7, 2017 at 1:27 PM, Jeff Mahoney <je...@suse.com> wrote:
> On 2/7/17 8:53 AM, Peter Zaitsev wrote:
>> Hi,
>>
>> I have tried BTRFS from Ubuntu 16.04 LTS for write intensive OLTP MySQL
>> Workload.
>
n upstream kernels which affect your workload. There's
> an Ubuntu kernel PPA you can use to get the new kernels without too
> much pain.
--
Peter Zaitsev, CEO, Percona
Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev
--
To unsubscribe from this list: send the line "uns
ecommended in some places is "nodatacow" this however defeats
the main purpose I'm looking at BTRFS - I am interested in "free"
snapshots which look very attractive to use for database recovery scenarios
allow instant rollback to the previous state.
--
Peter Zaitsev, CEO, Percona