Freaks City

Splitting Strings Using Built-in Tables To transform a comma-separated string into rows, the help_topic system table can be used. This approach leverages the sequential IDs present in the table. SELECT SUBSTRING_INDEX( SUBSTRING_INDEX('a,b,c,d,e,f,g,h', ',', help_topic_id + 1), ',', -1 ) AS extracted_value FROM mysql.help_top ...

Index Structure MySQL defines an index as a data structure used by the storage engine to quickly locate records. Indexes require additional space and maintenance overhead. Indexes are stored as physical data pages in data files (e.g., .ibd files for InnoDB), utilizing data pages for storage. Indexes speed up retrieval but slow down insert, upd ...

Network Connectivity Requirements Ensure bidirectional network commuincation between cluster nodes using ping utility. C:\Users\administrator>ping 192.168.100.91 Pinging 192.168.100.91 with 32 bytes of data: Reply from 192.168.100.91: bytes=32 time=2ms TTL=64 Reply from 192.168.100.91: bytes=32 time=1ms TTL=64 Reply from 192.168.100.91: byt ...

Database Connection Management Applications communicate with MySQL databases through a dedicated MySQL driver that establishes TCP/IP connections. Rather than creating new connections for each request, connection pooling maintains reusable connections to avoid the overhead of repeated connection establishment and teardown. Popular Java connecti ...

A role-based employee attendance management system was implemented using Java Servlets, MyBatis, and MySQL. The system supports login, personal information management, password updates, and attendance tracking with differentiated views for employees, department managers, and administrators. The data model consists of two primary entities: Staf ...

MySQL Data base Installation To install MySQL on a CentOS 7 system, follow these steps: [root@server ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm [root@server ~]# yum -y install mysql57-community-release-el7-9.noarch.rpm [root@server ~]# cd /etc/yum.repos.d/ [root@server ~]# yum -y install mysql-server Starti ...

Databases are fundamental to modern applications, providing structured ways to store and retrieve information. Beyond basic data manipulation, several advanced features ensure data integrity, optimize performance, and simplify complex operations. This article delves into critical database concepts including transactions, storage engines, views, ...

Delete Operation Failure on Replica When a record is deleted on the primary but doesn't exist on the replica, replication halts with an error. Last_SQL_Error: Could not execute Delete_rows event on table app.users; Can't find record in 'users', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000008, end_lo ...

During a recent security scan of backend components, several minor vulnerabilities were detected. To prevent issues during future deployments, I decided to upgrade the MySQL installation. The upgrade strategy involves replacing MySQL binaries only, upgrading the replica node first, promoting it to the primary, and then upgrading the original pr ...

Background Starting from December 5th, a production instance began experiancing daily replica lag alerts. After investigation, the TPS during the lag period was not high, with only about 1K DML operations on the clickstream_events table. However, this table had grown to 60GB, far exceeding the recommended maximum single table size of 10GB. This ...