Tagged articles
locate
18 articles · Page 1 of 1
This article provides a comprehensive guide to Linux file-finding commands including which, whereis, locate, and find, detailing their syntax, options like -name, -size, -user, -perm, -type, -time, -inum, -exec, -ok, and logical operators with practical examples and output demonstrations.
Linuxcommand-linefile search
0 likes · 14 min read

This comprehensive guide compares find and locate for large-scale Linux file retrieval, covering performance bottlenecks, safe deletion practices, inode exhaustion troubleshooting, and production-ready scripts with dry-run, trash-based cleanup, and monitoring integration for million-file environments.
LinuxOperationsfile search
0 likes · 76 min read

This article explains how to locate files and commands on a Linux system using utilities such as which, whereis, locate (with updatedb), and find with a wide range of options like -name, -size, -user, -perm, -type, -time, -inum, logical operators, and -exec, providing concrete command examples for each scenario.
command-linefile-searchfind
0 likes · 11 min read

This guide explains how the Linux locate and find commands work, covering their performance characteristics, key features, common options, search criteria, combining conditions, actions, and how to use xargs for parameter passing, helping users choose the right tool for efficient file searching.
Operationscommand-linefile search
0 likes · 8 min read

This guide explains how Linux's locate and find commands work, their performance characteristics, permission handling, and provides detailed usage examples and option flags for precise, real‑time, and bulk file searching on Unix‑like systems.
Linuxfile searchfind
0 likes · 8 min read

This guide explains how Linux’s locate and find commands work, compares their performance and features, and provides detailed usage examples, options, and advanced techniques such as depth control, type filtering, size and time queries, permission checks, combined conditions, and xargs integration.
Linuxcommand-linefile-search
0 likes · 8 min read

This guide compares Linux's locate and find utilities, explaining their performance characteristics, usage options, and advanced search criteria so you can choose the right tool for quick, fuzzy, permission‑aware file discovery and automated processing.
Linuxcommand-linefile search
0 likes · 8 min read

This guide compares Linux’s locate and find utilities, explaining their performance characteristics, usage options, search criteria, and actions, while providing practical examples and tips for efficient file searching and manipulation on Unix-like systems.
Linuxfile searchfind
0 likes · 8 min read

This article presents a collection of practical MySQL functions and SQL commands—including GROUP_CONCAT, CHAR_LENGTH, LOCATE, REPLACE, NOW, INSERT…SELECT, INSERT…IGNORE, SELECT FOR UPDATE, ON DUPLICATE KEY UPDATE, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—explaining their purposes, usage patterns, and providing concrete example queries with results.
GROUP_CONCATMySQLON DUPLICATE KEY UPDATE
0 likes · 13 min read


ITPUBDec 24, 2022 · Databases
This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.
EXPLAINGROUP_CONCATINSERT
0 likes · 13 min read

Combining MySQL LIKE fuzzy search with pagination can push exact‑match rows to later pages, causing duplicate brand entries; this article explains the root cause, demonstrates failing queries, and presents several fixes—including adjusting page size, splitting exact and fuzzy queries, and using CHAR_LENGTH and LOCATE functions for custom ordering.
Paginationchar_lengthfuzzy-search
0 likes · 9 min read

This guide explains how to locate commands and files on Linux systems using the which, whereis, locate, and find utilities, covering syntax, common options, wildcard patterns, size filters, ownership checks, time criteria, logical operators, and the -exec action for batch processing.
file searchfindlocate
0 likes · 10 min read

This guide walks through essential Linux commands—which, whereis, locate, and find—detailing how to discover executable paths, locate specific files, query the file database, and perform advanced searches with options for name, size, type, time, permissions, and execution of actions.
Linuxcommand-linefile search
0 likes · 10 min read

This guide introduces the essential Linux file‑search utilities—find, locate, which, and whereis—explaining their core syntax, speed trade‑offs, database dependencies, and useful options so you can quickly locate scripts, executables, source files, and manuals on any system.
command-linefile-searchfind
0 likes · 6 min read

This guide explains how to locate files and commands on Linux using the which, whereis, and locate utilities, covering their purpose, syntax, options, and practical examples that demonstrate fast and accurate searches in the system.
command-linefile searchlocate
0 likes · 11 min read

This article introduces several essential Linux commands—which, whereis, type, locate, and find—explaining how they search for binaries, manuals, source files, or any files on disk, along with practical examples and usage tips for effective file location.
file searchfindlocate
0 likes · 11 min read


ITPUBNov 7, 2016 · Operations
This guide explains how to use Linux's primary file‑search utilities—find, locate, whereis, which, and type—detailing their syntax, options, and practical examples, while highlighting differences such as database reliance, PATH searching, and builtin versus external command identification.
file searchfindlocate
0 likes · 5 min read


ITPUBMay 17, 2016 · Operations
This guide explains how to use the Linux locate and find commands, compares their speed and database usage, details common options, pattern syntax, file‑type and size filters, time‑based searches, permission checks, and shows practical examples of combining conditions and actions.
LinuxOperationscommand-line
0 likes · 9 min read
