NATHAN242's Projects
Projects
Tools
Libraries
Web Tools
Shows Apache status in a way similar to the "top" utility.
Run it as root via the "watch" command:
sudo watch ./apachetop.sh
Output:
HTTPD PROCESSES: 8 SOCKETS -- ESTAB: 0 WAIT: 0 FIN: 0 LISTEN: 0
Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
HTTP/1.1
HTTP/1.1
GET
GET
6-0 4494 0/9/9 W 0.00 0 0 0.0 0.00 0.00 ::1 127.0.1.1 /server-status
5-0 4263 0/2/2 _ 0.00 306 0 0.0 0.00 0.00 127.0.0.1 127.0.1.1 /css/style.css
4-0 3721 0/17/17 _ 0.00 254 0 0.0 0.01 0.01 127.0.0.1 127.0.1.1 NULL
3-0 3720 0/11/11 _ 0.00 90 0 0.0 0.01 0.01 127.0.0.1 127.0.1.1 NULL
2-0 3719 0/19/19 _ 0.00 141 0 0.0 0.01 0.01 127.0.0.1 127.0.1.1 NULL
1-0 3718 0/10/10 _ 0.00 167 0 0.0 0.00 0.00 127.0.0.1 127.0.1.1 NULL
0-0 3717 0/14/14 _ 0.00 173 0 0.0 0.01 0.01 127.0.0.1 127.0.1.1 NULL
Shows information about the MySQL query cache.
Usage:
./mysql_cache_utilization.sh [SOCKET] [USER] (optional)[PASSWORD]
Output:
=== MYSQL CACHE UTILIZATION === Query_cache_size: 16777216 Com_select: 74 Qcache_hits: 0 Qcache_inserts: 0 Qcache_not_cached: 71 Qcache_free_memory: 16759696 Qcache_lowmem_prunes: 0 Cache Utilization: 0% Cache Used: 0% Hit Rate: 0% Insert To Prune Ratio:
This script will give you an estimated progress of a MySQL database import.
Import your SQL file by redirecting the file as STDIN:
mysql -u root -ppassword < db.sql
Get the PID of the mysql process running the import and pass it to this script:
./import-status.sh 1476
This will read the file pointer location within the input SQL file and output an estimated percentage.