Introduction: MySQL’s slow query log makes it easy to track SQL queries that take more than a specific time for execution. This allows you to find inefficient SQL queries that can be optimized to improve database performance. Prerequisite: Implementation: Step 1: SSH the server with the user having sudo privileges… Continue Reading How to enable the slow query log – Mysql in Linux
1. Finding files by ownership. Find a file owned by a specific group. $ find /home -group groupname Find a file owned by a specific user: $ find /home -user username 2. Finding files by permission. Find files of a specific set of permissions, 777 in this example: $ find… Continue Reading How to find files based on permissions and ownership?
I got the above error when I tried to run “yum update”. Below is the complete error. I got this error on centos-8. Output from the /var/log/dnf.log for more DEBUG information: I have followed the below steps to fix the issue. Step:1:- Go to the /etc/yum.repos.d/ directory. Step:2:- Run the below commands Step:3:- Now… Continue Reading Failed to download metadata for repo ‘AppStream’ [CentOS]
FTP Configuration Dated : 15/11/2018 File Transfer Protocol (FTP) is a standard Internet protocol for transmitting files between computers on the Internet over TCP/IP connections.FTP is a client-server protocol that relies on two communications channels between client and server Step 1 : check whether the ftp is already installed in our… Continue Reading How to setup VSFTP Configuration
How to enable mod_rewrite for Apache in CentOS Date: 10-07-2021 CentOS 7 and later versions have mod_rewrite installed and enabled by default. Open terminal and run the below command to check if mod_rewrite is already enabled in your system.# httpd -M | grep rewriteIf you see the output like below,… Continue Reading How to enable mod_rewrite for Apache in CentOS
How to solve boot partition full issue in CentOS Date: 12-12-2020 Introduction: Once you updated the kernel versions on the server the old and current kernel files will store in the boot partition only. So you will get the boot partition full issue. You directly don’t remove the files from… Continue Reading How to solve boot partition full issue in CentOS
How to enable HTTP2 support in Apache Date posted: 25/09/2019 Objective:- HTTP/2 is a major revision of the HTTP network protocol used by the World Wide Web. It was derived from the earlier experimental SPDY protocol, originally developed by Google. HTTP/2 was developed by the Hypertext Transfer Protocol working group… Continue Reading How to enable HTTP2 support in Apache
cPanel & WHM update failure in upcp script Date posted : 09/06/2019 When automatic upcp runs, there could be some errors/failures for some reason. We should take it into account and should resolve the errors. Its because some of the dns resolvers are not working as expected. Run below scripts… Continue Reading cPanel & WHM update failure in upcp script
Installation Guide – Openvz setup in centos 6 Date Posted: 22/ 05/2019 Introduction This article will guide you in installation of openvz on centos 6. OpenVZ is an OS level virtualization technology for Linux. Most importantly, it allows a physical server to run multiple operating systems on it. Prior –… Continue Reading Installation Guide – Openvz setup in centos 6
How to Install Cmake on Linux. Date : 15/05/2019 Introduction : The “cmake” executable is the CMake command-line interface. It is used to configure projects in scripts. CMake is a cross-platform build system generator. Projects specify their build process with platform-independent CMake list files included in each directory of a source tree with the name… Continue Reading How to Install Cmake on Linux.