Checking mysql extended-status
mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more.
root@dell:~# mysqladmin status -uroot -p
Enter password:
Uptime: 197 Threads: 1 Questions: 135 Slow queries: 0 Opens: 40 Flush tables: 1 Open tables: 34 Queries per second avg: 0.685
For Extended Status
root@dell:~# mysqladmin extended-status -uroot -p
IP-based and name-based Web sites.
There are two ways to host domains. The first is to create the domain with its own IP address. This is called IP-based hosting. You must create IP-based domains if the domain needs anonymous FTP and its own secure-site (SSL) support.
The second way to host domains is to create a domain that shares the primary IP address of the server. This is called name-based hosting. Name-based domains receive most of the benefits of an IP-based domain without occupying an IP address.
All of the standard sets of server applications are available to IP-based and name-based sites, except SSL encryption. SSL is not supported for name-based sites.
IP addresses happen to be scarce resources. To conserve IP addresses, you can arrange to have many sites share the same IP address.
Separating standard output from standard error
Constructs like these are often used by programmers, so that output is displayed in one terminal window, and errors in another. Find out which pseudo terminal you are using issuing the tty command first:
To find the tty type
root@dell:~# tty
/dev/pts/1
Redhat Rescue Mode
Rescue mode provides the ability to boot a small Red Hat Enterprise Linux environment entirely from boot media or some other boot method instead of the system’s hard drive.
There may be times when you are unable to get Red Hat Enterprise Linux running completely enough to access files on your system’s hard drive. Using rescue mode, you can access the files stored on your system’s hard drive, even if you cannot actually run Red Hat Enterprise Linux from that hard drive. If you need to use rescue mode, try the following method:
Using the CD-ROM to boot an x86, AMD64, or Intel® EM64T system, type
at the installation boot prompt. Itanium users should type elilo linux rescue to enter rescue mode.
Size of swap partition
Swap should equal 2x physical RAM for up to 2 GB of physical RAM, and then 1x physical RAM for any amount above 2 GB, but never less than 32 MB.
Using this formula, a system with 2 GB of physical RAM would have 4 GB of swap, while one with 3 GB of physical RAM would have 5 GB of swap.
Creating a large swap space partition can be especially helpful if you plan to upgrade your RAM at a later time.
If your partitioning scheme requires a swap partition that is larger than 2 GB, you should create an additional swap partition. For example, if you need 4 GB of swap, you should create two 2 GB swap partitions. If you have 4 GB of RAM, you should create three 2 GB swap partitions. Red Hat Enterprise Linux supports up to 32 swap files.
