Companies are suffering from losing good developers Please do not get me wrong, change is fine, but hopping too frequently may be harmful .I’m not asking anyone stay same job forever, no. neither trying to explain how important company value is , no . I just to share my own…

#1 Removing every road block, when others only talks More than 10 years ago. There is one person wrote an RPC (when there wasn’t many mature such thing) framework . build an internal “HA proxy”. Also guide system team build a dev-ops (at 2011) systems and we simplly called it “brain storm” . Sharded database vertically then after few…

Software dev is not a racing game. The lifestyle 10 years ago, this is the way how i spend my weekends and my “after 6”: Join every leetcode compatitive session Saturday night and Sunday morning ; reading programming books , many of them ( <<core Java>> , <<Design patterns>> ,<<C++ Primer plus>>…

4 tips people never talked about, they are underrated Including myself, I have seen many junior started a new job or some experienced devs changed their job ,but which quickly turned out a bad choice. In stead of focusing on money or “career ladder” . here i’d like to share…

What I wish i knew 12 years ago before I start workout . In gym everyday I go, I have seen many beginners rush to heavy weight without doing movement properly . …

A step by step introduction to B tree (and B+ tree) with details samples. We may not have to implement a B(+) Tree, but it still good to understand how it works as a senior(lead) developer; because this will help us in making important design choices in order to get…

Let’s talk about how to get the max from office hours and convert the boring into challenging . As Developers we are always solving problems. if work itself has problem, we should also take it as challenge, and fix it. Meetings As developer, yes, we don’t like it . but how…

Bookmark this so that do not have to search again and again . Before start : You may get Sample database from here setup on your environment if you would like to . Shchema Information Show database (version) tables, create table, index show status; show global status ; select version(); show variables like 'slow%'; show databases; use database <db_name> show tables; desc employees; show create table employees; show…

Shared with 3 cases Sample database preparation Setup : 1.1 clone this repo : https://github.com/datacharmer/test_db 1.2 mysql < employees.sql Check database info MariaDB [(none)]> use employees; MariaDB [employees]> select count(1) from salaries; +----------+ | count(1) | +----------+ | 2844047 | +----------+ Lets pick salaries table since it has 2m rows, and migrate this…