Re: alter table logging slow

2020-10-26 Thread Ilya Kasnacheev
Hello! Usually it is I/O bound, meaning, you can only speed it up by having more, faster disks. However, in some cases, tuning persistence settings such as checkpoint frequency, checkpoint page buffer size and checkpoint thread pool size may help. You can also try the direct-io module, but you

Re: alter table logging slow

2020-10-26 Thread Matteo Durighetto
Hello Ilya , thank you for your answer, it's make sense. I see the class called it's changewal and as you wrote, it's probably call a flush of the cache . Is it possible to speed up the flush to disk with more threads ? I think they are controlled by system pool or is it

Re: alter table logging slow

2020-10-26 Thread Ilya Kasnacheev
Hello! I guess it has to write all the data to disk. After 'alter table logging' returns, you are guaranteed consistency on this table, meaning all of its pages have to be persisted to disk. Obviously, it may take a lot of time if you have many gigabytes to flush. Regards, -- Ilya Kasnacheev

alter table logging slow

2020-10-26 Thread Matteo Durighetto
Hello, I found an expected behaviour on apache ignite. If you do ( TABLE partitioned with 1 backup and ATOMIC mode ): alter table .. nologging; set stream on ; .. loading a lot of data with jdbc .. .. close connection to flush data .. .. reopen connection.. alter table .. logging The