[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16663689#comment-16663689 ] ASF GitHub Bot commented on IGNITE-9655: Github user asfgit closed the pull request at: https://github.com/apache/ignite/pull/4821 > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task > Components: yardstick >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > Fix For: 2.8 > > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range -with-/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16628783#comment-16628783 ] Pavel Kuznetsov commented on IGNITE-9655: - results on amazon 2 servers 2 clients (including 1 yardstick's driver client node). ||Configuration ||Avg (ops/sec)|| |sql-insert-delete-native-r1-1-backup |9,573.64| |sql-insert-delete-jdbc-thin-r1-1-backup|6,673.34| |sql-insert-delete-jdbc2-r1-1-backup|9,472.59| |sql-update-native-r1-1-backup |9,169.64| |sql-update-jdbc-thin-r1-1-backup |7,447.87| |sql-update-jdbc2-r1-1-backup |9,054.72| |sql-update-native-r1000-1-backup |279.71| |sql-update-jdbc-thin-r1000-1-backup|269.35| |sql-update-jdbc2-r1000-1-backup|284.23| |sql-update-1-backup|23,890.21| > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range -with-/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16626323#comment-16626323 ] ASF GitHub Bot commented on IGNITE-9655: GitHub user pavel-kuznetsov opened a pull request: https://github.com/apache/ignite/pull/4821 IGNITE-9655 DML benchmark suite (except selects) Created benchmark suite for updates and insert+deletes. Removed outdated benchmarks. You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-9655 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/4821.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #4821 commit 858426ca5b65262fde5e73d524caf9fa187637c8 Author: Pavel Kuznetsov Date: 2018-09-21T14:32:51Z ignite-9655: created configuration with my benchmarks. commit dce4e0ef3e5b6d0b95d27f246da1a13c6d0ce969 Author: Pavel Kuznetsov Date: 2018-09-23T23:20:56Z ignite-9655: updated benchmarks. Left questions in the end in comments. Use only native sql. commit 43f7495b248478b92a725a803021b3ca85c864bd Author: Pavel Kuznetsov Date: 2018-09-24T11:47:30Z ignite-9655: fixed extra ',' commit 0cda529d54cec967daee05328cde85103ee57416 Author: Pavel Kuznetsov Date: 2018-09-24T14:52:29Z ignite-9655: added other drivers. commit c93abcfb700f82d71e2920e16a5ce6aee86dba97 Author: Pavel Kuznetsov Date: 2018-09-24T15:44:07Z ignite-9655: removed duplicated -cl flag. commit a05f486a30be05c0c9080407a85df2ce763164ba Author: Pavel Kuznetsov Date: 2018-09-24T19:28:05Z ignite-9655: removed incorrect benchmarks (dml). Removed benchmarks from package org.apache.ignite.yardstick.cache.dml that don't have steady state. commit 7304a2ecc86d2fd02cca885de1252576edb1e659 Author: Pavel Kuznetsov Date: 2018-09-24T18:40:49Z ignite-9655: removed incorrect benchmarks (jdbc.store). Removed benchmarks from package org.apache.ignite.yardstick.cache.store.jdbc since they are not needed. > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range -with-/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625748#comment-16625748 ] Pavel Kuznetsov commented on IGNITE-9655: - After discussion to [~vozerov], deceided to include thick and thin drivers too. > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range with/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625614#comment-16625614 ] Pavel Kuznetsov commented on IGNITE-9655: - I think benchmark in this suite should prefer native sql (we've got groups of benchmarks that do the same, but via different APIs/drivers), because it has minimal overhead. > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range with/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625435#comment-16625435 ] Nikolay Izhikov commented on IGNITE-9655: - I don't want to provide PR for this ticket. Just a typo in PR description for another ticket. Sorry. > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range with/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-9655) SQL: Create benchmark suite for DML operations.
[ https://issues.apache.org/jira/browse/IGNITE-9655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16623857#comment-16623857 ] ASF GitHub Bot commented on IGNITE-9655: GitHub user nizhikov opened a pull request: https://github.com/apache/ignite/pull/4808 IGNITE-9655: fix for RPM build You can merge this pull request into a Git repository by running: $ git pull https://github.com/nizhikov/ignite IGNITE-9655 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/4808.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #4808 commit 562afac47e5933829eb939909178a9c4cbf63846 Author: Nikolay Izhikov Date: 2018-09-21T16:44:32Z IGNITE-9655: fix for RPM build > SQL: Create benchmark suite for DML operations. > --- > > Key: IGNITE-9655 > URL: https://issues.apache.org/jira/browse/IGNITE-9655 > Project: Ignite > Issue Type: Task >Reporter: Pavel Kuznetsov >Assignee: Pavel Kuznetsov >Priority: Major > > Create benchmark configuration that contains benchmark runs for DML > operations. > 1) insert + delete > 2) update (single, range with/without contention). > Currently we have benchmark code for 1 and 2 without contention. -- This message was sent by Atlassian JIRA (v7.6.3#76005)