ETEduard Tymchenkoinreleemdev.hashnode.devMySQL Memory Usage A Guide to OptimizationStruggling with MySQL memory spikes? Knowing how and where memory is allocated can make all the difference in maintaining a fast, reliable database. From global buffers to session-specific allocations, understanding the details of MySQL’s memory mana...4d ago·4 min read
PPPayal Porwalincodeswithpayal.hashnode.dev📘 Day 34 – Connecting MySQL with Node.jsBy the end of Day 34, students will be able to: ✔ Understand how Node.js talks to MySQL✔ Use mysql2 (latest & recommended package)✔ Create first backend API using MySQL✔ Understand real-life backend flow 🔁 Quick Recap (Till Day 33) Till now student...4d ago·5 min read
PPPayal Porwalincodeswithpayal.hashnode.devDay 32 – MySQL Database & Tables (Using phpMyAdmin)🎯 Day 32 Goal By the end of this day, students will clearly understand: What is a Database Why we create multiple databases What is a Table Rows & Columns in real life What is phpMyAdmin How to: Create a database Create tables Insert basic ...5d ago·5 min read
PPPayal Porwalincodeswithpayal.hashnode.devDay 31 – MySQL Basics & Setup with Node.jsBy the end of Day 31, students will clearly understand: What MySQL is Why we use MySQL in real projects How to install MySQL Community Server (latest) What is MySQL Workbench and why we need it How MySQL fits with Node.js projects 👉 No coding...5d ago·4 min read
PPPayal Porwalincodeswithpayal.hashnode.devDay 33 – SQL Queries & Real CRUD Using phpMyAdminBy the end of Day 33, students will: Understand SQL language basics Learn CRUD operations Use SELECT, INSERT, UPDATE, DELETE Perform real CRUD using phpMyAdmin Be mentally ready to connect MySQL with Node.js 👉 Today is the most important data...5d ago·4 min read
PPPayal Porwalincodeswithpayal.hashnode.devMySQL vs MongoDB – Complete Comparison (Beginner to Advanced)🎯 Why This Comparison Is Important? As a Node.js developer, one of the most important decisions is choosing the right database. Two very popular databases are: MySQL (SQL / Relational Database) MongoDB (NoSQL / Document Database) Both are powerf...5d ago·4 min read
VHVarchasv Hooninvarchasvh.hashnode.devLeetCode 262: Trips and UsersDate: February 17, 2026Category: SQLTime Taken: 30 minutesDifficulty: Hard Problem Statement The cancellation rate is computed by dividing the number of canceled (by client or driver) requests with unbanned users by the total number of requests with...5d ago·2 min read
HSHeather Suggsinpostgresql-tips.hashnode.devMySQL replication setup — 6 steps to configure master-slave replicationMySQL replication is a process where data from one database server (master) is copied automatically to one or more database servers (slaves). This creates redundancy and allows you to distribute read operations across multiple servers. Setting up rep...6d ago·10 min read
VHVarchasv Hooninvarchasvh.hashnode.devLeetCode 601: Human Traffic of StadiumDate: February 16, 2026Category: SQLTime Taken: 15 minutesDifficulty: Hard Problem Statement Write a solution to display the records with three or more rows with consecutive id's, and the number of people is greater than or equal to 100 for each. Re...6d ago·2 min read
VHVarchasv Hooninvarchasvh.hashnode.devLeetCode 1070: Product Sales Analysis IIIDate: February 13, 2026Category: SQLTime Taken: 15 minutesDifficulty: Medium Problem Statement Write a solution to find all sales that occurred in the first year each product was sold. For each product_id, identify the earliest year it appears in t...Feb 13·2 min read
