Are you facing problem in adjusting your system’s time ? Network Time Protocol (NTP) is the soultion. It is used to synchronize time of your system’s clock. It lets you schronize your system’s time with some particular NTP servers. NTP utility is installed by default in almost all distributions of Linux, you just need to start and configure it so that it should get accurate time from remote network time synching servers.
Sometimes you only need to take the dump of structure of any partiuclar table in MySQL. For example, you need to restore only one table from one database to another, then what will you do? dumping the whole database or dumping the particular table with its all data is not a professional approach. Let me share an easy way to dump only table structure in mysql.
Network security is vital now-a-days and you can only ensure the secure network if you are able to identify any security holes. Now, think like a hacker and try to hack your own network, this technique is called penetration testing. Go no where, just try Nmap(Network Mapper). It is one of the best and most commonly used for network troubleshooting and scanning. Start checking from Ping and go to more advanced techniques to check that which hosts are up on the network and which ports are open. Nmap is a powerful, portable, user-friendly and very rich tool which lets you take full control of your network activities.
You might have often seen that any resource hungry application starts consuming the system resources and it creates problems for other applications. Now, what to do? we can not suspend or kill the process because it might be the sole application. The solution to the problem is very simple. Install and use CPULimit.
It is very vital that you should monitor your disk space so that you may add necessary space when needed or you should be able to remove old or unnecessary files in time. Let me share a bash script which will check for disk space and will send you an alert email once consumed disk space reaches 50 percent.
Linux divides the RAM into pages. Swapping is the process in which the pages from RAM are moved over to preconfigured space called swap space. It is very vital in the system performance. With the default installation of Linux, swap partition is not usually setup properly. This is not an easy task to setup swap partition properly. The rule of thumb is that size of swap partition is always twice the size of RAM.
Sometimes, as a web administrator, it becomes very necesary for you that you should block web access for some particular country, Just as an example, you are getting so many spam hits from some particular country, or you are running website of your brand, and you are not providing your services in some country and definitely you don’t want people sending you contact requests form that particular country etc. The soulution is there, guess what ? right its GeoIP.
You might often see the error “Starting MySQL.Manager of pid-file quit without updating fi[FAILED]“ if you have some experince with working on mysql in production linux server. The reason for this error could be that there are some stucked mysql processes, you will need to remove them first. The fix to it is very straight-forward.
Whenever you login to your remote Linux machine via ssh, you usually see the message on your console like “Last login from IP x.x.x.x” , how to clear it ? and why you need to clear it ? . The anwser to second question is very easy, you want to hide your presence and location. The answer to first question is as follows.
InnoDB is a storage engine for mysql. It is supported in all releases of mysql and its edge over the default storage engine is that it supports ACID (Automactiy, Consistency, Intergrity, Durability). Mysql is ready to support InnoDB by default and there is no change needed in configuration. If you need optimize your innodb configuration, open /etc/my.cnf file and put the optimization parameters there. Make sure to restart mysql whenever you make changes to my.cnf
