facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
Server Load and Query Locking
by Zafar Malik - no comments

Problem: Suddenly one day, high connection/thread alert started to come from a server. Step1: After tracking connections/executing queries by below commands, it came to know that so many connections are going to sleep mode for a specific user (user1) and for a specific DB (mydb). show full processlist; Step2: As some time we were getting […]

by Zafar Malik - no comments

Server Load increased suddenly and some queries were taking too much time now while working fine earlier (Issues: Myisam Table Currupt) Problem: Server Load increased suddenly and some queries were taking too much time now while working fine earlier. Steps to track the reason: Step 1: As it was suddenly while earlier server was working […]

by Zafar Malik - one comment

Problem: No one query was executing on server and hang on server from long time also not executing any new queries.   Steps to Track the reason: As all queries are not executing and in hanging state, so first need to check server error logs. You can use below command on linux server. tail -n25 […]