Let the web hosting account be of any type either Windows Web Hosting or Linux Hosting, MySQL supports to both type of web hosting services and is very  popular as a database. The websites which has large data in their MySQL databases are supposed to be optimize it which enable them for enhanced collation of data and indexing. When the number of cases of slow speed of database, queries, rise in backlogs and user unable to connect the database then you can know that you need to optimize your database as soon as possible. Then main causes behind this are non existed or improperly defined indexes. Common people can sort out these causes and tries for some other solutions like implementation of any other costly system but by fixing these small issues one can feel great improvisation in website functioning.

Following is the example I would like to share to get a brief idea of the above discussed issues.

Suppose there is a table ‘emp’ with three different fields as following

emp_code, emp_name, emp_age

For finding the information of an employee the query is written as following

SELECT * FROM from ‘emp’ where emp_code is = 3;

Now the above query will be performed for finding the all records of the employee who has been assigned code as 3, but lets imagine if the number of records existed in the table are in billions then the same query will have to through each record for matching the given condition and the execution of that particular query will need more time.

To avoid the above long time process you need to create an Index. As you have a separate field created as emp_code an index would be a separate file which contains the only records you have inserted in a particular field in sorted manner. If you creates an index for emp_code the MySQL search query is able to find the given record very fast. Indexation causes to sort and search the records at an amazing speed. Here index works very similarly to an Index you know in a book.

Port 21 is a default TCP port for each FTP connection. When this port is blocked by ISP, this causes for FTP connection issues.

Following are processes in Windows and Linux OS to check ISP port 21 is blocked or not.

• port 21 checkout in Windows.

Go to Start Button >> Run or press Windows + R

This will open Run window on the screen. Type ‘cmd’ command and press the ‘Enter’ key.

You will come to ‘command prompt window which is of ‘MS-DOS’ type.

Type the following command in it (without quotes)

‘telnet my-domain-name.com 21′

• port 21 checkout in Linux.

This is simple and short method to check the port 21 check in Linux operating system. In terminal emulator you need to to execute ‘telnet my-domain-name.com 21′ command.

If you received following output after running the above command in both Operating systems, then the test can be considered successful.

220———- Welcome to Pure-FTPd [TLS] ———-
220-You are user number 2 of 50 allowed.
220-<<
220-#########################################################
220-Please upload your web files to the public_html directory.
220-Note that letters are case sensitive.
220-#########################################################
220->>
220-Local time is now 03:35. Server port: 21.
220-This is a private system – No anonymous login
220-IPv6 connections are also welcome on this server.
220 You will be disconnected after 15 minutes of inactivity.

And if you are unable to see the above output then you should unblock port 21 by requesting your ISP provider.

‘inode’ is a term which is related to Unix and Linux systems, it is an unique number assigned to every filename. This given number is utilized for consulting that particular file’s various attributes. In other words we can say that ‘inode’ is an identification of each file created in Unix or Linux system with the purpose of file’s owner and user, file’s access mode and it’s type.

‘ls -l command’ is the command which is used for finding inode number of that particular file. With the help of inode we can also know the capacity of system of holding maximum number of files. The clients of web hosting company can watch the inodes in ‘cpanel >> Inodes Usage’. Inode is read by Kernel when any file is opened and inode varies similarly in the proportion of files used.

When the process of file system creation goes on, information about the files is stored on some data structures. Following is the information which can be retrieved through a inode.

• File’s Length in bytes
• Permissions as read, write and execute set for users.
• File’s Device ID
• File’s Group ID
• File’s modification details
• Record about links pointed towards inode
• File owner’s User ID

Apart from this there are many more use of inodes for Linux Hosting custormers.