nstrappazzonc

Custom keyboard mapping

• Re-Map Grave key to Esc for fucking touch bar in the Macbook Pro.
• Change second display brightness and contrast with fn + 3 to 7.
• Launcher applications: Activity Monitor, Firefox, iTerm and Spotify.
• Select area to take screenshot.
• Lock session.
• Paste without format.

Requirements

nstrappazzonc

ProxySQL Commands

Servers

Add

The server require fill two tables; mysql_replication_hostgroups and mysql_servers. The first table define who is use for write and who is for reads, and the id number for each, for example any master: [10, 20, 30, 40] and all slave: [11, 12, 13, 21, 22, 23]. The second table is for the server list associated with mysql_replication_hostgroups.

nstrappazzonc

VIM shortcuts and tips

My personal guidelines, and only added shortcuts tested by myself.

• Edit remote file
• Delete specific line via terminal
• Related Links

Moving

nstrappazzonc

Linux commands for DBA

Collections the commands combinations to manipulate data:

• Insert a string after every N lines
• Output from a file starting from a specific line
• Build many SQL sentence from .csv file
• Convert single column into multiple columns
• Extract a number from a string
• Ignore empty lines

nstrappazzonc

MySQL queries for DBA

Tables size

SELECT table_schema as "Database",
       table_name AS "Table", 
       round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

nstrappazzonc

tmux shortcuts

My personal guidelines, and only added shortcuts tested by myself.

• Install
• Command Line
• Keys
• Configuration
• Misc
• Windows

nstrappazzonc

_ssh_completions()
{
  cur="${COMP_WORDS[COMP_CWORD]}"
  opts=$(grep '^Host' ~/.ssh/config ~/.ssh/config.d/* 2>/dev/null | grep -v '[?*]' | cut -d ' ' -f 2-)
  COMPREPLY=($(compgen -W "${opts}" -- ${cur}))
}

complete -F _ssh_completions s

s() {