Place of all tech articles

techarticles

  • Home
  • About
  • aStore
  • Contact Info
  • Tools
    • SEO Page Audit
    • SEO Keyword Rank
    • google pagerank checker
    • whois

Install WordPress in other language

30th January, 2015 · techinf1 · Leave a comment
Install WordPress in other language

Install WordPress in other language WordPress displays in U.S. English (en_US) by default. But  the software has the built-in capability to be used in any language. The WordPress community has already translated WordPress into many languages, and there are themes, translation files and support available in many other languages. Here are the procedure for different

Read More…

Posted in WordPress |

Top 3 alternatives of Google Adsense

11th January, 2015 · techinf1 · Leave a comment

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

Read More…

Posted in Adsense |

Top 7 Social Networking Sites

4th January, 2015 · techinf1 · Leave a comment

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.  

Read More…

Posted in Social Networking |

Sum Column in Linux

25th December, 2014 · techinf1 · Leave a comment
sum column in linux by a single command

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

Read More…

Posted in AWK, Linux |

MySQL Replication skip error

13th December, 2014 · techinf1 · 7 Comments
MySQL Replication skip error

MySQL Replication skip error There are two ways you can configure MySQL replication : normal and 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

Read More…

Posted in Database, MySQL, Uncategorized |

My Favorite Linux Commands

3rd December, 2014 · techinf1 · Leave a comment
Favorite linux command that would be very helpful for moderate Linux user

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

Read More…

Posted in Linux | Tags: Linux |

Install OCI8 on CentOS/Redhat/Fedora

29th November, 2014 · techinf1 · 1 Comment
Install OCI8 on CentOS/Redhat/Fedora

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

Read More…

Posted in Database, Linux, Oracle, PHP |

Remove Duplicate Rows in MySQL

24th November, 2014 · techinf1 · Leave a comment
Remove Duplicate rows in MySQL

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

Read More…

Posted in Uncategorized |

Optimize MySQL innodb_buffer_pool_size

31st October, 2014 · techinf1 · 3 Comments
Optimize MySQL innodb_buffer_pool_size

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

Read More…

Posted in Database, MySQL |

Optimize MySQL tmp_table_size

25th October, 2014 · techinf1 · 2 Comments
Optimize MySQL tmp_table_size

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

Read More…

Posted in Database, MySQL |
Previous Posts
Next Posts

Android App to challenge math ability
MathQuiz

Top Posts

  • Optimize MySQL table_open_cache
  • Optimize MySQL query_cache_size
  • Optimize MySQL tmp_table_size
  • Optimize MySQL innodb_buffer_pool_size
  • MySQL Replication skip error

Recent Posts

  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux
  • Installing Nginx with PHP support
  • How to access HTML5 local storage

Follow US

Follow US

Categories

© Techinfobest is the house of tech articles
  • About
  • aStore
  • Contact Info
  • google pagerank checker
  • SEO Keyword Rank
  • SEO Page Audit
  • Tools
  • whois