Extra visible measurements in my database (since 1.3?)


#1

Just updated to influxdb-1.5.1-1.x86_64 on CentOS7

show databases
name: databases
name


_internal
collections

use collections
Using database collections
show measurements
name: measurements
name


ceph_value
collectd
cq
database
disk_io_time
disk_read
disk_value
disk_weighted_io_time
disk_write
freeipmi_value
httpd
interface_rx
interface_tx
ipmi_value
queryExecutor
runtime
shard
subscriber
syslog
tsm1_cache
tsm1_engine
tsm1_filestore
tsm1_wal
write

Why do I see here the measurements that are also listed in the database _internal?
Afaik I did not create nor the collectd that i am running these tables:

collectd
cq
database
httpd
queryExecutor
runtime
shard
subscriber
tsm1_cache
tsm1_engine
tsm1_filestore
tsm1_wal
write

Can I delete these??? Or disable something because this collectd looks to be archiving some submission results.

select * from collectd limit 10;
name: collectd
time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail


1522108800000000000 89831 73 :25826 34864023147 80502429 db1 0 446023336 445656311 0
1522108810000000000 89832 73 :25826 34864349502 80503188 db1 0 446027573 445661311 0
1522108820000000000 89833 73 :25826 34864755447 80504138 db1 0 446032740 445666311 0
1522108830000000000 89834 73 :25826 34865150001 80505039 db1 0 446037788 445671311 0
1522108840000000000 89835 73 :25826 34865589527 80506062 db1 0 446043405 445676311 0
1522108850000000000 89836 73 :25826 34865929143 80506868 db1 0 446047738 445681311 0
1522108860000000000 89837 73 :25826 34866306691 80507656 db1 0 446052713 445686311 0
1522108870000000000 89838 73 :25826 34866695525 80508509 db1 0 446057748 445690873 0
1522108880000000000 89839 73 :25826 34867109195 80509445 db1 0 446063098 445695873 0
1522108890000000000 89


#2

Hello!

Same is happening to me. I have few databases, all of them with few series, but one with thousands:

influx_inspect report . output:

Statistics
Series:
- bas2290 (est): 2 (0%)
- _internal (est): 17546 (99%)
- bas2293 (est): 47 (0%)
- bas2295 (est): 29 (0%)
- bas1157 (est): 9 (0%)
- bas2291 (est): 20 (0%)
- bas2294 (est): 17141 (97%) <--------------------------------
- bas2289 (est): 11 (0%)
- bas2292 (est): 30 (0%)
Total (est): 17667

If I investigate a bit more (not so much, not an expert) I find those same _internal measurements, which are recreated even if I drop them:

cq
database
httpd
queryExecutor
runtime
shard
subscriber
tsm1_cache
tsm1_engine
tsm1_filestore
tsm1_wal
write

I suspect this has something to do with the insane number of series.

Any help would be appreciated,
David.