Articles having tag: TUNING

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most...

Setting up XFS on Hardware RAID — the simple edition

By Jay Janssen

There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. \xa0I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority...

Practical Solution to SQL Server Performance Monitoring

By Delicious/tag/asp.net

ASP Limits <limits> : Configuration Reference : The Official Microsoft IIS Site

By Delicious/tag/asp.net

Solving performance issues in data migration to SQL Server

By codeproject

How to solve performance issues in data migration to SQL Server.

Aligning IO on a hard disk RAID – the Theory

By Aurimas Mikalauskas

Now that flash storage is becoming more popular, IO alignment question keeps popping up more often than it used to when all we had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive (HDD)...

MySQL caching methods and tips

By Justin Swanhart

“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud,...