BestHub
Sign in
Tagged articles

database

2754 articles · Page 18 of 28
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.

ConfigurationMySQLTroubleshooting
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.

MySQLSSHbackup
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 SafetySQLdatabase
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.

ArchitectureStorageSystem Design
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.

InnoDBLock TypesMySQL
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.

Data AnalysisLibrariesPython
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.

MySQLSQLStorage Engines
0 likes · 10 min read
Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2021 · Databases

Understanding NUMA and Its Impact on MySQL Performance

This article explains NUMA architecture, how its memory allocation policies can cause swap‑related performance issues for MySQL, provides step‑by‑step methods to disable NUMA at BIOS, kernel or MySQL levels, and discusses the innodb_numa_interleave parameter and best‑practice recommendations.

LinuxMySQLNUMA
0 likes · 7 min read
Understanding NUMA and Its Impact on MySQL Performance
Python Crawling & Data Mining
Python Crawling & Data Mining
Apr 22, 2021 · Databases

MongoDB Mastery: Install, Configure, and Perform CRUD

This comprehensive tutorial walks you through installing MongoDB on Windows, configuring data and log directories, setting environment variables, creating and managing databases, collections, indexes, aggregation pipelines, backup and restore procedures, monitoring tools, advanced query operators, user management, and using a visual tool like Navicat for MongoDB.

AggregationCRUDInstallation
0 likes · 15 min read
MongoDB Mastery: Install, Configure, and Perform CRUD
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 20, 2021 · Backend Development

Understanding Seata: Principles, Deployment, and Real‑World Issues in Distributed Transactions

This article introduces Seata's background, explains the causes of data inconsistency in micro‑service architectures, details Seata's three core roles, transaction flow, isolation levels, common pitfalls with code examples, and provides guidance on high‑availability deployment, multi‑node setups, disaster recovery, and hands‑on demos.

Distributed TransactionsJavaMicroservices
0 likes · 15 min read
Understanding Seata: Principles, Deployment, and Real‑World Issues in Distributed Transactions
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 17, 2021 · Databases

40 Essential Redis Interview Questions Every Candidate Should Know

This article compiles 40 common Redis interview questions covering fundamentals, data types, persistence, clustering, performance tuning, memory optimization, and practical usage patterns, providing concise answers that help candidates confidently tackle Redis topics and secure job offers during the competitive hiring season.

PerformanceRediscaching
0 likes · 23 min read
40 Essential Redis Interview Questions Every Candidate Should Know
Wukong Talks Architecture
Wukong Talks Architecture
Apr 17, 2021 · Backend Development

Practical Techniques for Ensuring API Idempotency

This article explains the concept of API idempotency, presents common scenarios that cause duplicate data, and details eight practical solutions—including pre‑select before insert, pessimistic and optimistic locking, unique indexes, anti‑duplicate tables, state‑machine checks, distributed locks, and token‑based approaches—along with their implementation steps and caveats.

APIBackenddatabase
0 likes · 13 min read
Practical Techniques for Ensuring API Idempotency
Java Interview Crash Guide
Java Interview Crash Guide
Apr 16, 2021 · Databases

Mastering MySQL Replication: Types, Setup, and Performance Tips

An in‑depth guide to MySQL master‑slave replication covering replication modes, deployment prerequisites, core mechanisms, common issues with solutions such as semi‑synchronous and parallel replication, configuration commands, monitoring techniques, and error handling to ensure high availability and performance.

MySQLPerformancedatabase
0 likes · 7 min read
Mastering MySQL Replication: Types, Setup, and Performance Tips
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 10, 2021 · Databases

Comprehensive MySQL Knowledge Points and Optimization Guide

This article provides a thorough overview of MySQL fundamentals—including schema design, storage engines, transaction mechanisms, logging, indexing, and performance tuning—along with practical SQL examples, code snippets, and optimization strategies for both hardware and database configuration.

MySQLOptimizationPerformance
0 likes · 34 min read
Comprehensive MySQL Knowledge Points and Optimization Guide
Top Architect
Top Architect
Apr 8, 2021 · Databases

Redis Multi‑Threading Evolution: Lazy Free and I/O Thread Mechanisms

Redis, traditionally a single‑threaded in‑memory cache, introduces Lazy Free in version 4.0 and multi‑threaded I/O in version 6.0 to mitigate blocking during large key deletions and improve performance, with detailed explanations of event handling, code implementations, limitations, and comparisons to Tair’s threading model.

I/O ThreadLazy FreeRedis
0 likes · 16 min read
Redis Multi‑Threading Evolution: Lazy Free and I/O Thread Mechanisms
php Courses
php Courses
Apr 8, 2021 · Backend Development

Using ThinkPHP6 Collection Methods to Process Database Query Results

The article explains how ThinkPHP6 returns query results as a Collection object, introduces its useful methods such as toArray and isEmpty, and provides a PHP code example demonstrating how to check for empty results and convert the collection to an array.

BackendCollectionPHP
0 likes · 2 min read
Using ThinkPHP6 Collection Methods to Process Database Query Results
ITPUB
ITPUB
Apr 7, 2021 · Operations

8 Real-World Production Failures and How to Diagnose Them Quickly

The article shares eight authentic production incident cases—from frequent JVM Full GC and memory leaks to cache avalanches, DNS hijacking, and database deadlocks—detailing their root causes, diagnostic steps, code snippets, and practical remediation strategies for engineers facing similar challenges.

JVMOperationsTroubleshooting
0 likes · 17 min read
8 Real-World Production Failures and How to Diagnose Them Quickly
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 7, 2021 · Databases

Understanding MySQL Index Cardinality and Selectivity

This article explains the concept of MySQL index cardinality, how it influences index selectivity, factors that affect cardinality values, methods to view them, and demonstrates with practical examples how different data distributions and query patterns impact the optimizer's execution plans.

CardinalityMySQLQuery Optimization
0 likes · 11 min read
Understanding MySQL Index Cardinality and Selectivity
Top Architect
Top Architect
Apr 6, 2021 · Backend Development

MyBatis‑Plus Tutorial: Creating Databases, Defining Tables, CRUD Operations, Optimistic Locking, Logical Deletion, Performance Analysis, and Code Generation in Spring Boot

This article provides a step‑by‑step guide for using MyBatis‑Plus with Spring Boot, covering database and table creation, entity and mapper definitions, CRUD examples, automatic field filling, optimistic and logical deletion, performance plugins, query wrappers, and a code generator for rapid development.

CRUDCode GenerationMyBatis-Plus
0 likes · 15 min read
MyBatis‑Plus Tutorial: Creating Databases, Defining Tables, CRUD Operations, Optimistic Locking, Logical Deletion, Performance Analysis, and Code Generation in Spring Boot
Java Interview Crash Guide
Java Interview Crash Guide
Apr 6, 2021 · Backend Development

Mastering Redis: From Basics to High Availability in Java Backend

This article walks through what Redis is, its data types, caching usage with Spring Boot, performance advantages, eviction policies, persistence mechanisms, master‑slave replication, Sentinel high‑availability, and practical interview‑style Q&A, providing a comprehensive guide for backend developers.

JavaRedisSpring Boot
0 likes · 33 min read
Mastering Redis: From Basics to High Availability in Java Backend
Code Ape Tech Column
Code Ape Tech Column
Apr 6, 2021 · Backend Development

Common Reasons Why Indexes Are Ignored in SQL Queries

This article explains various situations—such as column-to-column comparisons, NULL values, NOT conditions, wildcard LIKE patterns, functions on indexed columns, low‑cardinality leading columns in composite indexes, implicit datatype conversions, arithmetic predicates, virtual and invisible indexes—that can cause an otherwise usable index to be bypassed by the optimizer, leading to full‑table scans.

OraclePerformanceQuery Optimization
0 likes · 8 min read
Common Reasons Why Indexes Are Ignored in SQL Queries
Java Backend Technology
Java Backend Technology
Apr 4, 2021 · Databases

Mastering MySQL Lock Types and Deadlock Prevention

This article explains MySQL's three lock levels, the algorithms behind next‑key, gap, and record locks, illustrates common deadlock scenarios with real SQL examples, and outlines InnoDB's lock‑prevention strategies to help developers avoid and resolve deadlocks.

InnoDBLockMySQL
0 likes · 15 min read
Mastering MySQL Lock Types and Deadlock Prevention
21CTO
21CTO
Apr 2, 2021 · Databases

Choosing the Right Database Architecture: Principles, Schemes, and Consistency Solutions

This article outlines core database architecture principles, compares four common deployment schemes (master‑slave, dual‑master, master‑slave with read/write separation, and hybrid), and presents practical consistency solutions for both primary‑replica and DB‑cache mismatches, followed by personal evolution insights.

ArchitectureMySQLconsistency
0 likes · 11 min read
Choosing the Right Database Architecture: Principles, Schemes, and Consistency Solutions
Top Architect
Top Architect
Apr 2, 2021 · Databases

MySQL Index Types, Usage Guidelines, and EXPLAIN Interpretation

This article explains MySQL index types—including ordinary, unique, primary, composite, and full‑text indexes—their creation syntax, optimal usage scenarios, situations where indexes should be avoided, cases that render indexes ineffective, and how to interpret EXPLAIN output types for query performance analysis.

EXPLAINMySQLSQL
0 likes · 7 min read
MySQL Index Types, Usage Guidelines, and EXPLAIN Interpretation
Architecture Digest
Architecture Digest
Apr 1, 2021 · Backend Development

Comprehensive Guide to MyBatis‑Plus CRUD, Configuration, and Advanced Features in Spring Boot

This article provides a step‑by‑step tutorial on using MyBatis‑Plus with Spring Boot, covering database creation, table definition, Maven dependencies, entity and mapper setup, CRUD operations, automatic field filling, optimistic locking, pagination, logical deletion, performance monitoring, query wrappers, and code generation, all illustrated with complete code examples.

CRUDJavaMyBatis-Plus
0 likes · 15 min read
Comprehensive Guide to MyBatis‑Plus CRUD, Configuration, and Advanced Features in Spring Boot
Java Architect Essentials
Java Architect Essentials
Mar 31, 2021 · Databases

40 Common Redis Interview Questions and Answers

This article compiles 40 frequently asked Redis interview questions, covering its definition, data types, advantages, comparison with Memcached, persistence mechanisms, performance considerations, eviction policies, clustering, client libraries, security commands, usage scenarios, and best‑practice tips for high‑traffic production environments.

ClusteringPerformancePersistence
0 likes · 19 min read
40 Common Redis Interview Questions and Answers
Top Architect
Top Architect
Mar 30, 2021 · Backend Development

Understanding Idempotency and Its Implementation in RESTful APIs

This article explains the concept of idempotency, why it is essential for HTTP interfaces, the impact on system design, and presents several practical implementation strategies—including unique primary keys, optimistic locking, anti‑repeat tokens, and downstream sequence numbers—accompanied by a complete Spring Boot example with Redis integration and test code.

JavaRedisSpring Boot
0 likes · 21 min read
Understanding Idempotency and Its Implementation in RESTful APIs
Architects' Tech Alliance
Architects' Tech Alliance
Mar 26, 2021 · Fundamentals

Overview of China’s Independent Innovation (Xinchuang) Industry: Market Size, CPU, OS, Database, and Security Landscape

The article provides a comprehensive analysis of China’s Xinchuang industry in 2023, detailing its $104.3 billion market size, the domestic CPU ecosystem, operating system adoption, database and middleware players, and the rapidly growing information‑security sector driven by cloud and IoT technologies.

CPUChinaIndependent Innovation
0 likes · 10 min read
Overview of China’s Independent Innovation (Xinchuang) Industry: Market Size, CPU, OS, Database, and Security Landscape
OPPO Kernel Craftsman
OPPO Kernel Craftsman
Mar 19, 2021 · Databases

Learned Index Structures: Applying Machine Learning to Database Indexing

Learned Index Structures replace conventional B‑Tree and Bloom filter indexes with hierarchical machine‑learning models that predict key positions directly, reducing search overhead, but require careful model selection, training, and handling of updates, making them a promising yet still experimental alternative to traditional database indexing techniques.

Learned IndexStaged Modeldatabase
0 likes · 11 min read
Learned Index Structures: Applying Machine Learning to Database Indexing
php Courses
php Courses
Mar 19, 2021 · Backend Development

Understanding PDOStatement::fetch() Fetch Styles in PHP

This article explains the PDOStatement::fetch() method in PHP, detailing the available fetch style constants, their effects on result set formatting, and shows how to configure the statement to return only associative arrays for cleaner data handling.

BackendFetchModePDO
0 likes · 3 min read
Understanding PDOStatement::fetch() Fetch Styles in PHP
Selected Java Interview Questions
Selected Java Interview Questions
Mar 18, 2021 · Databases

MySQL Lock Types and Deadlock Analysis

This article explains MySQL's lock levels (table, page, row), the next‑key, gap, and record lock algorithms, illustrates common deadlock scenarios with detailed session examples, and discusses InnoDB's deadlock prevention strategies and practical solutions for avoiding lock conflicts.

InnoDBMySQLdatabase
0 likes · 16 min read
MySQL Lock Types and Deadlock Analysis
MaGe Linux Operations
MaGe Linux Operations
Mar 16, 2021 · Databases

Deploying a Scalable Redis Cluster on Kubernetes: Step‑by‑Step Guide

This article introduces Redis, explains its advantages, describes Redis Cluster architecture, and provides a detailed, hands‑on tutorial for deploying a Redis Cluster on Kubernetes using StatefulSets, PersistentVolumes, services, and a sample hit‑counter application, complete with configuration files and verification commands.

KubernetesRedisRedis Cluster
0 likes · 15 min read
Deploying a Scalable Redis Cluster on Kubernetes: Step‑by‑Step Guide
360 Tech Engineering
360 Tech Engineering
Mar 12, 2021 · Databases

Comprehensive Overview of the InnoDB Lock System in MySQL

This article provides a detailed explanation of MySQL InnoDB's lock system, covering lock granularity, shared and exclusive locks, intention and auto‑increment locks, various row‑lock types, deadlock scenarios with examples, and the internal representation of locks in the engine.

InnoDBLocksMySQL
0 likes · 22 min read
Comprehensive Overview of the InnoDB Lock System in MySQL
php Courses
php Courses
Mar 12, 2021 · Backend Development

Using Multiple where Clauses in Laravel for Multi-Field Search

This article demonstrates how to perform multi‑field searches in Laravel by chaining multiple where clauses with closure callbacks, showing example code that conditionally filters by username and hospital ID based on request parameters.

BackendLaravelMultiple Where
0 likes · 2 min read
Using Multiple where Clauses in Laravel for Multi-Field Search
Programmer DD
Programmer DD
Mar 9, 2021 · Frontend Development

How GoDB.js Simplifies IndexedDB with a Developer‑Friendly API

This article introduces GoDB.js, a TypeScript‑based wrapper for IndexedDB that provides a concise, schema‑aware CRUD API, hides asynchronous connection handling, and offers batch operations, making client‑side data storage in modern web apps much easier.

IndexedDBJavaScriptTypeScript
0 likes · 17 min read
How GoDB.js Simplifies IndexedDB with a Developer‑Friendly API
360 Quality & Efficiency
360 Quality & Efficiency
Mar 5, 2021 · Databases

Asynchronous MySQL Operations with aiomysql and SQLAlchemy in Python

This tutorial explains how to perform asynchronous MySQL operations in Python using aiomysql, covering basic connections, CRUD actions, safe parameter handling to prevent SQL injection, connection pooling, transaction management, integration with SQLAlchemy for ORM queries, and a custom reconnection wrapper for resilient database access.

MySQLPythonSQLAlchemy
0 likes · 38 min read
Asynchronous MySQL Operations with aiomysql and SQLAlchemy in Python
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2021 · Databases

Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings

This article explains how to diagnose and resolve MySQL slave replication failures that occur when XtraBackup’s --kill-long-queries-timeout and --kill-long-query-type options interrupt long‑running queries, detailing steps such as checking performance_schema, reviewing error logs, restarting replication, and adjusting backup parameters.

MySQLPerformanceReplication
0 likes · 4 min read
Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings
Architect
Architect
Mar 2, 2021 · Databases

SQL Query Optimization for Large-Scale MES Reporting Using Stored Procedures

An in-depth case study describes how to dramatically improve the performance of a massive MES reporting query—reducing execution from over half an hour to seconds—by analyzing inefficient SQL, adding proper indexes, avoiding full table scans, redesigning with stored procedures, temporary tables, and selective use of NOLOCK.

MESPerformance OptimizationSQL
0 likes · 22 min read
SQL Query Optimization for Large-Scale MES Reporting Using Stored Procedures
NiuNiu MaTe
NiuNiu MaTe
Mar 2, 2021 · Databases

How to Keep Redis and MySQL Consistent: 4 Proven Strategies for Interviews

This article explains why caching MySQL with Redis is essential, outlines the consistency challenges that arise, and presents four practical solutions—expiration, delete‑then‑repopulate, message‑queue updates, and binlog subscription—along with their pros, cons, and guidance for choosing the right approach in interviews.

BackendMySQLRedis
0 likes · 8 min read
How to Keep Redis and MySQL Consistent: 4 Proven Strategies for Interviews
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 26, 2021 · Databases

Overview of ClickHouse Table Engines and Their Usage

This article provides a comprehensive overview of ClickHouse's table engines, explaining the purpose and characteristics of each engine series—including Log, Integration, Special, and the various MergeTree families—while offering detailed SQL examples and guidance on when to use each engine for different data workloads.

ClickHouseMergeTreeSQL
0 likes · 16 min read
Overview of ClickHouse Table Engines and Their Usage
Code Ape Tech Column
Code Ape Tech Column
Feb 16, 2021 · Databases

52 Proven SQL Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL performance‑tuning strategies—including indexing rules, query‑writing shortcuts, join optimizations, lock handling, temporary tables, storage‑engine choices, data‑type recommendations, backup tips, and useful code examples—to help developers dramatically improve query speed and overall database efficiency.

OptimizationPerformanceQuery Tuning
0 likes · 20 min read
52 Proven SQL Optimization Techniques to Supercharge Your Queries
php Courses
php Courses
Feb 9, 2021 · Databases

Impact of Quoting String Primary Keys on MySQL Query Performance

Testing shows that omitting single quotes around a string primary key in MySQL queries can cause a full table scan and increase execution time by about 100‑fold, while quoting the value enables index usage and dramatically improves performance, a difference that disappears when the column is an INT.

Query OptimizationSQLdatabase
0 likes · 4 min read
Impact of Quoting String Primary Keys on MySQL Query Performance
Architecture Digest
Architecture Digest
Feb 9, 2021 · Backend Development

Implementing Database Read‑Write Splitting with Spring Boot

This article explains how to achieve database read‑write separation in high‑concurrency Java applications by configuring master‑slave data sources, implementing a routing data source, managing context with ThreadLocal, defining a custom @DataSourceSwitcher annotation, and applying AOP to dynamically switch between read and write databases.

AOPDataSource RoutingJava
0 likes · 10 min read
Implementing Database Read‑Write Splitting with Spring Boot
Liangxu Linux
Liangxu Linux
Feb 7, 2021 · Databases

Why MariaDB Outperforms MySQL: A Detailed Performance Comparison

This article traces MySQL’s evolution, introduces its fork MariaDB, and presents a comprehensive performance benchmark—covering single and batch inserts, indexed and non‑indexed queries—on identical hardware, revealing that MariaDB generally delivers faster execution times albeit with higher memory usage.

MariaDBMySQLPerformance
0 likes · 10 min read
Why MariaDB Outperforms MySQL: A Detailed Performance Comparison
Selected Java Interview Questions
Selected Java Interview Questions
Feb 6, 2021 · Databases

7 Reasons Why Docker Is Unsuitable for Deploying Databases

Although Docker offers many benefits, this article outlines seven key reasons—data safety, performance, networking, statefulness, resource isolation, cloud platform incompatibility, and environment requirements—that make deploying databases in Docker containers generally unsuitable, while also suggesting scenarios where lightweight or distributed databases may still be viable.

Data SafetyDockerPerformance
0 likes · 9 min read
7 Reasons Why Docker Is Unsuitable for Deploying Databases
Laravel Tech Community
Laravel Tech Community
Feb 4, 2021 · Backend Development

Implementing Multi‑Tenant Architecture in Laravel with the Stancl Tenancy Package

This guide walks through installing the Stancl Tenancy package, configuring Laravel for multi‑tenant support, defining a custom tenant model, setting central and tenant domains, adjusting route providers, running migrations, and creating tenants via Artisan, enabling fully isolated SaaS databases without altering existing application code.

LaravelSaaSTenancy
0 likes · 7 min read
Implementing Multi‑Tenant Architecture in Laravel with the Stancl Tenancy Package
Architecture Digest
Architecture Digest
Jan 28, 2021 · Databases

Practical Guide to Setting Up and Scaling a Redis Cluster (Redis 6.0+)

This article provides a step‑by‑step tutorial on building a Redis Cluster on a single server, covering node configuration, cluster handshaking, slot assignment, master‑slave replication, command routing, failover handling, and practical scaling operations such as adding and removing nodes using redis‑cli.

ClusterRedis CLIdatabase
0 likes · 22 min read
Practical Guide to Setting Up and Scaling a Redis Cluster (Redis 6.0+)
Tencent Cloud Developer
Tencent Cloud Developer
Jan 26, 2021 · Databases

Understanding Redis Sorted Sets and Their Skiplist Implementation

Redis sorted sets (zsets) combine a hash table with a skiplist that provides O(log N) search, insertion, and deletion, using forward, backward, and span pointers to maintain element order and rank, enabling fast score‑based queries, leaderboards, and range operations via commands such as ZADD, ZRANK, and ZRANGE.

C ProgrammingSorted Setdata structure
0 likes · 15 min read
Understanding Redis Sorted Sets and Their Skiplist Implementation
php Courses
php Courses
Jan 26, 2021 · Backend Development

Understanding the ThinkPHP Db Class: Workflow and Core Methods

This article provides a detailed walkthrough of the ThinkPHP Db class, explaining its relationship with other core classes, the database configuration, and the step‑by‑step execution flow of queries, including magic methods, connection handling, and result retrieval.

BackendDBORM
0 likes · 8 min read
Understanding the ThinkPHP Db Class: Workflow and Core Methods
php Courses
php Courses
Jan 25, 2021 · Backend Development

Deep Dive into ThinkPHP Model Implementation and Save Method Execution

This article provides a comprehensive, step‑by‑step analysis of ThinkPHP's Model class, illustrating how the framework organizes model files, utilizes traits and ArrayAccess, and executes the save method—including data validation, insert/update logic, and the underlying execute routine that interacts with the database via PDO.

BackendModelORM
0 likes · 9 min read
Deep Dive into ThinkPHP Model Implementation and Save Method Execution
Laravel Tech Community
Laravel Tech Community
Jan 24, 2021 · Databases

MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds

This article documents a MySQL slow‑query case where a 5‑million‑row table took over 30 seconds to execute, explores several ineffective optimization attempts, uncovers a client‑side LIMIT issue, and finally resolves the performance problem by forcing the use of the idx_end_time index, cutting the runtime to under a second.

MySQLSQL optimizationdatabase
0 likes · 5 min read
MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds
php Courses
php Courses
Jan 22, 2021 · Backend Development

Laravel Eloquent Model Tips: Selecting Attributes, Cloning, Comparing, Refreshing, Updating Relations, Soft Deletes, and Change Detection

This article presents a collection of practical Laravel Eloquent model techniques, including selecting specific attributes with find, cloning models via replicate, comparing models with is, refreshing and reloading records, updating related models with push, customizing soft‑delete columns, and detecting attribute changes using getChanges, getDirty, and getOriginal.

BackendEloquentLaravel
0 likes · 5 min read
Laravel Eloquent Model Tips: Selecting Attributes, Cloning, Comparing, Refreshing, Updating Relations, Soft Deletes, and Change Detection
High Availability Architecture
High Availability Architecture
Jan 22, 2021 · Databases

Comprehensive Guide to Diagnosing and Optimizing Redis Performance Issues

Redis can experience latency spikes due to factors such as complex commands, big keys, expiration patterns, memory limits, fork overhead, AOF persistence, CPU binding, swap usage, memory fragmentation, and network saturation, and this article provides a systematic troubleshooting methodology and practical optimization solutions for each scenario.

MemoryPerformanceRedis
0 likes · 38 min read
Comprehensive Guide to Diagnosing and Optimizing Redis Performance Issues
Practical DevOps Architecture
Practical DevOps Architecture
Jan 22, 2021 · Databases

Redis Common Data Types and Commands Overview

This article introduces Redis's primary data structures—String, Hash, List, and Set—explaining their purpose, key commands, and practical usage examples, including batch operations, numeric adjustments, field management, list manipulation, and set operations, to help developers effectively work with the in‑memory database.

Data TypesRediscommands
0 likes · 6 min read
Redis Common Data Types and Commands Overview