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.
Help! My database was compromised!

Help! My database was compromised!

9
Comments 1
7 min read
How AI made my Amazon RDS for MySQL queries 23x faster

How AI made my Amazon RDS for MySQL queries 23x faster

1
Comments
10 min read
MariaDB vs MySQL: The Ultimate Comparison

MariaDB vs MySQL: The Ultimate Comparison

1
Comments
8 min read
Self-hosting Ghost with Docker and PlanetScale

Self-hosting Ghost with Docker and PlanetScale

1
Comments
10 min read
How to Write a SQL Subquery with Drizzle ORM

How to Write a SQL Subquery with Drizzle ORM

Comments
2 min read
How To Design a MySQL Database for your Basic Notification System?

How To Design a MySQL Database for your Basic Notification System?

27
Comments 1
3 min read
Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

1
Comments
2 min read
Pessimistic vs. Optimistic Locking in MySQL

Pessimistic vs. Optimistic Locking in MySQL

45
Comments
5 min read
How to Connect to MySQL through SSH Tunnel

How to Connect to MySQL through SSH Tunnel

1
Comments
1 min read
Solving Common MySQL Issues on macOS: A Guide for Developers

Solving Common MySQL Issues on macOS: A Guide for Developers

5
Comments
2 min read
MySqlException (0x80004005): The Command Timeout expired before the operation completed

MySqlException (0x80004005): The Command Timeout expired before the operation completed

2
Comments
2 min read
Tips and Tricks for isolating long running queries in MySQL

Tips and Tricks for isolating long running queries in MySQL

1
Comments
2 min read
Tuning InnoDB for efficient compression

Tuning InnoDB for efficient compression

1
Comments
2 min read
Implementing nested loop joins in MySQL for performance

Implementing nested loop joins in MySQL for performance

1
Comments
2 min read
How do you perform the compressed back of the InnoDB Cluster?

How do you perform the compressed back of the InnoDB Cluster?

1
Comments
2 min read
SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

Comments
2 min read
Free SQL Database Schema Generator

Free SQL Database Schema Generator

2
Comments 2
1 min read
Working with Numeric Data Types in MySQL: A Comprehensive Guide

Working with Numeric Data Types in MySQL: A Comprehensive Guide

Comments
5 min read
Newsletter Repost - OpenLampTech issue #112

Newsletter Repost - OpenLampTech issue #112

Comments
1 min read
SQL Database Index Basics

SQL Database Index Basics

5
Comments 6
10 min read
How can display data from a table (patient_category) in the database using php-mysql and codeIgniter?

How can display data from a table (patient_category) in the database using php-mysql and codeIgniter?

Comments
2 min read
A key constraint blunder ruined my MySQL practical exam. Don't let it happen to you.

A key constraint blunder ruined my MySQL practical exam. Don't let it happen to you.

13
Comments
3 min read
Discover DbVisualizer Security Features for MySQL

Discover DbVisualizer Security Features for MySQL

Comments
7 min read
Defining Custom Many-to-many Relationship in NestJS TypeORM.

Defining Custom Many-to-many Relationship in NestJS TypeORM.

13
Comments 1
3 min read
Newsletter Repost - OpenLampTech issue #111

Newsletter Repost - OpenLampTech issue #111

Comments
1 min read
loading...