40-LINUX-SHELL-COMMANDS-FOR-BEGINNERS

Linux has more than 650 commands and every command has its own set of options all performing different operations. Going through each and every one of these commands will be a very tedious task. However limiting yourself to only a few of them is never an option. The trick here to learning all these commands, is to categories them according to their function. By doing this, you will know atleast the basic commands and have some measure of control over the Linux command line.When you go through these commands, you will be able to perform different function as per your need in the Linux command line.

• Basic Commands
• Editor
• User Account
• Network Commands
• Archive Commands
• Help Commands
• Package Management Utilities
• Process Commands 
• For further, Go to:  http://www.fortystones.com/40-linux-shell-commands-beginners/

STEPS TO CHECK WHEN MYSQL PERFORMANCE IS POOR

If your MySQL server performance is poor check the following details in your server.

1.Check the load average.

          ex: w 

Note:load average is not more than 1.

2.Check free memory.

          ex: free -m 

Check the available memory.

3.Check the updating running process.

          ex: top 

Check CPU utilization and Memory of the server.

4.Show processlist.

This statement shows you which threads are running and to see “too many connections” error message and want to find out what is going on.

5.See log error.

 Is there any error in the server.

6.See slow query log. 

Check which query is taking more time to execute.

Then,Optimizing the query response time by query tuning, proper  index creation and parameter tuning.

7.Hard disk performance.