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

port: port for connectivity default is 3306. user: user for connection default is mysql. datadir: Path where mysql data exists. Default path is /var/lib/mysql else you can set your own path in configuration file. socket: where socket file will be stored for connection. Its default path is data directory else what you mention in config […]

in Download - 04 Dec, 2013
by Zafar Malik - no comments

Percona Tool Kit Linux vi editor Linux Mail Options Index Calculation Methodology Mysql DB Variables and How Mysql uses Memory Sting Function in Mysql MS SQL Server 2012 64 bit trial version for 180 days MS SQL Backup/Restoration How remote connection allow in ms sql server FAQS on MS SQL MS SQL Backup parameter description […]

in Query Optimization - 04 Dec, 2013
by Zafar Malik - no comments

a) Proper data filteration (with the help of where clause) b) Use Explain with select statements to verify the Execution plan of query. If MySQL is doing full table scan then create index on columns being used in Where clause. c) Create index on searching fields. d) Use column names instead of * in select […]

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 […]

in Interview Questions - 05 Nov, 2013
by Zafar Malik - no comments

Interview questions for Mysql DBA —————————————————————————————- Generic Questions —————————————————————————————- # Explain your responsibilities: a) Installation and configuration. b) Managing mysql user accounts. c) Server Load monitoring. d) Server space monitoring. e) Mysql server tuning. f) Schema creation and maintenance. g) Backup/Restoration planning and monitoring. h) Replication monitoring. i) Server Logs monitoring. j) Maintaining mysql log […]

in Replication Trouble Shooting - 20 Sep, 2013
by Zafar Malik - no comments

Problem: Our Replication was going behind on a particular time even there was not much (un-usual) updation or load on server. To know that exact issue when I tried to know slave status at that particular time and executed “show slave status” command on server. I could not get the results and it took too […]

Tags:

in Linux Related Issues - 18 Sep, 2013
by Zafar Malik - no comments

Script is not executing through cron even executing manually (error:Permission denied):   Problem: I created a new script (myscript.sh) and scheduled through cron but this script was not executing even it was executing successfully when I was executing manually. Possible Reasons: 1. User Rights Issue: As this script was executing from root login same like […]

Tags: ,

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 […]

in Fresh Replication - 11 Sep, 2013
by Zafar Malik - no comments

Six Easy Steps for Replication Setup for mysql version lower than 5.5: Special: Assuming Master and Slave both are fresh servers and Mysql Version lower than 5.5: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT […]

Tags:

in Fresh Replication - 11 Sep, 2013
by Zafar Malik - no comments

Easy Steps for Single Database Replication Setup on running stand alone server with Mysql Version lower than 5.5: Special: Assuming Mysql Version is lower than 5.5: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* […]

Tags: