mysql qcache enabling

/etc/my.cnf

tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-type               = 1
query-cache-size               = 32M
max-connections                = 500
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 4096
table-open-cache               = 4096

Openvz notes

Migrate container between nodes

vzmigrate --live REMOTE-IP LOCAL-CTID

For example

vzmigrate --live -v 192.168.5.5 413

Quotas

Disk quota
vzctl set CTID --diskspace 45G:49G --save

Ram quota
vzctl set CTID --ram 3G --swap 2048M --save

firewalld allow ports

Check rules

# firewall-cmd --state

Get default zone

# firewall-cmd --get-default-zone

Add allowed ports

# firewall-cmd --zone=public --add-port=50000-51000/tcp

Add permanent allowed ports

# firewall-cmd --zone=public --permanent --add-port=50000-51000/tcp

Check ports and services

# firewall-cmd --zone=public --permanent --list-services
# firewall-cmd --zone=public --permanent --list-ports

Add custom service

# firewall-cmd --zone=public --permanent --add-service=https
# firewall-cmd --zone=public --permanent --add-service=smtp
# firewall-cmd --zone=public --permanent --add-service=imap

After all changes need apply rules

# firewall-cmd --reload

git notes

Git, delete all deleted files

# git rm $(git ls-files --deleted)

Switch to other branch

# git branches
  Master
  Dev1
* Dev2

# git checkout Master
Branch Master set up to track remote branch Master from origin.
Switched to a new branch 'Master'

# git branches
* Master
  Dev1
  Dev2

Mysql / MariaDB check tables engine

SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbname' AND engine = 'MyISAM';


Where dbname - database name
And InnoDB - engine, you can use InnoDB


Convert MyISAM tables to InnoDB

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,' ENGINE=InnoDB;')
FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE'

Then run result as SQL query

For example:

 ALTER TABLE databasename.tablename ENGINE=InnoDB;

How to check server IP behind cloudflare / узнать IP сервера за cloudflare

nmap --script dns-brute -sn example.com

nmap -sV -sS -F example.com

ubuntu utopic 14.04 sourses.list

deb http://mirror.mirohost.net/ubuntu/ trusty main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty main restricted

deb http://mirror.mirohost.net/ubuntu/ trusty-updates main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates main restricted

deb http://mirror.mirohost.net/ubuntu/ trusty universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty universe
deb http://mirror.mirohost.net/ubuntu/ trusty-updates universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates universe

deb http://mirror.mirohost.net/ubuntu/ trusty multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty multiverse
deb http://mirror.mirohost.net/ubuntu/ trusty-updates multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-updates multiverse

deb http://mirror.mirohost.net/ubuntu/ trusty-backports main restricted universe multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-backports main restricted universe multiverse

deb http://mirror.mirohost.net/ubuntu/ trusty-security main restricted
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security main restricted
deb http://mirror.mirohost.net/ubuntu/ trusty-security universe
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security universe
deb http://mirror.mirohost.net/ubuntu/ trusty-security multiverse
deb-src http://mirror.mirohost.net/ubuntu/ trusty-security multiverse

deb http://archive.canonical.com/ubuntu trusty partner

deb http://extras.ubuntu.com/ubuntu trusty main
deb-src http://extras.ubuntu.com/ubuntu trusty main
deb http://archive.getdeb.net/ubuntu trusty-getdeb apps

check processlist from swap

for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{ print ""}' $file; done | sort -k 2 -n -r | less

MariaDB enable slow logs

MariaDB [(none)]> SET GLOBAL slow_query_log = 'ON';
MariaDB [(none)]> set global slow_query_log_file = '/var/log/mariadb/slow.log';

mysql create user and db with privileges

> create database newdb;

 > GRANT ALL PRIVILEGES ON newdb . * TO 'newusername'@'localhost'  IDENTIFIED BY 'PASS';

> flush privileges;

// Change user password 

> SET PASSWORD FOR 'newusername'@'hostname' = PASSWORD('new-password');

> flush privileges;