Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

How to Understand the 'ps' Command output in Linux

You can get process details by using the ps command. Those are number of processes running in a current Session, and other parameters about the process.  

Here is all about how to use ps command in Linux.


The ps command


How to use ps command



Here's an example that is how it appears when you issue the 'ps' command.

  • PID (Process Id) - It is the process identification number.
  • TTY(Terminal name) - associated with this process
  • TIME(Time) - the format is hh: mm: ss (Hours, Minutes, and Seconds). Cumulated time of that particular process.
  • CMD (Executable Command name). You May Also Like: PS Command Options in Linux

How to understand slave/master terminal

Here is all about Slave and Master terminal.
  • The pts/0 is the slave terminal. The pts means pseudo terminal slave. Raise your knowledge by bringing in these quick definitions. LINUX - DIFFERENCE BETWEEN TTY AND PTS.
  • In reality, the terminals are two types. One is ptmx (Master) and pts (Slave).
  • The master terminal holds the details of slaves. Those are pts/0, pts/1, and so on.
  • The slave numbers start from 0, 1, 2, 3...
  • The Psuedo terminals ( Master and Slave) are present in the/dev directory.

How to Locate Master/Slave Terminals




On top of that, pseudo terminals are two types. BSD style and UNIX98 style. The UNIX98 is the newest style. BSD-style pseudoterminals vs. UNIX 98 pseudoterminals.

How to use ps -eF command




The Output of ps -eF

  • UID (user id)-it is a root user
  • PID (Process Id)
  • PID (Parent process id)
  • C (Processer utilization). Currently, it is '0'.
  • SZ (size)
  • RSS (Resident set size). Non-swapped physical memory.
  • PSR (Processor number to which this process is assigned)
  • STIME (Start Time)
  • TTY (see the above)
  • TIME (Cumulative CPU time)
  • CMD (The executable command details). Here, I have issued ps -eF. You can see this command in the above picture.


How to get count of processes

Here's the command to use quickly.

$ ps | wc -l
4


References

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers