12065
81%
master: 87%

Ran 11 May 2018 05:39PM UTC

Jobs 1

Files 347

Run time 40s

Badge

Embed ▾

pending completion

Build # 12065

Build Type

push

travis-ci

Committed by

Korablev77

Commit Message

sql: move SQL statistics to server

SQLite provides kind of statistics concerning data holding in each index
and space. It is used to help query planner build optimized plan. Such
statistics don't depend on internal index implementation (e.g. B-tree or
LSM tree) and contain information concerning tuple distribution.
This patch moves members responsible statistics from original SQLite
structs to Tarantool ones. To be more precise, now index's opts contains
statistics from _stat1 space (arrays of integers and their logarithm
approximation) and more sophisticated one from _stat4 (array of samples).
It also contains set of flags to turn on/off different optimizations
(such as skip-scan).

After ANALYZE command is executed, statistics are saved into _sql_stat1
and _sql_stat4 spaces (in order to persist them). However, it should also
be loaded into in-memory structs representing indexes. This patch
reworks original SQLite routine to load it directly to newly introduced
stat struct of index.

It is worth mentioning that during update of statistics occurs according
to 'everything or nothing' policy: firstly, it is allocated on the
region. Then, if there is enough memory for stats of ALL indexes it is
copied to the heap. Otherwise, region is truncated and no changes take
place.

Closes #3253

Run Details

60833 of 75376 relevant lines covered (80.71%)

1501890.92 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
3	12065.3 (TARGET=coverage)	11 May 2018 05:39PM UTC	347	80.71	Travis Job 12065.3

Source Files on build 12065

Coverage	∆	File	Lines	Relevant	Covered	Missed	Hits/Line

tarantool / tarantool / 12065
81%
master: 87%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12065

tarantool / tarantool / 12065 81% master: 87%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12065

tarantool / tarantool / 12065
81%
master: 87%

README BADGES
x