Place of all tech articles

techarticles

  • Home
  • About
  • Contact Info

Category Archives: MySQL

Recover MySQL 5.7 root Password in Redhat/CentOS 7

12th August, 2017 · techinf1 · 1 Comment

You can recover MySQL 5.7 root Password with following 9  easy steps. These commands will work in Redhat/CentOS 7 Step-1: Stop MySQL server systemctl stop mysqld   Step-2: Set the mySQL environment option systemctl set-environment MYSQLD_OPTS=”–skip-grant-tables”   Step-3: Start mysql usig the options you just set systemctl start mysqld   Step-4:Login as root mysql -u

Read More…

Posted in Database, MySQL |

fixing mysql replication error automatically

14th March, 2015 · techinf1 · 3 Comments

This article is written for those who have already read article “MySQL Replication skip error” . In that article I explained how to find out replication error and how to solve it step by step. Sometimes , the steps need to be executed several times until there is no error found at heading “Last_SQL_Error:”. Here I

Read More…

Posted in Database, Linux, MySQL |

Create database and user in phpMyAdmin

18th February, 2015 · techinf1 · Leave a comment

phpMyAdmin is a great tool to manage MySQL and MariaDB database.  Every cPanel allows  phpMyAdmin interface to manage the hosting database. It is often required to create a database  first  and  then create  a user who have  full permission on  that database only. Here I show step by step how to create database and user in

Read More…

Posted in Database, MySQL, phpMyAdmin |

MySQL Replication skip error

13th December, 2014 · techinf1 · 7 Comments

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 |

Remove Duplicate Rows in MySQL

24th November, 2014 · techinf1 · Leave a comment

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 Database, MySQL |

Optimize MySQL innodb_buffer_pool_size

31st October, 2014 · techinf1 · 3 Comments

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 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 |

Change MySQL Data Directory

24th October, 2014 · techinf1 · Leave a comment

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

Read More…

Posted in Database, MySQL |

Optimize MySQL table_open_cache

21st September, 2014 · techinf1 · 8 Comments

Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can check whether you need to increase the table cache by checking the Opened_tables status variable.  If the value of Opened_tables is large and you do not use FLUSH TABLES often

Read More…

Posted in Database, MySQL |

Optimize MySQL query_cache_size

23rd August, 2014 · techinf1 · 2 Comments

Optimize MySQL query_cache_size The MySQL query_cache_size is an in memory caches that stores the complete result sets of frequent SELECT queries. Instead of issuing the query again to the database engine, MySQL retrieves the result set from the cache and returns that to the client. The bigger query_cache_size can cache more result set. Query has

Read More…

Posted in Database, MySQL |
Next Posts

Recent Posts

  • Ansible Exam (RHCE 8) full solution with explanation
  • Install Ansible on CentOS 8
  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux

Categories

Pages

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

Archives

  • March 2022
  • February 2022
  • August 2017
  • May 2017
  • November 2015
  • October 2015
  • August 2015
  • May 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014

Categories

  • Adsense (1)
  • Ansible (2)
  • Database (17)
    • MySQL (15)
    • Oracle (2)
  • FTP (1)
  • Google Map (2)
  • HTML5 (1)
  • Linux (8)
    • AWK (1)
  • PageSpeed (1)
  • PHP (3)
  • phpMyAdmin (1)
  • Social Networking (1)
  • Varnish (3)
  • Webpage Optimization (1)
  • Webserver (5)
    • Apache (4)
    • Nginx (1)
  • Website Migration (1)
  • WordPress (6)

WordPress

  • Log in
  • WordPress
© Techinfobest is the house of tech articles
  • Home