Here are some ideas, how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations. Below are the main items you can use to [...]

The describe command gives you a list of all the data fields used in your database table. In the example, you can see that the table named test in the salesdata database keeps track of four fields: name, description, num, and date_modified. mysql> describe test; +—————+————–+——+—–+————+—————-+ | Field | Type | Null | Key | [...]

Command Summary Use arp Command mostly used for checking existing Ethernet connectivity and IP address Most common use: arp This command should be used in conjunction with the ifconfig and route commands. It is mostly useful for me to check a network card and get the IP address quick. Obviously there are many more parameters, [...]

One of the problems with writing an entry on the grep command is that it’s so invloved. Grep is a “take it or leave it” command. By that I mean that it can be used easily and quickly with few options, or it can be used with jedi-like mastery. You can basically get as involved [...]

All of the operations considered in this article are operations upon a router, whether that router is a Linux box or Cisco dedicated hardware or some other type of machine. In this chapter I consider the traditional methods of IPv4 routing as using static configurations that are manually input by the network administrator. 1.1 Traditional [...]

This is an introductory guide for people learning to use a Linux system. It focuses on command-line usage. This is not because everyone will be doing everything at the command line. On the contrary, there are many useful GUI tools and programs in Linux, and some people will be content to stay with these. However, in contrast to GUI programs, which can be learned largely by “click and try”, the command-line requires some deliberate learning, and reading documentation. The benefit of this investment is that you will learn the tools and tricks of the command line which are in many cases faster, more powerful, and more flexible than any GUI program.

As a system administrator, part of your daily duties is to monitor systems for performance and to tune systems where necessary. While there are expensive software products and benchmarking tools that can hone a machine to optimum efficiency, there exist several basic tools within Linux® that permit the knowledgeable system administrator to gather information and [...]

OK, let’s see a show of hands: How many of you are reading this book because you want a #1 rank in Google? Yeah, we thought so. As SEO consultants, we know how good it feels when your website makes it to the top of the heap. Listen, we sincerely hope you get your #1 [...]

Databases can be a great tool to organize information, track statistics and generate reports. Like any tool, however, they must be used correctly. A badly designed or improperly used database will end up creating problems rather than solving them. Here are some tips to facilitate proper database design and use

User accounting can be used to discover information about who is currently using the system. While you cannot necessarily verify the integrity of this information once your machine has been exploited, it can be a useful tool to track the systems a particular user has logged into, what time he or she logged in, when [...]

The describe command gives you a list of all the data fields used in your database table. In the example, you can see that the table named test in the salesdata database keeps track of four fields: name, description, num, and date_modified.