Skip to content

Instantly share code, notes, and snippets.

Avatar
💭
🇫🇷 🇯🇵 🇺🇸

Francois-Clement Brossard renshuki

💭
🇫🇷 🇯🇵 🇺🇸
24 followers · 35 following
View GitHub Profile
@renshuki
renshuki / ubuntu_agnoster_install.md
Last active February 3, 2023 01:56
Ubuntu 16.04 + Terminator + Oh My ZSH with Agnoster Theme
View ubuntu_agnoster_install.md

Install Terminator (shell)

sudo add-apt-repository ppa:gnome-terminator
sudo apt-get update
sudo apt-get install terminator

Terminator should be setup as default now. Restart your terminal (shortcut: "Ctrl+Alt+T").

Install ZSH

@renshuki
renshuki / painless_script_compare_current_date_with_index_date.md
Created October 16, 2019 08:57
Elasticsearch - Painless script to compare the current date with a date already indexed into a document
View painless_script_compare_current_date_with_index_date.md

Elasticsearch Painless script which aims to calculate the difference in days between a date indexed into a document and the current date.

GET days_compare/_search
{
  "script_fields": {
    "diffdate": {
      "script": {
        "lang":   "painless",
 "source": """
@renshuki
renshuki / kibana_err_cert_common_name_invalid.md
Created May 19, 2022 07:17
Kibana NET::ERR_CERT_COMMON_NAME_INVALID error
View kibana_err_cert_common_name_invalid.md

If you get a NET::ERR_CERT_COMMON_NAME_INVALID when trying to connect to Kibana from your browser, it means the CN and/or SAN you defined at the certificate generation is incorrect. Please refer to the Encrypt traffic between your browser and Kibana documentation for more details on how to properly generate a server certificate for Kibana.

@renshuki
renshuki / elasticsearch-threadpool-size-details.md
Last active May 10, 2022 13:30
Elasticsearch threadpool size details using _cat/thread_pool API
View elasticsearch-threadpool-size-details.md

Run GET _cat/thread_pool?v&h=node_name,name,max,pool_size,size,type,queue_size

Gives you details on Elasticsearch threadpool size, type, queue_size.

Example output

node_name           name                                    max pool_size size type                  queue_size
instance-0000000009 analyze                                             0    1 fixed                         16
instance-0000000009 ccr                                                32   32 fixed                        100
@renshuki
renshuki / wordpress_tag_search.md
Last active November 1, 2021 18:42
Wordpress SQL query to find posts having both tags
View wordpress_tag_search.md

Please replace TAG ID 1 and TAG ID 2 by the tags you are looking for.

SELECT p.id
FROM wp_posts AS p
JOIN wp_term_relationships AS tr ON p.id = tr.object_id
JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms AS t ON tt.term_id = t.term_id
WHERE t.term_id=_TAG ID 1_ OR t.term_id=_TAG ID 2_ AND p.post_type LIKE 'post'
GROUP BY p.id
@renshuki
renshuki / elasticsearch_filedatavisualizer_geopoint_ingest_pipeline_conversion.md
Created September 27, 2019 11:05
Elasticsearch CSV import via File Data Visualizer (ML) - Convert latitude and longitude column to geo_point using ingest pipeline
View elasticsearch_filedatavisualizer_geopoint_ingest_pipeline_conversion.md
  1. Choose your CSV file to import including your coordinates data and upload it

location.csv

lat,long, timestamp
41.12,-71.34,1569476964
38.85896,-106.01665,1569476964
65.47629,18.61576,1569476964
@renshuki
renshuki / kibana-legacy-data-table-visualization.md
Created August 13, 2021 04:35
Enable Kibana legacy data table visualization (prior to EUI datagrid)
View kibana-legacy-data-table-visualization.md

Add vis_type_table.legacyVisEnabled: true to kibana.yml

@renshuki
renshuki / elasticsearch_slowlog_for_all_indices.md
Created May 11, 2019 08:51
How to enable slowlogs for all indices and tweak slowlog logger level
View elasticsearch_slowlog_for_all_indices.md

Slowlog thresholds for all indices

Add slowlog thresholds for all indices

PUT /_all/_settings 
{
"index.search.slowlog.threshold.query.warn": "10s",
"index.search.slowlog.threshold.query.info": "5s",
"index.search.slowlog.threshold.query.debug": "2s",
@renshuki
renshuki / logstash-output-elasticsearch-bulk-request-size-monitoring.md
Created June 25, 2021 06:03
Logstash - output.elasticsearch bulk requests size monitoring hack
View logstash-output-elasticsearch-bulk-request-size-monitoring.md

Command:

tcpdump -A 'tcp port 9200 and (tcp[((tcp[12:1] & 0xf0) >> 2):4] = 0x504f5354)' -i lo0 | egrep -A 5 -i "POST /_bulk"

Expected output (w/ Content-Length):

...U...5POST /_bulk HTTP/1.1
Connection: Keep-Alive
@renshuki
renshuki / elasticsearch-adjust-scoring.md
Created June 25, 2021 03:25
Elasticsearch - Curation of resources / methods to adjust scoring in Elasticsearch
View elasticsearch-adjust-scoring.md