Enable MySQL slow Query Logs in Linux
The slow query log feature is turned off by default in MySQL, so in order to turn this feature on, we need to set the slow_query_log parameter to ON Enter the MySQL shell and run the following command: set global slow_query_log = ‘ON’; Enable any other desired options. Here are some common examples: Log details for queries expected to …
Basic Usage Tar Command To Compress And Extract Files And Directories
The Linux ‘tar’ command stands for archive and is use to create Archive, compress and extract of Archived files. Tar command in Linux is one of the command which provides archiving functionality in Linux. What is an Archive file? An Archive files is a files that’s carry are one or more files along with metadata. Archive files are used to collect …
Read more “Basic Usage Tar Command To Compress And Extract Files And Directories”
To Understand the architecture of Linux based operating systems.
Let start the learning and understand of file system. / system root directory. first major section of file system /boot boot file, kernel etc /dev contains special/device files like /dev/zero, /dev/null, /dev/tty /etc configuration files /home user home directory. For example “nitin” user will have /home/nitin, “anshika” user will have /home/anshika directory /root root user’s …
Read more “To Understand the architecture of Linux based operating systems.”
How to use wc, fgrep and cal commands
Introduction: wc Command for (Count Number of Lines, Words, and Characters) In Linux operating systems, the wc command allows you to count the number of lines, words, characters, and bytes of each given file or standard input and print the result. wc stands for word count. As the name implies, it is mainly used for counting purpose. It is used to find …
How to use some more monitor system resources such vmstat, netstat part2
1- Nethogs In your network connection seems saturated and you are unsure which application is the culprit, a program called “nethogs” is a good choice for finding out. On Ubuntu, you can install nethogs with the following command: Command: sudo apt-get install nethogs Output: We can run it by simply typing: Command: sudo nethogs Output: …
Read more “How to use some more monitor system resources such vmstat, netstat part2”