Category: Databases
-
Analyzing Swapping and CPU utilization in MySQL and Linux
Measuring CPU load while Linux is swapping
-
Lessons from a MySQL Performance Question
Investigating the questions and claims in a Reddit post about MySQL performance after changing hardware … and some other stuff.
-
Recovering SQL Server databases without a log file
I use two drives in RAID0 for my database server at home. This is pretty bad, for sure. The RAID0 log array has failed twice in six years. I probably should just drop the extra $80 to add a third drive and make RAID5, or buy a couple more and make RAID10. When the failure…
-
Crystal Disk Mark and SQL Server
Crystal Disk Mark isn’t the right tool for SQL Server disk subsystem evaluation
-
Thinking about Large Data an Scale-Out
Adam Jacobs wrote an article, which I believe was first published in Queue, paper called The Pathologies of Big Data, which looks at — you know — big data. The title begs the question of what “big data” really is, and the author doesn’t ignore that. Without saying it explicitly, he points out that the…