12075
81%
master: 87%

Ran 14 May 2018 11:13AM UTC

Jobs 1

Files 347

Run time 18s

Badge

Embed ▾

pending completion

Build # 12075

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

60834 of 75369 relevant lines covered (80.71%)

1513349.66 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
3	12075.3 (TARGET=coverage)	14 May 2018 11:13AM UTC	347	80.71	Travis Job 12075.3

Source Files on build 12075

Coverage	∆	File	Lines	Relevant	Covered	Missed	Hits/Line

tarantool / tarantool / 12075
81%
master: 87%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12075

tarantool / tarantool / 12075 81% master: 87%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12075

tarantool / tarantool / 12075
81%
master: 87%

README BADGES
x