All posts tagged mysql

Create Index mysql

ALTER TABLE bocaodientu ADD INDEX `filename` (`filename`); ALTER TABLE bocaodientu_dangkymoi ADD INDEX `bchash` (`bchash`);

Kill all php, nginx, mysql processes

To kill all PHP Processes kill $(ps aux | grep ‘[p]hp’ | awk ‘{print $2}’) To kill all Nginx Processes kill $(ps aux | grep ‘[n]ginx’ | awk ‘{print $2}’) To kill all MySQL Processes kill $(ps aux | grep ‘[m]ysql’ | awk ‘{print $2}’)