August 2011

Computers, GNU/Linux, Internet Stuff, Open Source, Other Operating System, Tips & Guides, Ubuntu/Debian

How to optimize MySQL tables automatically using cron

Busy websites which has a lot of insert/delete transactions may introduce fragmentation in MySQL tables. Fortunately, users and optimize mysql tables with ‘OPTIMIZE TABLE’ command, but how to execute it automatically? Here’s how: The mysql-client package in Ubuntu installation comes with a tool called mysqlcheck which is handy for optimizing table in mysql. This command […]

Computers, security, Server, Tips & Guides

How to secure server from SYN-flood attack using iptables

SYN-flood attack is commonly utilized as a mean to disrupt network communication and it is a form of (Distributed Denial-of-Service) DDOS attack. RFC4987 details common mitigation to deal with SYN-flood attack. However in this post, I’m going to share you the method that I use to reduce the risk of SYN-flood attack from my department […]

Computers, security, Server

Please update/patch and secure Litespeed web server

Due to the widespread of Litespeed 0-day attack which has affected local websites, it’s imperative for all sysadmin and website operator to patch/update and upgrade the security of the Litespeed web server. This attack is dangerous particularly because the attacker can gain shell access with the same privileges of the web server or the user […]

Scroll to Top