Category Archives: Internal

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Posted in Disaster Recovery, High Avaliability, Internal, MySQL, Others, Replication, What I learned today | Tagged , , | Leave a comment

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading

Posted in General, History, Internal, MySQL, Others | Tagged , , , , | Leave a comment

Day 18 Storage engine

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has many storage engine as per the developer/application requirements. With this good part is that MySQL can work multiple storage engine … Continue reading

Posted in Internal, MySQL, Others, What I learned today | Tagged , , , , | Leave a comment

Day 3: MySQL Architecture

Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection layer responsible for connecting to RDBMS, there could be multiple protocol (TCP majorly used). It uses many drivers like … Continue reading

Posted in Internal, MySQL, Others, What I learned today | Tagged , | Leave a comment

TempDB Contention 2.1.%

Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of  2.1.103 check perfomance counter: Temp Tables Creation Rate Temp Tables For Destruction When you are performing many DML operations and makes … Continue reading

Posted in DB Design, DMV, Internal, Lock/Blocking, Performance Tuning, TempDB, Troubleshooting | Leave a comment

Last updated datetime of Sql Server files

*This is related to physical file size of a MDF or LDF file not internal allocation. One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this. Its … Continue reading

Posted in General, Internal, Transaction Log, What I learned today | Tagged , | Leave a comment

Day 11: Error 823 Device is not ready

Description: Below alerts are very critical alerts but its depends on the hardware, when external hard disk (SAN) is unplugged or handled in properly and sql server could not located the drive you may get error like this. Alert description: … Continue reading

Posted in Internal, Troubleshooting | Tagged , | Leave a comment

Internal 1 – Introduction

Internal 1 – Introduction Continue on internal post. Sql server is an application/ software where it runs on system software as well as hardware i.e. Operating system and recourses, Sql server versions should be compatible with Operating system version and … Continue reading

Posted in Internal | Tagged | Leave a comment

Sql Server Internals…

These days I am learning lots of sql servr internals. I am reading blogs by Paul Randal – http://www.Sqlskills.com and gone thorugh his MCM trainings. For me Paul is the mentor of sql server, I learn most of the internal/basics of sql … Continue reading

Posted in Internal | Tagged | Leave a comment

Transaction Log Internals

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database. >> Transaction log is always write in sequential manner , Only at redo state … Continue reading

Posted in Internal, Transaction Log | Tagged , | Leave a comment