Skip to content

Instantly share code, notes, and snippets.

View uso5's full-sized avatar
🍉

Michal Ustanik uso5

🍉
View GitHub Profile
@uso5
uso5 / npm link sip-service.sh
Last active March 9, 2023 07:54
LOCAL - Link sip service with phone with ng clean
@uso5
uso5 / sample_data_companies.sql
Last active August 25, 2021 09:57
sample_data_companies
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
@uso5
uso5 / query.sql
Last active June 18, 2021 11:53
Performance schema useful queries
# Locked threads
SELECT * FROM `events_waits_current` LIMIT 0,10000;
# top used queries with UPDATE and their percentage
SELECT
digest_text,
count_star / update_total * 100 as percentage_of_all
FROM events_statements_summary_by_digest,
( SELECT sum(count_star) update_total
FROM events_statements_summary_by_digest
@uso5
uso5 / mysql.conf
Last active June 21, 2021 14:11
Performance schema mysql.conf init
performance_schema=1
performance_schema_events_waits_history_size=50
performance_schema_events_waits_history_long_size=15000
performance_schema_instrument=’%=OFF’
performance_schema_consumer_events_stages_current=1
performance_schema_consumer_events_stages_history=1
performance_schema_consumer_events_stages_history_long=0
performance_schema_consumer_events_statements_current=0
performance_schema_consumer_events_statements_history=0
performance_schema_consumer_events_statements_history_long=0
const masterkey = 'your-master-key';
// base64 decoding
const bData = Buffer.from(decoded, 'base64');
// convert data to buffers
const ivlen = 12;
const iv = bData.slice(0, ivlen);
const taglen = 16;