[MCOL-1484] Use condition pushdown in I_S tables Created: 2018-06-19  Updated: 2020-08-25  Resolved: 2018-06-28

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.1.6

Type: New Feature Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-1081 Improve performance of system catalog Closed
Sprint: 2018-13

 Description   

A sub-task for MCOL-1081 to be implemented in 1.1. Condition pushdowns in the I_S tables to accelerate the performance of the tables, especially when only a subset if information is needed.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-06-19 ]

For QA: call columnstore_info.table_usage() with a schema and/or table should be much faster.

Comment by Daniel Lee (Inactive) [ 2018-06-28 ]

Build verified: 1.1.6-1 source

[root@localhost ~]# cat mariadb-columnstore-1.1.6-1-centos7.x86_64.bin.tar.gz.txt
/root/columnstore/mariadb-columnstore-server
commit 1741c7e7d522d1245ec9c1e4c7c7474574f09bd2
Merge: 2adc4b5 6abef48
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Tue Jun 19 09:51:48 2018 -0500

Merge pull request #113 from mariadb-corporation/davidhilldallas-patch-3

update readme

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit c4e9b0ce3a396edd2353eb44532336e9db857f86
Merge: ac45350 ffb76bb
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Jun 27 17:36:13 2018 -0500

Merge pull request #511 from mariadb-corporation/MCOL-1467-1

MCOL-1467 - changes to get back to 1.1.6

Timing is 4 times faster than 1.1.5-1

1.1.6-1

MariaDB [(none)]> call columnstore_info.table_usage(NULL,NULL);
-----------------------------------------------------------------

TABLE_SCHEMA TABLE_NAME DATA_DISK_USAGE DICT_DATA_USAGE TOTAL_USAGE

-----------------------------------------------------------------

mytest orders 392.07 MB 132.02 MB 524.09 MB

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

1.1.5-1

MariaDB [(none)]> call columnstore_info.table_usage(NULL,NULL);
-----------------------------------------------------------------

TABLE_SCHEMA TABLE_NAME DATA_DISK_USAGE DICT_DISK_USAGE TOTAL_USAGE

-----------------------------------------------------------------

mytest orders 392.07 MB 132.02 MB 524.09 MB

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

Generated at Thu Feb 08 02:29:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.