IronManZ

## clickhouse-get-tables-size.sql
SELECT table,
    formatReadableSize(sum(bytes)) as size,
    min(min_date) as min_date,
    max(max_date) as max_date
    FROM system.parts
    WHERE active
GROUP BY table

## elasticsearch.md

      
              1 file
            
          
              11 forks
            
          
                2 comments
              
            
              29 stars
            
          
                kkc
                / elasticsearch.md
            
            
              Last active
              December 29, 2023 00:39
            
              
                Elasticsearch performance tuning
              
          
    ##TUNING##
Configuration

System:
set file descriptors to 32K or 64K
vim /etc/security/limit.conf


## elasticsearch-handlers-main.yml
---
###
# Elasticsearch Rolling restart using Ansible
###

##
## Why is this needed?
##
#
# Even if you use a serial setting to limit the number of nodes processed at one
	SELECT table,
	formatReadableSize(sum(bytes)) as size,
	min(min_date) as min_date,
	max(max_date) as max_date
	FROM system.parts
	WHERE active
	GROUP BY table
	---
	###
	# Elasticsearch Rolling restart using Ansible
	###

	##
	## Why is this needed?
	##
	#
	# Even if you use a serial setting to limit the number of nodes processed at one