slow drop table

[Anung Basuki <an...@ovo.id>]

Hi All,

We are currently doing a POC of apache ignite:

Deployed in 10 bare metal servers each:
40vcores
256GB RAM

We got a table with 38 million rows, and when executing a drop table
statement, the query executes about an hour. How did this happen? Any idea
how to improve the drop table performance?

BR,
Anung

Re: [EXTERNAL] Re: slow drop table

[Anung Basuki <an...@ovo.id>]

Hi Alex,

Thank you for replying.
We gave Ignite 128gb heap space, and there is no other table beside that
sample table.
We will try some of the optimizations from the guide, will update later

Thanks,
Anung

On Tue, May 11, 2021 at 2:12 AM akorensh <al...@gmail.com> wrote:

> Hi,
>   You need to examine the logs to see where the delay is.
>    Check that you have enough memory, and that the system is not thrashing
> (constantly going to disk to retrieve data).
>
>     Look into Garbage Collector logs to get more insight into your app
> performance.
> see:
>
> https://ignite.apache.org/docs/latest/perf-and-troubleshooting/troubleshooting#detailed-gc-logs
>
>   Follow these production release tips:
>
> https://ignite.apache.org/docs/latest/perf-and-troubleshooting/general-perf-tips
>
>
>
> https://ignite.apache.org/docs/latest/perf-and-troubleshooting/memory-tuning
>
>
>
> https://ignite.apache.org/docs/latest/perf-and-troubleshooting/troubleshooting
> Thanks, Alex
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: slow drop table

[akorensh <al...@gmail.com>]

Hi,
  You need to examine the logs to see where the delay is.
   Check that you have enough memory, and that the system is not thrashing
(constantly going to disk to retrieve data).

    Look into Garbage Collector logs to get more insight into your app
performance.
see:
https://ignite.apache.org/docs/latest/perf-and-troubleshooting/troubleshooting#detailed-gc-logs

  Follow these production release tips:
https://ignite.apache.org/docs/latest/perf-and-troubleshooting/general-perf-tips

 
https://ignite.apache.org/docs/latest/perf-and-troubleshooting/memory-tuning

 
https://ignite.apache.org/docs/latest/perf-and-troubleshooting/troubleshooting
Thanks, Alex



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/