Oleksii Samoliuk YouSysAdmin

## mysql-memoryusage.sh
#!/bin/sh
# you might want to add some user authentication here
mysql -e "show variables; show status" | awk '
{
VAR[$1]=$2
}
END {
MAX_CONN = VAR["max_connections"]
MAX_USED_CONN = VAR["Max_used_connections"]
BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]

## phpenv_macos.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              4 stars
            
          
                YouSysAdmin
                / phpenv_macos.md
            
            
              Created
              September 21, 2022 08:15
            
          
    PHPENV + MacOS

Install PHPENV

https://github.com/phpenv/phpenv
Install additional pkg's

brew install \
    autoconf \
 bzip2 \


## remove_old_builds.sql
-- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite
-- Enable to delete logs by cascading delete
PRAGMA foreign_keys = ON;

WITH n_build_ids_per_repo as (
  SELECT build_id
  FROM (
    SELECT
      build_id,
      build_repo_id,

## run-before-shutdown.service
# systemd unit file
# /etc/systemd/system/run-before-shutdown.service
# TimeoutStartSec - set a timeout for your task or set "0" to disable.
#                   When the timeout is turned off and the task "hangs",
#                   the process will never be interrupted and the system
#                   shutdown will stop
# Before - Specify the services before which the task should run

# after add unit file in systemd/system catalogue, "run systemctl daemon-reload"
# and enable new service "systemctl enable run-before-shutdown.service"

## hackthebox.go
package main

import (
	"bytes"
	"encoding/base64"
	"encoding/json"
	"fmt"
	"io/ioutil"
	"log"
	"net/http"

## postgresql_cron_env.sh
# .cron_env
# Save to /root directory, chmod 400/600
export DB_HOST="127.0.0.1"
export DB_USER="postgres"
export DB_PASSWORD="postgres"

# cron
59 23 * * * . /root/.cron_env; /usr/bin/psql_super_puper.sh $DB_USER $DB_PASSWORD $DB_HOST "select * from ololo"

## sploite.go
package main

import (
	"fmt"
	"net/http"

	"github.com/julienschmidt/httprouter"
)

func main() {

## appconfig.rb
// config/initializers/appconfig.rb
APP_CONFIG = YAML.load_file(Rails.root.join('config/app_config.yml'))[Rails.env]

## verse.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              1 star
            
          
                YouSysAdmin
                / verse.md
            
            
              Last active
              March 5, 2016 23:20
            
              
                Стишок :)
              
          
    Я узнал, что у меня

Есть огромная семья

Puma, Rails, Redis,

Linux, Cisco,

Сиськи, печенюшки.

Даже Twitter у меня

как огромная семья

Это все мое родное

Это воздух для меня,

Всех люблю на свете я!

  
## ogv2gif.sh
mplayer -ao null out.ogv -vo jpeg:outdir=output
convert output/* output.gif
convert output.gif -fuzz 10% -layers Optimize optimised.gif
	#!/bin/sh
	# you might want to add some user authentication here
	mysql -e "show variables; show status" \| awk '
	{
	VAR[$1]=$2
	}
	END {
	MAX_CONN = VAR["max_connections"]
	MAX_USED_CONN = VAR["Max_used_connections"]
	BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]
	-- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite
	-- Enable to delete logs by cascading delete
	PRAGMA foreign_keys = ON;

	WITH n_build_ids_per_repo as (
	SELECT build_id
	FROM (
	SELECT
	build_id,
	build_repo_id,
	# systemd unit file
	# /etc/systemd/system/run-before-shutdown.service
	# TimeoutStartSec - set a timeout for your task or set "0" to disable.
	# When the timeout is turned off and the task "hangs",
	# the process will never be interrupted and the system
	# shutdown will stop
	# Before - Specify the services before which the task should run

	# after add unit file in systemd/system catalogue, "run systemctl daemon-reload"
	# and enable new service "systemctl enable run-before-shutdown.service"
	package main

	import (
	"bytes"
	"encoding/base64"
	"encoding/json"
	"fmt"
	"io/ioutil"
	"log"
	"net/http"
	# .cron_env
	# Save to /root directory, chmod 400/600
	export DB_HOST="127.0.0.1"
	export DB_USER="postgres"
	export DB_PASSWORD="postgres"

	# cron
	59 23 * * * . /root/.cron_env; /usr/bin/psql_super_puper.sh $DB_USER $DB_PASSWORD $DB_HOST "select * from ololo"
	// config/initializers/appconfig.rb
	APP_CONFIG = YAML.load_file(Rails.root.join('config/app_config.yml'))[Rails.env]
	mplayer -ao null out.ogv -vo jpeg:outdir=output
	convert output/* output.gif
	convert output.gif -fuzz 10% -layers Optimize optimised.gif