Code Related

Real world examples of code and tricks

February 19, 2024

List all processes with process ID that use a port

List open files

# List open files is usefull for many things including:
lsof -i :80  // list open files that use the port  80 A.K.A processes that use the port 80

lsof /folder  // list open files (processes orginating) in folder 

lsof -p 1080  // list open files used by process id in this case 1080

lsof -u user // open files by specific user

■ ■ □ ■ ■ ■ □ □ ■
July 17, 2018

PHP UNIT Coverage

phpunit –coverage-html coverage

■ ■ □ ■ ■ ■ □ □ ■
May 21, 2018

Create alias in ubuntu server

Add aliases in bash_aliases

 
sudo nano  ~/.bash_aliases

alias declaration format:

 
alias commandname='command you will alias'

ex:

 
alias taillog='tail -f var/log/error.log'

 

to activate defined aliases run

 
source ~/.bashrc
■ ■ □ ■ ■ ■ □ □ ■
March 18, 2018

Installing PostgreSQL

First step:


 	sudo apt-get update
 	sudo apt-get install postgresql postgresql-contrib

Second step:

logging in 

sudo -u postgres psql

Creating user

$ sudo -u postgres createuser <username>

Creating Database

$ sudo -u postgres createdb <dbname>

Giving the user a password

$ sudo -u postgres psql
psql=# ALTER USER <username> with encrypted password '<password>';

Granting privileges on database


psql=# GRANT ALL PRIVILEGES ON DATABASE <dbname> to <username> ;
■ ■ □ ■ ■ ■ □ □ ■
February 1, 2018

Laravel Migration

To create a migration in laravel you can use the make:migration

Lets create a comments table:

 

 
php artisan make:migration create_comments_table  --create=comments

(more…)

■ ■ □ ■ ■ ■ □ □ ■
December 21, 2017

Resize SWAP

//Make all swap off
sudo swapoff -a

//Resize
sudo dd if=/dev/zero of=/swapfile bs=1M count=1024

//Swapfile usable
sudo mkswap /swapfile

//Swapon again
sudo swapon /swapfile
■ ■ □ ■ ■ ■ □ □ ■
November 20, 2017

Delete files with 0 bites

find . -name 'file*' -size 0 -print0 | xargs -0 rm
■ ■ □ ■ ■ ■ □ □ ■
November 14, 2017

Create SWAP on LINUX SERVER

free -m
mkdir -p /var/_swap_
cd /var/_swap_
#Here, 1M * 2000 ~= 2GB of swap memory
dd if=/dev/zero of=swapfile bs=1M count=2000
mkswap swapfile
swapon swapfile
chmod 600 swapfile
echo "/var/_swap_/swapfile none swap sw 0 0" >> /etc/fstab
#cat /proc/meminfo
free -m
■ ■ □ ■ ■ ■ □ □ ■
February 6, 2017

Mysql query performance

select * from sys.statement_analysis
ORDER BY `statement_analysis`.`avg_latency` ASC
■ ■ □ ■ ■ ■ □ □ ■