Skip to main content

Restricting access to the admin site by ip using nginx

If you have a static ip, and you administer the site exclusively from this address, you can restrict access to the admin panel of the site by ip. As a rule, site control panels are located in a folder (occasionally on a subdomain :) For example, WordPress has / wp-admin /. So, you need to restrict access only to this directory. In this case, the configuration code will look like this:


Bulk optimization of Mysql tables

Fragmented mysql databases are known to slow down the mysql server. And these bases need to be sometimes optimized: to defragment.

There are two ways to optimize tables with the mysqlcheck utility. The first:

  mysqlcheck -Ao 

Here: key A checks tables for errors, and key o performs optimization.

The second way:

  mysqloptimize -A 

The value of the keys here is the same. :)