Datavail Experts Blog
Where the DBA Experts Share Their Thoughts
InnoDB Conversion to File Per Table
04/23/2012 - By Charleste King
What’s the problem?Your MySQL database was working well, humming along nicely, but quite suddenly performance went south, especially during periods of heavy usage. Maybe you’re seeing deadlocks, or it’s just incredibly slow. If your MySQL database is using InnoDB there is a good chance you need to change your InnoDB storage. If you database is using MyISAM and you’re getting table locking issues, chances are it’s time to go to InnoDB, and you need to enable file-per-table before you convert the databases to InnoDB.
Read more No comment.Read/Write Comment
Top 10 Reasons DBAs Quit
09/28/2011 - By Sloane Stricker
The role of the DBA is an anomaly in the IT environment. DBAs are often extremely critical yet hidden from view; highly paid yet individual contributors; and very knowledgeable yet rarely consulted. So why does an extremely critical, highly paid, and very knowledgeable resource have a high risk profile for quitting? What factors can an [...]
Read more 5 comment(s)Read/Write Comment
Database Monitoring
09/13/2011 - By Sloane Stricker
With today's mission-critical 24×7 applications, monitoring your databases can be just as important as the actual database or DBA itself. But how do you know if your company’s current approach to monitoring is the right one? In my experience, companies tend to select a database monitoring solution based upon a DBA’s personal preference/experience often without [...]
Read more 2 comment(s)Read/Write Comment
The New DBA Reality
08/16/2011 - By Sloane Stricker
The Database Administrator is one of the most difficult positions to fill and retain. DBAs must be able to react, communicate, and plan across many different business functions. They are not easy to find and are often shockingly costly as a percentage of IT payroll. Prior to the evolution of today’s comprehensive systems and greater reliance on data by 24×7 [...]
Read more 3 comment(s)Read/Write Comment
How Much More Time Until That Backup/Restore is Done?
07/13/2010 - By Eric Russo
SQL Server Database Administrators always get to hear the age old question: How much longer will that restore or backup take? We've always answered this question based on past experiences along with some educated "guestimations." Now, with this query you will be able to give them an answer. Use the query below to return an [...]
Read more 2 comment(s)Read/Write Comment
Most Popular
Archives


