DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Lessons from a MySQL Migration: What We Learned and How to Do It Better Next Time

Lessons from a MySQL Migration: What We Learned and How to Do It Better Next Time

Comments
6 min read
Transactions, Deadlocks & Log-Based Recovery in MySQL

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

Comments
3 min read
Transactions, Deadlocks & Log-Based Recovery in MySQL

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

Comments
2 min read
How I Optimized a Laravel API 287x Faster: From 27s to Under 100ms

How I Optimized a Laravel API 287x Faster: From 27s to Under 100ms

Comments
3 min read
ACID Properties

ACID Properties

Comments
2 min read
Transactions, Deadlocks & Log-Based Recovery in SQL

Transactions, Deadlocks & Log-Based Recovery in SQL

Comments
2 min read
Understanding ACID Properties with SQL Transactions

Understanding ACID Properties with SQL Transactions

Comments
3 min read
Database Normalization in MySQL (1NF 2NF 3NF) – Simple Example

Database Normalization in MySQL (1NF 2NF 3NF) – Simple Example

1
Comments
3 min read
Cursor and Trigger

Cursor and Trigger

Comments
2 min read
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

Comments
4 min read
Cursors and Triggers

Cursors and Triggers

Comments
3 min read
Nextjs Todo Application Using Mysql and Terraform

Nextjs Todo Application Using Mysql and Terraform

Comments
6 min read
CRUD Operations in MongoDB: Hands-On with a Student Collection

CRUD Operations in MongoDB: Hands-On with a Student Collection

2
Comments
2 min read
Scaling to 300K+ Records Daily: How We Handle High Volume Data Processing with Lumen & MySQL

Scaling to 300K+ Records Daily: How We Handle High Volume Data Processing with Lumen & MySQL

Comments
3 min read
MySQL Storage Engines, Transactions, and Foreign Keys

MySQL Storage Engines, Transactions, and Foreign Keys

1
Comments
3 min read
mysqld Crashes with Signal 11 and Page Corrupt Error

mysqld Crashes with Signal 11 and Page Corrupt Error

Comments 1
4 min read
Types of Databases: A Developer’s Overview

Types of Databases: A Developer’s Overview

Comments
2 min read
Unlock PostgreSQL Performance: A Practical Tuning Guide

Unlock PostgreSQL Performance: A Practical Tuning Guide

Comments
4 min read
The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

Comments
3 min read
MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

Comments
2 min read
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

Comments
2 min read
🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

Comments
1 min read
5 Steps to Optimize MySQL Deep Pagination

5 Steps to Optimize MySQL Deep Pagination

Comments
4 min read
loading...