Google Adsense is the best advertising network for online earning. However, nowadays it is very difficult for new bloggers or website owner to get approved from Adsense especially for those who wish to earn from Asia. I am also a new publisher. Fortunately I got Adsense approval for my website techinfobest.com . I have another
The most popular social networking sites sure have changed over the years, and you can expect them to continue to change as times goes on. Old social media trends will die, and new ones will appear. However, The following Top 7 Social Networking Sites are expected to remain in top ten for next couple of years.
Sum column in Linux is very easy and you can do it by a single command. If you have a file with multiple columns and you need to quickly get the total of a column in command line in Linux , the easiest way is to use AWK . Consider you have a file name
MySQL Replication skip error This article is written for those who have already installed MySQL GTID based replication. From MySQL 5.6 GTID based replication is started. However, you can again explore how to setup MySQL Replication on the the following links replication-howto replication-gtids-howto Sometimes, replication on Slave server is stopped for many a reasons and
My Favorite Linux Commands There are lot of articles on the web regarding Linux commands . Here I have listed some of my favorite Linux commands. These commands are little bit advanced than those mentioned in general blog but very useful. Start a service in CentOS/Redhat 7 systemctl start httpd Start a service at startup
Install OCI8 on CentOS/Redhat/Fedora The post will describe how to Install OCI8 on CentOS/Redhat/Fedora in step by step. The easiest way to configure PHP to access Oracle Database is to use Oracle Instant Client libraries. This note describes how to install PHP with the OCI8 Extension and Oracle Instant Client on CentOS/Redhat/Fedora. OCI8 is the PHP
Remove Duplicate Rows in MySQL Remove duplicate rows in MySQL is a common query for many initial MySQL user. I have been working on MySQL for more than six years and in my initial starting I had to search over the internet for this easy thing. Though there are a lot of articles on the
Optimize MySQL innodb_buffer_pool_size InnoDB buffer pool is the size in bytes of the buffer pool, the memory area where InnoDB caches table and index data. The larger you set this value, the less disk I/O is needed to access the same data in tables more than once. On a dedicated database server, you might set
Optimize MySQL tmp_table_size MySQL tmp_table_size is the maximum size of internal in-memory temporary tables. (The actual limit is determined as the minimum of tmp_table_size and max_heap_table_size.) If an in-memory temporary table exceeds the limit, MySQL automatically converts it to an on-disk MyISAM table. The on-disk table is expensive and affects your database performance. The temporary table may
Change MySQL Data Directory In Redhat/CentOS/Fedora MySQL default data directory remains in /var/lib/mysql. Sometimes you need to change MySQL data directory to a new location for many reasons. To change MySQL data directory is an easy task. Here I am showing step by step procedure to change MySQL data directory from its default location /var/lib/mysql