SELECT FOR UPDATE locks rows returned by SELECT queries until transaction commits. Prevents thrashing and unnecessary transaction retries. Increases throughput and decreases tail latency in concurrent transactions
START TRANSACTION or BEGIN initiates new transactions. COMMIT makes changes permanent, ROLLBACK cancels them. SET autocommit enables/disables default autocommit mode. MySQL runs with autocommit enabled by default
ps command displays running processes and their PIDs in Linux. Linux is a multi-tasking system with multiple processes running simultaneously. ps stands for Process Status
A process is an active entity containing stack, data section, and heap memory. Processes transition through states: New, Ready, Running, Waiting, Terminated. Processes can be independent or cooperating, sharing or not sharing data
Thread pools help save resources by controlling parallelism within predefined limits. Threads are mapped to system-level resources in Java. Thread pool pattern allows controlling thread creation and lifecycle
Linux processes are instances of running computer programs. Multiple programs can run simultaneously on Linux systems. Processes stop when applications or commands terminate