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…

Find a good developer is never easy , it’s may not because too many “bad devs” , some times because wrong questions . I have seen many questions does not bring much value during tech interview, and some wrong questions is funny (7 years ago, I had been asked what…

I have been seeing many gym goers running on treadmill , very slowly, for 1–2hours .This is lot of time. and after months, they still looks the same. Recently , I have been on very tied software project schedule, and If you are under the same situation, or your job…

Pyest is simple and popular unit test tool for python projects. in this article i summarize the steps to setup pytest in your project . complete sample : https://github.com/iorilan/pytest_sample 0. install pip install pytest create test_simple.py , add a simple test def test_no_param(): import time assert int(time.time())%2 == 0 2…

Workout is much more than join a gym .It is a lifestyle, a choice of healthy and deciplined life , with a daily growing mindset . When i started my workout first year, I only wants to be look good and more confident . until one day I realized It…

Engineer, Senior Engineer Techlead (not the techlead), Engineering manager, AVP If you are struggling or just started your engineering manager role, now i am sharing with you all the wrong mindset and mistakes i ever made, so that you may not fall into the same bad loop . How i failed my first techlead role Since 2011…