[jira] [Updated] (IGNITE-6843) SQL: Optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Summary: SQL: Optionally do not use WAL when executing CREATE INDEX (was: SQL: optionally do not use WAL when executing CREATE INDEX) > SQL: Optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov >Priority: Major > Labels: iep-19, performance > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When the index is ready, force a checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Labels: iep-19 performance (was: performance) > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov >Priority: Major > Labels: iep-19, performance > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When the index is ready, force a checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Labels: performance (was: iep-1 performance) > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov >Priority: Major > Labels: performance > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When the index is ready, force a checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Fix Version/s: (was: 2.4) > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov >Assignee: Kirill Shirokov > Labels: iep-1, performance > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When the index is ready, force a checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Puchnin updated IGNITE-6843: --- Description: Inspired by Oracle {{NOLOGGING}} option [1]. When an index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates during an index_create operation are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, the index should be marked as "invalid", and not used for queries. Then the user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 was: Inspired by Oracle {{NOLOGGING}} option [1]. When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates during an index_create operation are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When index is ready, force checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Puchnin updated IGNITE-6843: --- Description: Inspired by Oracle {{NOLOGGING}} option [1]. When an index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates during an index_create operation are not written to WAL 2) When the index is ready, force a checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, the index should be marked as "invalid", and not used for queries. Then the user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 was: Inspired by Oracle {{NOLOGGING}} option [1]. When an index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates during an index_create operation are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, the index should be marked as "invalid", and not used for queries. Then the user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > Inspired by Oracle {{NOLOGGING}} option [1]. > When an index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When the index is ready, force a checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, the index should be marked as "invalid", and not > used for queries. Then the user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Puchnin updated IGNITE-6843: --- Description: Inspired by Oracle {{NOLOGGING}} option [1]. When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates during an index_create operation are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 was: Inspired by Oracle {{NOLOGGING}} option [1]. When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > Inspired by Oracle {{NOLOGGING}} option [1]. > When index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates during an index_create operation are not written to WAL > 2) When index is ready, force checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, index should be marked as "invalid", and not used > for queries. Then user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Description: Inspired by Oracle {{NOLOGGING}} option [1]. When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 was: When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL: 1) Index updates are not written to WAL 2) When index is ready, force checkpoint and wait for it to happen 3) Purge index data if node crashed before checkpoint Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it. > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > Inspired by Oracle {{NOLOGGING}} option [1]. > When index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates are not written to WAL > 2) When index is ready, force checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, index should be marked as "invalid", and not used > for queries. Then user should either re-create or rebuild it. > [1] > https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm#i2182589 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX
[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Ozerov updated IGNITE-6843: Labels: iep-1 performance (was: ) > SQL: optionally do not use WAL when executing CREATE INDEX > -- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql >Affects Versions: 2.3 >Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > When index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates are not written to WAL > 2) When index is ready, force checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, index should be marked as "invalid", and not used > for queries. Then user should either re-create or rebuild it. -- This message was sent by Atlassian JIRA (v6.4.14#64029)