SysAdmin

Learn how to measure InnoDB table fragmentation using information_schema queries and interpret the resulting ratio to decide when a table needs optimization.

A quick walkthrough of enabling, configuring, and querying the MySQL general log to capture every statement that hits your server.

A quick reference for viewing and applying MySQL GRANT statements, including the specific privileges needed for routine and view management.

A quick reference for checking listening ports on Linux using netstat and ss, including the flags that matter and what each output column means.

A practical walkthrough of Nginx’s limit_req module, showing how to cap request rates and protect PHP endpoints from HTTP-based denial-of-service attacks.

A practical walkthrough of setting up Nginx round-robin load balancing, including upstream configuration, weighted distribution, IP hashing, and failover directives.