Satya Prakash 
Why we use DNS? To know this follow the link http://t4test.com/blog/etchosts-the-host-file/ Because of sheer numbers of hosts on the Internet, we can’t use host’s file (/etc/hosts) them. The ineternet has centralized file in its teens, but its maintenance because so painful that Berkeley had to step in with the Domain Name System (DNS). DNS is a … Read more
Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way to get the data of given interval. SELECT DATE_FORMAT(create_date, ‘%m/%d/%Y’) FROM mytable WHERE create_date BETWEEN CURDATE() – INTERVAL 30 DAY AND CURDATE() Also note that CURDATE() returns only the DATE portion of the date, so … Read more
NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data persistence features. The NDBCLUSTER storage engine can be configured with a range of failover and load-balancing options, but it is easiest to start with the storage engine at the cluster level. MySQL Cluster’s NDB storage engine contains a complete set of … Read more
MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. MySQL Cluster is designed not to have any single point of failure. In a shared-nothing system, each … Read more
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. In addition, setting max_user_connections does not … Read more
MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user can connect to the server. The account may also have a password. There are several distinctions between the way user names and passwords … Read more
Clear Memory Cache on Linux centos RESET QUERY CACHE will clear out the query cache, but needs RELOAD privileges. RESET QUERY CACHE; or FLUSH QUERY CACHE does NOT clear out the query cache, it simply defrags it leaving the cached query results in place. FLUSH QUERY CACHE; [xyz-ihs snippet=”Discuss”]
In call center language Average Handle Time is also known as AHT. Some organizations also use the term ACHT which stands for Average Call Handling Time. So Average Handle Time is the time that a call center executive takes to complete an interaction with a customer. In simpler terms AHT is the time from where … Read more
The programs that we have learned/developed in this tutorial so far used either a sequential or a decision control instruction. In the first one, the calculations were carried out in a fixed order, while in the second, an appropriate set of instructions were executed depending upon the outcome of the condition being tested (or a logical … Read more
The conditional operators ? and : are sometimes called ternary operators since they take three arguments. In fact, they form a kind of foreshortened if-then-else. Their general form is, expression 1 ? expression 2 : expression 3 What this expression says is: “if expression 1 is true (that is, if its value is non-zero), then … Read more