eduguru 
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as efficient as possible. As you work on database performance, you start by learning the high-level rules and guidelines … Read more
If you have to restore MyISAM tables that have become corrupt, try to recover them using REPAIR TABLE or myisamchk -r That should work in 99.9% of all cases. In this article we will cover to repair/recover MyISAM tables using myisamchk. MyISAM tables have .MYD and .MYI files for storing data and indexes. You can use … Read more
MySQL Server has several logs that can help you find out what activity is taking place. By Default , No Logs are enabled in MySQL. By default, the server writes files for all enabled logs in the data directory. Logs can be flush by Issuing FLUSH LOGS statement. Binary log is flushed when its size … Read more
It is often the case in programming that you want to do something a fixed number of times. Perhaps you want to calculate gross salaries of ten different persons, or you want to convert temperatures from centigrade to Fahrenheit for 15 different cities. Let us look at a example which uses a while loop. The … Read more
Generally setup command is not used to install in centos minimal installation: Here is the step to install setup command in centos: # yum install setuptool -y # yum install system-config-network* -y # yum install system-config-firewall* -y # yum install system-config-securitylevel-tui -y # yum install system-config-keyboard -y # yum install ntsysv -y
Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement The syntax of creating a view in MySQL is as follows: 1234 5 CREATE[ALGORITHM = {MERGE | TEMPTABLE | UNDEFINED}]VIEW [database_name].[view_name]AS [SELECT statement] Algorithms The algorithm attribute allows you to control which mechanism is used when … Read more
; ; Asterisk Call Detail Record engine configuration ; ; CDR is Call Detail Record, which provides logging services via a variety of ; pluggable backend modules. Detailed call information can be recorded to ; databases, files, etc. Useful for billing, fraud prevention, compliance with ; Sarbanes-Oxley aka The Enron Act, QOS evaluations, and more. … Read more
WARNING[1812] chan_sip.c: Autodestruct on dialog ‘38617eb73184c21225d3133b398b0dc6@10.0.8.18:5060’ with owner SIP/1000-00000533 in place (Method: BYE). Rescheduling destruction for 10000 ms Solution: We resolved this by looking into the dialplan. It seems that we had a channel held open that Asterisk couldn’t destroy. These built up and Asterisk was unable to successfully make calls. A key thing I … Read more
About the Company: S Net Expert Technology is an innovator of Contact Center Software and Enterprise Communications Applications. Working with the team of experts in the domain of customer interactions management solutions, Telecom value added services, S Net Expert Technology has consistently aimed to deliver futuristic applications to un-complicate communications. We offer such Communications Solutions … Read more