matheus-santos

REM Creating symbolic links in Windows OS
REM PREFIX = /D, /H, /J
REM DESTINY_PATH = Path to linked file/folder
REM ORIGIN_PATH = Path to original file/folder
REM e.g.: mklink /J C:\Vagrant\Project C:\Users\Matheus\Documents\Workspace\Project

mklink /PREFIX %DESTINY_PATH% %ORIGIN_PATH%

matheus-santos

SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

show variables where variable_name = 'general_log';
set global general_log = 0;

select count(*) from mysql.general_log;

matheus-santos

Do you have a GitHub URL you'd like to shorten? Use Git.io!

$ curl -i https://git.io -F "url=https://github.com/..."
HTTP/1.1 201 Created
Location: https://git.io/abc123

$ curl -i https://git.io/abc123
HTTP/1.1 302 Found
Location: https://github.com/...

matheus-santos

[
    {
        "code": "001",
        "name": "Banco do Brasil",
        "short_name": "BB",
        "jurisdiction": "Federal",
        "website": "www.bb.com.br"
    },
    {
        "code": "002",

matheus-santos

<style type="text/css">
.wrap {
  display: flex;
  align-items: center;
  justify-content: center;
}

.item {
  max-width: 50%;
}

matheus-santos

import time


class Timer(object):

    verbose = False  # Debug mode
    start_value = 0  # Start time
    msecs = 0  # Diff in milliseconds

    def __init__(self, verbose=False):

matheus-santos

#!/bin/sh
# Author: Matheus Cesário <mts.cesario@gmail.com>
# Description: Killing all slow queries from bd
# Example: sh kill_them_all.sh -s 100

# Variables
SECONDS=0  # Seconds
USER=""  # DB user
PASSWORD=""  # DB password
HOST=""  # DB host

matheus-santos

tar stores relative paths by default. GNU tar even says so if you try to store an absolute path:

# Create .tar file (with gzip)
tar -zcvf foo.tar /home/foo

# Have a look at what's in the tar file:
tar -tvf foo.tar

# Extracting file from tar file
tar -xvf foo.tar home/foo/bar # Note: no leading slash

matheus-santos

find -name "*.txt" -size -2k -delete

matheus-santos

# Looking for large files
sudo find / -type f -size +1G -exec ls -lh {} \;