BestHub
Sign in
Tagged articles

Database

2745 articles · Page 17 of 28
Java Backend Technology
Java Backend Technology
Jul 20, 2021 · Backend Development

How to Implement Efficient MyBatis Streaming Queries in Spring

Streaming queries return an iterator instead of a full result set, reducing memory usage, but require keeping the database connection open; this guide explains MyBatis’s Cursor interface, its methods, and three practical ways—using SqlSessionFactory, TransactionTemplate, or @Transactional—to safely perform MyBatis streaming queries in Spring.

DatabaseJavaMyBatis
0 likes · 7 min read
How to Implement Efficient MyBatis Streaming Queries in Spring
Programmer DD
Programmer DD
Jul 11, 2021 · Databases

Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close

This article demystifies MyBatis transaction handling by explaining the true JDBC methods—setAutoCommit, commit, rollback—and clarifying common misconceptions about create, begin, close, and suspend, while exploring MyBatis’s Transaction, TransactionFactory, and practical code examples that illustrate how commits, rollbacks, and connection closing behave in various scenarios.

DatabaseJDBCMyBatis
0 likes · 10 min read
Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close
Selected Java Interview Questions
Selected Java Interview Questions
Jul 7, 2021 · Operations

Redis Monitoring Metrics and Commands Guide

This article provides a comprehensive overview of Redis monitoring metrics—including performance, memory, basic activity, persistence, and error indicators—along with recommended monitoring tools, configuration settings, and command-line examples for gathering and interpreting these metrics in production environments.

DatabaseOperationsPerformance
0 likes · 7 min read
Redis Monitoring Metrics and Commands Guide
dbaplus Community
dbaplus Community
Jul 6, 2021 · Databases

Why Do MySQL Transactions Deadlock and How Can You Prevent It?

This article explains the root causes of MySQL deadlocks in InnoDB, walks through transaction and lock fundamentals, analyzes real‑world log cases, and presents practical solutions such as adjusting isolation levels, using SELECT FOR UPDATE, adding unique indexes, or checking existence before deletion to eliminate deadlocks.

DatabaseDeadlockInnoDB
0 likes · 12 min read
Why Do MySQL Transactions Deadlock and How Can You Prevent It?
Efficient Ops
Efficient Ops
Jul 5, 2021 · Operations

10 Essential Practices to Prevent DBA and Ops Disasters

Learn ten practical strategies—from safe change rollbacks and cautious destructive commands to robust backups, clear prompts, vigilant monitoring, and disciplined handovers—that help DBAs and operations engineers avoid costly system failures and maintain reliable production environments.

DatabaseOperationsOracle
0 likes · 6 min read
10 Essential Practices to Prevent DBA and Ops Disasters
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2021 · Databases

Fetching the Latest Record per Name Group in MySQL 5.6/5.7

The article explains why a simple GROUP BY query in MySQL 5.6 returns the earliest rows instead of the most recent ones, demonstrates how to correctly obtain the latest record per name using sub‑queries or window functions, and discusses the impact of the ONLY_FULL_GROUP_BY mode in MySQL 5.7.

DatabaseGROUP BYMySQL
0 likes · 5 min read
Fetching the Latest Record per Name Group in MySQL 5.6/5.7
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2021 · Databases

Observing the Effects of MySQL Group Commit through Experiments

Through a series of experiments using MySQL 8.0, this article demonstrates how group commit reduces I/O operations by consolidating multiple transactions into a single commit group, showing that doubling load increases runtime modestly while transaction count and commit groups rise significantly, highlighting performance benefits.

DatabaseGroup CommitIO optimization
0 likes · 4 min read
Observing the Effects of MySQL Group Commit through Experiments
Code Ape Tech Column
Code Ape Tech Column
Jun 30, 2021 · Databases

Implementing Like Functionality with Redis Bitmaps

This article explains how to use Redis bitmap operations to efficiently implement like, sign‑in, and other binary state features, covering bitmap fundamentals, common use cases, essential commands, Java code examples with Jedis, and range query techniques.

BitMapDatabaseJava
0 likes · 7 min read
Implementing Like Functionality with Redis Bitmaps
Alibaba Cloud Native
Alibaba Cloud Native
Jun 28, 2021 · Cloud Native

How Chanjet Scaled SaaS for 1.3M SMEs with Cloud‑Native Architecture

Chanjet transformed its monolithic SaaS platform for millions of small‑business customers by adopting a cloud‑native, container‑based micro‑service architecture, enabling elastic scaling, reduced operational costs, unified data services, automated DevOps pipelines, and comprehensive observability across front‑end, back‑end, and infrastructure layers.

DatabaseDevOpsMicroservices
0 likes · 27 min read
How Chanjet Scaled SaaS for 1.3M SMEs with Cloud‑Native Architecture
Architecture Digest
Architecture Digest
Jun 27, 2021 · Backend Development

Scalable Architecture Without Magic: Principles and Practical Setups

The article outlines practical principles for building scalable, stateless backend architectures—choosing the right tools, using multiple servers, applying caching and rate limiting, delegating responsibilities to databases, handling large data volumes, and presenting example configurations from small to massive deployments.

Databasecachingscalability
0 likes · 11 min read
Scalable Architecture Without Magic: Principles and Practical Setups
Java Backend Technology
Java Backend Technology
Jun 20, 2021 · Databases

Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes

Java developers often mishandle SQL, leading to performance, correctness, and maintenance issues; this article outlines ten common pitfalls—from misunderstanding NULL and misusing UNION to neglecting MERGE and batch inserts—and provides practical solutions to write efficient, reliable database queries.

DatabaseJDBCJava
0 likes · 11 min read
Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes
IT Architects Alliance
IT Architects Alliance
Jun 20, 2021 · Databases

Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel

This article examines the limitations of Redis master‑slave replication, such as manual failover and single‑node bottlenecks, and provides an in‑depth exploration of Redis Sentinel’s architecture, configuration parameters, detection mechanisms, automatic failover process, and best‑practice recommendations for achieving high availability.

DatabaseFailoverHigh Availability
0 likes · 11 min read
Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel
Top Architect
Top Architect
Jun 19, 2021 · Databases

SQL Query Performance Optimization Tips

This article provides a comprehensive collection of practical MySQL and SQL performance optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, efficient joins, backup strategies, and other best practices to improve database speed and reliability.

DatabaseMySQLSQL
0 likes · 18 min read
SQL Query Performance Optimization Tips
Laravel Tech Community
Laravel Tech Community
Jun 18, 2021 · Databases

Understanding NULL Values in Databases

This article explains the special nature of NULL in SQL, how to correctly test for NULL using IS NULL, the three‑valued logic of true/false/unknown, and the pitfalls of NOT, NOT IN, and Oracle’s handling of empty strings versus NULL.

DatabaseIS NULLNULL
0 likes · 6 min read
Understanding NULL Values in Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 18, 2021 · Databases

How to Compile a Debug Version of MySQL Using Docker

This article explains step‑by‑step how to build a MySQL debug binary inside a Docker container, covering environment preparation, dependency installation, configuring the build with CMake, compiling, and locating the resulting mysqld‑debug executable, while also noting performance trade‑offs of debug builds.

CMakeCompilationDatabase
0 likes · 3 min read
How to Compile a Debug Version of MySQL Using Docker
Wukong Talks Architecture
Wukong Talks Architecture
Jun 17, 2021 · Databases

Ensuring Data Consistency Without Native Transactions in MongoDB

The article explains how lack of native transactions in MongoDB 3.0 can cause data inconsistency during order processing, compares it with SQL transaction mechanisms, and proposes optimization and compensation strategies such as retry queues, asynchronous tasks, and refund handling to ensure eventual consistency.

Data ConsistencyDatabaseMongoDB
0 likes · 10 min read
Ensuring Data Consistency Without Native Transactions in MongoDB
Xianyu Technology
Xianyu Technology
Jun 17, 2021 · Mobile Development

Flutter-based IM Architecture Redesign for Xianyu

The Xianyu instant‑messaging system, burdened by years of technical debt, was rebuilt with a Flutter‑centric, four‑layer architecture that shares FlutterEngine instances, introduces an entity cache and custom ORM, simplifies synchronization, and delivers up to 40 MB memory savings, lower power use, reduced CPU load and roughly half the development and testing effort.

DatabaseFlutterIM
0 likes · 11 min read
Flutter-based IM Architecture Redesign for Xianyu
IT Xianyu
IT Xianyu
Jun 16, 2021 · Databases

Understanding Database Connection Pools vs. ThreadLocal in Java

This article explains the fundamental differences between database connection pools and ThreadLocal‑cached connections in Java, illustrating how connection pools improve performance while ThreadLocal enables sharing a single connection across methods within the same thread for consistent transaction control, and discusses practical usage patterns.

DatabaseJavaThreadLocal
0 likes · 7 min read
Understanding Database Connection Pools vs. ThreadLocal in Java
Laravel Tech Community
Laravel Tech Community
Jun 15, 2021 · Backend Development

PDO::inTransaction – Checking If Inside a Transaction

The PDO::inTransaction method returns a boolean indicating whether the current database connection is actively inside a transaction, works only with drivers that support transactions, takes no parameters, and returns TRUE on success and FALSE on failure.

DatabasePDOPHP
0 likes · 1 min read
PDO::inTransaction – Checking If Inside a Transaction
Laravel Tech Community
Laravel Tech Community
Jun 14, 2021 · Backend Development

PDO::rollBack – Rolling Back a Transaction in PHP

The article explains how the PHP PDO::rollBack() method aborts the current transaction, restores autocommit mode when needed, outlines its parameter‑less signature, return values, and provides a complete code example demonstrating transaction handling and rollback behavior.

DatabasePDOPHP
0 likes · 2 min read
PDO::rollBack – Rolling Back a Transaction in PHP
IT Xianyu
IT Xianyu
Jun 11, 2021 · Databases

10 Common Mistakes Java Developers Make When Writing SQL

The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.

DatabaseJDBCJava
0 likes · 9 min read
10 Common Mistakes Java Developers Make When Writing SQL
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 10, 2021 · Databases

Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights

This article examines the trade‑offs between automatically generated and manually crafted SQL parsers, detailing lexical‑syntax analysis techniques, performance challenges in OLAP workloads, and the authors’ custom parser design that achieves up to 30‑50× speed gains in complex queries and bulk inserts.

DatabaseParserPerformance
0 likes · 17 min read
Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Backend Development

PDO::inTransaction – Check If Inside a Transaction

PDO::inTransaction is a PHP PDO method that returns a boolean indicating whether the current database connection is actively within a transaction, applicable only to drivers that support transactions, and it takes no parameters.

DatabasePDOPHP
0 likes · 1 min read
PDO::inTransaction – Check If Inside a Transaction
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Advanced Features

This article provides a thorough overview of relational database fundamentals, SQL syntax structures, data definition and manipulation languages, transaction control, permission management, as well as detailed examples of CRUD operations, subqueries, joins, unions, functions, constraints, stored procedures, cursors, and triggers, all illustrated with practical code snippets.

DDLDMLDatabase
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Advanced Features
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 9, 2021 · Databases

Comprehensive Guide to ClickHouse: Features, Configuration, Table Engines, and Real‑World Use Cases

This article provides an in‑depth overview of ClickHouse, covering its OLAP advantages, core features, detailed configuration files, various table engines (MergeTree, ReplacingMergeTree, SummingMergeTree, Log series, external integrations), practical examples, performance tips, and real‑world deployment scenarios.

ClickHouseConfigurationDatabase
0 likes · 62 min read
Comprehensive Guide to ClickHouse: Features, Configuration, Table Engines, and Real‑World Use Cases
Architect
Architect
Jun 6, 2021 · Databases

Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions

An engineer describes a production MySQL pagination issue where large offset queries caused severe slowdown, analyzes the root cause, demonstrates data simulation scripts, and presents three optimization strategies—including index covering with subqueries, redefining start positions, and applying offset limits—to improve query performance on massive tables.

DatabaseMySQLPagination
0 likes · 13 min read
Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions
Code Ape Tech Column
Code Ape Tech Column
Jun 4, 2021 · Databases

8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds

This article examines common MySQL performance pitfalls such as inefficient LIMIT offsets, implicit type conversions, suboptimal UPDATE/DELETE joins, mixed sorting, misuse of EXISTS, and limited condition pushdown, then demonstrates concrete rewrites—including range reduction and WITH clauses—that reduce execution times from seconds to milliseconds.

DatabaseMySQLPerformance Optimization
0 likes · 12 min read
8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds
Ops Development Stories
Ops Development Stories
Jun 4, 2021 · Operations

Step-by-Step Guide to Monitoring MongoDB with Zabbix Agent 2

This tutorial explains how to use Zabbix Agent 2 to monitor MongoDB databases and clusters, covering the required read‑only user setup, relevant Zabbix templates, key metrics such as jumbo chunks, connection pool stats, server status, collection and replSet information, and practical configuration examples.

Agent2DatabaseMongoDB
0 likes · 6 min read
Step-by-Step Guide to Monitoring MongoDB with Zabbix Agent 2
IT Architects Alliance
IT Architects Alliance
May 31, 2021 · Databases

40 Common Redis Interview Questions and Answers

This article compiles 40 frequently asked Redis interview questions covering fundamentals, data types, persistence, clustering, performance tuning, memory optimization, security, and advanced usage such as pipelines and distributed locks, providing concise answers to help candidates prepare confidently for technical interviews.

DatabaseInterviewPerformance
0 likes · 20 min read
40 Common Redis Interview Questions and Answers
MaGe Linux Operations
MaGe Linux Operations
May 31, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.

Data RecoveryDatabaseImplicit Conversion
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
Tencent Database Technology
Tencent Database Technology
May 31, 2021 · Databases

TXSQL Query Optimizer Framework: Transformation, Join Reorder, and Cost Model

This article introduces the TXSQL query optimizer built on MySQL 8.0.22, detailing its cascades‑style framework, transformation rewrite rules such as outer‑join elimination and subquery flattening, join‑order heuristics, cost‑model configuration, and execution strategies, providing a comprehensive overview of its design and enhancements.

Cost ModelDatabaseJoin Reorder
0 likes · 25 min read
TXSQL Query Optimizer Framework: Transformation, Join Reorder, and Cost Model
Architect's Tech Stack
Architect's Tech Stack
May 31, 2021 · Databases

Tendis Hybrid Storage Architecture: Design, Features, and Implementation Details

This article introduces the pain points of using Redis as a cache, presents Tencent's Tendis solution with its three product variants, and provides an in‑depth explanation of the hybrid storage version’s overall architecture, component functions, version control, cold‑hot data interaction, eviction policies, and scaling mechanisms.

CacheCuckoo FilterDatabase
0 likes · 17 min read
Tendis Hybrid Storage Architecture: Design, Features, and Implementation Details
MaGe Linux Operations
MaGe Linux Operations
May 29, 2021 · Databases

40 Must‑Know Redis Interview Questions to Ace Your Next Job

This article compiles 40 common Redis interview questions and detailed answers, covering Redis fundamentals, data types, persistence mechanisms, performance characteristics, clustering, replication, memory optimization, eviction policies, and practical usage scenarios to help candidates confidently succeed in technical interviews.

DatabaseInterviewPersistence
0 likes · 23 min read
40 Must‑Know Redis Interview Questions to Ace Your Next Job
Tencent Architect
Tencent Architect
May 28, 2021 · Cloud Native

Exploring Tencent Cloud Native Database TDSQL-C Architecture and Practices

The presentation at SACC2021 detailed the background, architecture, performance, reliability, and future development directions of Tencent's cloud‑native distributed database TDSQL‑C, highlighting its compute‑storage separation, serverless elasticity, high QPS capability, and advanced fault‑tolerance mechanisms.

DatabaseDistributed ArchitectureTDSQL-C
0 likes · 6 min read
Exploring Tencent Cloud Native Database TDSQL-C Architecture and Practices
ITPUB
ITPUB
May 27, 2021 · Backend Development

Ensuring Cache‑Database Consistency: Strategies, Pitfalls, and Delayed Double‑Delete

This article examines common cache‑database consistency approaches, analyzes their drawbacks through concrete examples, compares them in a decision matrix, and proposes a reliable solution—delayed double‑delete with retry mechanisms—detailing implementation code, timing considerations, and practical deployment tips for high‑read, low‑write services.

Cache ConsistencyDatabaseconsistency strategies
0 likes · 11 min read
Ensuring Cache‑Database Consistency: Strategies, Pitfalls, and Delayed Double‑Delete
Top Architect
Top Architect
May 19, 2021 · Databases

MyBatis Streaming Query: Cursor Interface and Practical Implementations

This article explains MyBatis streaming queries using the Cursor interface, demonstrates how to define a Mapper that returns a Cursor, shows common pitfalls with closed connections, and provides three solutions—manual SqlSession handling, TransactionTemplate, and @Transactional—to keep the database connection open while iterating results.

DatabaseJavaMyBatis
0 likes · 7 min read
MyBatis Streaming Query: Cursor Interface and Practical Implementations
macrozheng
macrozheng
May 17, 2021 · Databases

Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested

This article introduces the importance of database connections, compares three popular Java connection pools (DBCP, C3P0, Druid) with code examples, runs performance tests inserting 100 k and 1 M rows on MySQL, Oracle and PostgreSQL, and concludes with recommendations on the most stable pool and optimal databases.

DatabaseDruidJava
0 likes · 11 min read
Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested
Top Architect
Top Architect
May 16, 2021 · Databases

Understanding LEFT JOIN, Common Pitfalls, and Practical Solutions in SQL

This article explains how LEFT JOIN works in SQL, illustrates why duplicate rows can appear when joining tables, and provides practical techniques such as DISTINCT, GROUP BY, MAX, and IN subqueries to ensure a one‑to‑one result set while also covering RIGHT JOIN, INNER JOIN, update and delete operations, and the concept of Cartesian products.

DatabaseJOINLeft Join
0 likes · 14 min read
Understanding LEFT JOIN, Common Pitfalls, and Practical Solutions in SQL
Practical DevOps Architecture
Practical DevOps Architecture
May 14, 2021 · Databases

Redis Basic Commands and Key Operations Tutorial

This article provides a concise tutorial on essential Redis commands, covering basic operations, database selection, key management, expiration settings, and practical examples demonstrated through the Redis CLI, including how to list keys with patterns, check existence, and clear databases.

DatabaseRedisTTL
0 likes · 7 min read
Redis Basic Commands and Key Operations Tutorial
Alibaba Cloud Developer
Alibaba Cloud Developer
May 13, 2021 · Databases

Why Lindorm TSDB Is Shaping the Future of Massive IoT Time‑Series Data

This article examines the explosive growth of IoT data, outlines the unique challenges of storing and querying massive time‑series datasets, reviews the evolution of time‑series databases, and explains how Alibaba Cloud's Lindorm TSDB leverages cloud‑native, multi‑model architecture to deliver high‑throughput, low‑cost, and scalable solutions for IoT, industrial and monitoring workloads.

DatabaseIoTLindorm
0 likes · 20 min read
Why Lindorm TSDB Is Shaping the Future of Massive IoT Time‑Series Data
Top Architect
Top Architect
May 13, 2021 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

The article explains why adding conditions after a LEFT JOIN using AND does not filter rows from the left table, contrasts ON and WHERE clauses, and demonstrates the behavior with SQL examples and step‑by‑step illustrations of intermediate result tables.

DatabaseJoin TypesLeft Join
0 likes · 6 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
Programmer DD
Programmer DD
May 13, 2021 · Databases

How an Unexpected Primary Key Update Triggered a MySQL Auto‑Increment Bug

A developer encountered a duplicate‑key error caused by an unexpected primary‑key update that overflowed the signed INT limit, exposing a hidden MySQL auto‑increment bug that persisted across normal inserts until a later DDL operation triggered failures, a problem present in Percona 5.6/5.7 but fixed in MySQL 8.0.

DatabaseMySQLPercona
0 likes · 5 min read
How an Unexpected Primary Key Update Triggered a MySQL Auto‑Increment Bug
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 13, 2021 · Databases

Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover

This article explains common database high‑availability designs—including master‑slave, master‑master, and automatic failover architectures—their topologies, advantages, disadvantages, and practical considerations such as replication lag, manual intervention, and data consistency challenges.

DatabaseFailoverHigh Availability
0 likes · 7 min read
Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover
Architecture Digest
Architecture Digest
May 12, 2021 · Backend Development

Performance Optimization of a High‑Concurrency Python Web Service

This article documents a Python web service performance optimization case, detailing the initial bottlenecks, architectural redesign with caching and message queues, load‑testing methodology, Linux TCP time‑wait tuning, and the final results achieving 50k QPS with sub‑70 ms latency.

DatabaseLinux TuningPerformance Optimization
0 likes · 9 min read
Performance Optimization of a High‑Concurrency Python Web Service
Practical DevOps Architecture
Practical DevOps Architecture
May 10, 2021 · Databases

Redis Advantages, Disadvantages, Use Cases, Shutdown Methods, and Configuration Guide

This article outlines Redis's key advantages such as high performance and flexible data types, discusses its limitations like lack of relational features, describes ideal in‑memory use cases, compares it with Memcached, and provides detailed instructions for shutting down, configuring, and connecting to Redis using command‑line and graphical clients.

ClientConfigurationDatabase
0 likes · 4 min read
Redis Advantages, Disadvantages, Use Cases, Shutdown Methods, and Configuration Guide
Programmer DD
Programmer DD
May 8, 2021 · Backend Development

How to Build a Full‑Stack Logistics Management System with SpringBoot and Layui

This article presents a complete logistics management system case study, covering business requirements, technology stack selection, front‑end and back‑end architecture, core modules such as bill management, receipt handling, vehicle dispatch, and includes full Java code snippets for key operations.

DatabaseSpringBootWeb Development
0 likes · 15 min read
How to Build a Full‑Stack Logistics Management System with SpringBoot and Layui
Laravel Tech Community
Laravel Tech Community
Apr 28, 2021 · Databases

Understanding and Analyzing MySQL Execution Plans

This article explains the three‑layer architecture of MySQL, how an execution plan is generated and interpreted, and provides a detailed walkthrough of the columns displayed by the EXPLAIN statement to help developers optimize their SQL queries.

DatabaseEXPLAINMySQL
0 likes · 8 min read
Understanding and Analyzing MySQL Execution Plans
Open Source Linux
Open Source Linux
Apr 26, 2021 · Databases

How to Resolve MySQL Too Many Connections Errors by Raising max_connections

This guide explains why MySQL reports "too many connections", shows how to check the current max_connections setting, compares default limits across MySQL versions, and provides four practical methods—including editing my.cnf, using SQL commands, modifying source code, and tweaking mysqld_safe—to increase the connection limit safely.

ConfigurationDatabaseMySQL
0 likes · 4 min read
How to Resolve MySQL Too Many Connections Errors by Raising max_connections
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 25, 2021 · Databases

Remote MySQL Backup with mysqlbackup and Percona XtraBackup

This article demonstrates how to perform remote physical backups of MySQL databases using the mysqlbackup and Percona XtraBackup tools, covering test objectives, environment setup, step‑by‑step streaming commands, restoration procedures, replication configuration, and a comparison of the two approaches.

DatabaseMySQLSSH
0 likes · 13 min read
Remote MySQL Backup with mysqlbackup and Percona XtraBackup
macrozheng
macrozheng
Apr 25, 2021 · Databases

10 Proven Ways to Prevent Dangerous SQL Mistakes in Production

This article outlines ten practical strategies—including avoiding chat tools for SQL, compressing statements, using SELECT COUNT, adding LIMIT, updating audit fields, logical deletion, table backups, temporary tables, fully qualified names, and careful column changes—to help developers, testers, and DBAs prevent costly database errors in production environments.

Data SafetyDatabaseSQL
0 likes · 15 min read
10 Proven Ways to Prevent Dangerous SQL Mistakes in Production
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 25, 2021 · Databases

Overview of Database System Design

This article provides a comprehensive overview of database system design, covering the historical evolution, classification of relational and NoSQL databases, common architectures, consistency models, indexing techniques, storage formats, compression, and practical considerations for selecting and optimizing database solutions.

Databasearchitectureconsistency
0 likes · 45 min read
Overview of Database System Design
Liangxu Linux
Liangxu Linux
Apr 24, 2021 · Databases

Understanding MySQL Lock Types and How to Prevent Deadlocks

This article explains MySQL's table, row, and page lock levels, describes next‑key, gap, and record locks, illustrates common deadlock scenarios with detailed SQL examples, and outlines InnoDB's lock acquisition and deadlock‑prevention strategies to help developers avoid concurrency issues.

DatabaseDeadlockInnoDB
0 likes · 14 min read
Understanding MySQL Lock Types and How to Prevent Deadlocks
Python Crawling & Data Mining
Python Crawling & Data Mining
Apr 24, 2021 · Fundamentals

Discover 140+ Must‑Know Python Libraries for Data Science & AI

The article presents a comprehensive guide to Python's built‑in functions, standard libraries, and third‑party packages across file I/O, web scraping, databases, data cleaning, statistical analysis, machine learning, visualization, and more, rating each with stars and offering a free e‑book collection for readers.

DatabaseLibrariesMachine Learning
0 likes · 32 min read
Discover 140+ Must‑Know Python Libraries for Data Science & AI
Selected Java Interview Questions
Selected Java Interview Questions
Apr 22, 2021 · Databases

Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts

This article explains the differences between DROP, DELETE, and TRUNCATE, recommends appropriate MySQL data types for monetary values, compares MyISAM and InnoDB storage engines, outlines transaction ACID properties, describes views, stored procedures versus triggers, indexes, UNION vs UNION ALL, and lists the main SQL language categories.

DatabaseMySQLSQL
0 likes · 10 min read
Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts