Skip to content

Instantly share code, notes, and snippets.

View MurzNN's full-sized avatar
🎯
Focusing

Alexey Murz Korepov MurzNN

🎯
Focusing
View GitHub Profile
@MurzNN
MurzNN / element-web-update.sh
Last active October 21, 2021 16:43
element-web-update.sh - bash script for auto-update web version of Element IM to latest version from GitHub vector-im/element-web project releases
#!/bin/bash
###################################################################
# Script for check new version of Element from github
# and download new version, if update is avaiable
#
# https://gist.github.com/MurzNN/ee64f98ab2e71b886c41d55594e5dd9e
#
###################################################################
@MurzNN
MurzNN / trace.json
Created June 2, 2020 09:52
Chromium ticount test - trace.json
{"traceEvents":[
{"args":{"name":"CrGpuMain"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546918,"tid":546918,"ts":0},
{"args":{"name":"CrRendererMain"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546940,"tid":546940,"ts":0},
{"args":{"name":"CrBrowserMain"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546901,"tid":546901,"ts":0},
{"args":{"name":"Chrome_ChildIOThread"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546918,"tid":546936,"ts":0},
{"args":{"name":"Chrome_IOThread"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546901,"tid":546907,"ts":0},
{"args":{"name":"ThreadPoolForegroundWorker"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546918,"tid":546931,"ts":0},
{"args":{"name":"Chrome_ChildIOThread"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546940,"tid":546947,"ts":0},
{"args":{"name":"ThreadPoolForegroundWorker"},"cat":"__metadata","name":"thread_name","ph":"M","pid":546940,"tid":546946,"ts":0},
{"args":{"name":"ThreadPoolForeg
@MurzNN
MurzNN / fTXAwIMe5PiohWcL9xDPC.json
Last active June 9, 2020 03:31
mbalabash/estimo test 1 - ticount chrome 79
{"traceEvents":[{"pid":323769,"tid":323783,"ts":51107471893,"ph":"X","cat":"toplevel","name":"ThreadPool_RunTask","dur":310,"tdur":305,"tts":1909,"args":{"src_file":"../../services/tracing/public/cpp/perfetto/task_runner.cc","src_func":"PostTask"}},
{"pid":323769,"tid":323783,"ts":51107472525,"ph":"X","cat":"toplevel","name":"ThreadPool_RunTask","dur":40,"tdur":39,"tts":2535,"args":{"src_file":"../../services/tracing/public/cpp/perfetto/task_runner.cc","src_func":"PostTask"}},
{"pid":323769,"tid":323783,"ts":51107474809,"ph":"X","cat":"toplevel","name":"ThreadPool_RunTask","dur":44,"tdur":44,"tts":2628,"args":{"src_file":"../../services/tracing/public/cpp/perfetto/task_runner.cc","src_func":"PostTask"}},
{"pid":323769,"tid":323783,"ts":51107488988,"ph":"X","cat":"toplevel","name":"ThreadPool_RunTask","dur":92,"tdur":93,"tts":2746,"args":{"src_file":"../../services/tracing/public/cpp/perfetto/task_runner.cc","src_func":"PostTask"}},
{"pid":323769,"tid":323783,"ts":51107594127,"ph":"M","cat":"__metadata","name"
@MurzNN
MurzNN / synapse-db-fix-duplicates.sql
Last active January 11, 2021 06:44
Fix duplicated rows in Synapse PostgreSQL database
# ERROR:  could not create unique index "current_state_events_room_id_type_state_key_key"
# DETAIL:  Key (room_id, type, state_key)=(!JoceisEAQRNMtpWVGm:matrix.org, m.room.member, @_oftc_haagch:matrix.org) is duplicated.
SELECT
room_id, type, state_key,
COUNT( * )
FROM
current_state_events
GROUP BY
room_id, type, state_key
HAVING
@MurzNN
MurzNN / .xbindkeysrc
Created February 21, 2021 16:26
Changing keyboard layout in Linux KDE + Electron apps via Alt+Shift workaround
# Add this to file in home folder
"~/bin/layout-switch.sh"
Alt + Shift_L
@MurzNN
MurzNN / overpass_countries_geom_3.json
Created November 16, 2021 08:12
Overpass Countries geom limit 3
This file has been truncated, but you can view the full file.
{
"version": 0.6,
"generator": "Overpass API 0.7.57 93a4d346",
"osm3s": {
"timestamp_osm_base": "2021-11-16T08:09:42Z",
"copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL."
},
"elements": [
$ cat .ddev/.ddev-docker-compose-base.yaml
version: '3.6'
#ddev-generated
services:
db:
container_name: ddev-${DDEV_SITENAME}-db
build:
context: './.dbimageBuild'
args:
$ ddev debug test
Running bash [-c /tmp/test_ddev.sh]
OS Information: Linux kubuntu 5.15.0-43-generic #46-Ubuntu SMP Tue Jul 12 10:30:17 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
User information: uid=999(kubuntu) gid=998(docker) groups=998(docker),4(adm),24(cdrom),27(sudo),30(dip),46(plugdev),122(lpadmin),132(lxd),133(sambashare),999(kubuntu)
DDEV version: ITEM VALUE
DDEV version v1.21.1
architecture amd64
db drud/ddev-dbserver-mariadb-10.4:v1.20.0
dba phpmyadmin:5
ddev-ssh-agent drud/ddev-ssh-agent:v1.20.0