Archives: Database

Linux vmstat command

April 4, 2019 | By kiranbadi1991 | Comments Off on Linux vmstat command | Filed in: Database, Development, Environment, Memory, Performance Engineering, Process, Web Server.

I have been spending  bit of my time on EC2 Amazon linux. So thought of just making a note of some of the commands I frequently use. It helps me to look directly at my site for information on this command rather than googling and spending time for the information in the internet for this • Read More »

Tags: , ,

My SQL InnoDB Storage Engine

January 24, 2015 | By kiranbadi1991 | Comments Off on My SQL InnoDB Storage Engine | Filed in: Database, Environment, Performance Engineering, Small Businesses.

MySQL comes with different level of support for InnoDB Storage engine for every version of its release. The Default configuration settings for InnoDB also varies version wise. So its always a wise decision to ensure that if we are upgrading the MySQL and are having InnoDB as default Storage engine, then it does no harm • Read More »

Tags: , ,

Loading Microsoft IIS Logs into SQL Server 2012 with Log Parser

February 1, 2014 | By kiranbadi1991 | Comments Off on Loading Microsoft IIS Logs into SQL Server 2012 with Log Parser | Filed in: Database, Development, Performance Engineering, Performance Test Tools, Scripting, Web Server.

If you ever thing of building the customized tool for viewing and analyzing the IIS logs, the first thing, you will probably do is to think of some way of loading the IIS logs to some database specially MS SQL Express or MY SQL. Parsing the IIS logs and loading it into the database has • Read More »

Tags: , , , , , ,