corporatepiyush

#!/bin/sh

# touch /etc/profile.d/malloc_config.sh

# Get total RAM size in MB
total_ram=$(free -m | awk '/^Mem:/{print $2}')

if [ "$total_ram" -lt 8192 ]; then
    # Low RAM settings
    export MALLOC_ARENA_MAX=2

corporatepiyush

# System V shared memory parameters
kernel.shmmax = 1048576
kernel.shmmin = 1
kernel.shmmni = 128
kernel.shmseg = 32
kernel.shmall = 4096

# IPC parameters
net.core.somaxconn = 8192
fs.file-max = 1048576

corporatepiyush

// ignore_for_file: prefer_function_declarations_over_variables

import 'dart:async';
import 'dart:collection';
import 'dart:convert';
import 'dart:io';
import 'dart:typed_data';
import 'package:basics/basics.dart';
import 'package:quiver/cache.dart';

corporatepiyush

const pg = require('pg-promise')();
const fs = require('fs');

const db = pg({
    user: "****",
    password: "*****",
    host: "******",
    port: 5432,
    database: "*****",
    ssl: {

corporatepiyush

# Protection from Malicious Domain (ads, malware, hack scripts, fakenews and gambling )
# You may not be doing it but various apps installed on your system doing it internally, so having ad blocker in Browser does not helps.
# Execute below command in your terminal once every week.

sudo chmod 774 /etc/hosts
 
curl https://raw.githubusercontent.com/StevenBlack/hosts/master/alternates/fakenews-gambling-porn/hosts > hosts

sudo mv hosts /etc/hosts

corporatepiyush

package main

import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"net"
	"os"
	"time"

corporatepiyush

CREATE TABLE rollups (
  name text,
  rolled_up_generation bigint default -1
);

-- Create a stub on workers to allow usage as a default in distributed tables
SELECT run_command_on_workers($$
CREATE OR REPLACE FUNCTION current_rollup_generation(rollup_name text)
RETURNS bigint LANGUAGE sql
AS $function$

corporatepiyush

-- Create the raw events table
CREATE TABLE page_views (
    site_id int,
    path text,
    client_ip inet,
    view_time timestamptz default now(),
    view_id bigserial
);

-- Allow fast lookups of ranges of sequence IDs

corporatepiyush

// suppose you spawned 16 node processes on 16 core CPU

ps axf | grep node | grep -v grep | awk '{print $1}' | xargs -n 1 taskset -cp 0-15

corporatepiyush

/* commands to run on the coordinator */

CREATE EXTENSION citus;
SELECT master_add_node('10.0.0.2', 5432);
SELECT master_add_node('10.0.0.3', 5432);
SELECT start_metadata_sync_to_node(nodename, nodeport) FROM pg_dist_node;
SET citus.replication_model TO 'streaming'

CREATE TABLE events (
  event_id bigserial primary key,