Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1686

batch update too slow

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • Icebox
    • ?
    • None

    Description

      1、TABLE COUNT

      MariaDB [xxxx]> select count from cdn_domain_province;
      ----------

      count

      ----------

      829097

      ----------
      1 row in set (0.06 sec)

      2、TABLE INFO

      CREATE TABLE `cdn_domain_province` (
      `did` int(11) NOT NULL DEFAULT 0,
      `protocol` varchar(6) NOT NULL DEFAULT '',
      `province` varchar(32) NOT NULL DEFAULT '',
      `isp` varchar(32) NOT NULL DEFAULT '',
      `bytes` bigint(20) NOT NULL DEFAULT 0,
      `reqs` bigint(20) NOT NULL DEFAULT 0,
      `tpr` int(11) NOT NULL DEFAULT 0,
      `time` bigint(20) NOT NULL DEFAULT 0,
      `channel` tinyint(4) NOT NULL DEFAULT 0 COMMENT ''
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8 COMMENT='' |

      3、QUERY

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              blank blank
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.