There’s a common misconception in the IT industry. This misconception stems from the premise that the premises of your infrastructure will either be more expensive or less expensive based on its location. Okay, that may sound like a lot of metaphorical jibber jabber and mixed-speak, but that’s how the industry talks when backed into a corner. […]
Read More
So you’ve started planning your career using a VCDX skillset. Continuing on that same train of thought, I want to walk you through an additional concept that might help you decide what skills to develop next. In the last year, I’ve been preparing my organization for the new skills any infrastructure, network or storage admin […]
Read More
I think we’ve all had that moment at 3:00am on over the weekend when we wish our monitoring and management systems would just shut up. The UPS in rack 4’s battery life is at 40%, we GET it. But we’ve also had that moment when we tilt our head a bit looking at a monthly […]
Read More
Earlier this year I had the opportunity to speak at VMWorld in San Francisco. The session title was Using Virtual SAN to Maximize Database Performance, and in that session I spent time focusing on performance as well as recovery. Why would recovery be a part of the talk? Because: Every database administrator knows that […]
Read More
When it is not possible to eliminate an SQL statement to improve performance, it might be possible to simplify the statement. Consider the following questions: Are all columns required? Can a table join be removed? Is a join or WHERE restriction necessary for additional SQL statements in a given function? Column Improvement An important requirement […]
Read More
When it’s not possible to remove SQL statements that are unnecessary and the rate of change of common data is relatively low, caching SQL results can provide a significant performance boost to your application and enable additional scalability of your database server. MySQL Caching The MySQL query cache can provide a boost in performance for […]
Read More
Eliminating overhead that adds unnecessary load to database servers when SQL statements are unnecessary can improve MySQL performance, including removing duplicate, repeating or unnecessary statements. Removing Duplicate SQL Statements Capture of all SQL statements for a given function or process will highlight any duplicate SQL statements that are executed to complete a specific request. The […]
Read More
Adding indexes can provide significant performance benefits. However, the most effective SQL optimization for a relational database is to eliminate the need to execute the SQL statement completely. For a highly tuned application, the greatest amount of time for the total execution of the statement is the network overhead. Removing SQL statements can reduce the […]
Read More
In addition to creating new indexes to improve performance, you can improve database performance with additional schema optimizations. These optimizations include using specific data types and/or column types. The benefit is a smaller disk footprint producing less disk I/O and results in more index data being packed in available system memory. Data Types Several data […]
Read More
The management of indexes—how they are created and maintained—can impact the performance of SQL statements. Combining Your DDL An important management requirement when adding indexes to MySQL is the blocking nature of a DDL statement. Historically, the impact of an ALTER statement required that a new copy of the table be created. This could be […]
Read More
For companies that live and die by their databases, a one-shot backup isn’t really the perfect solution. Typically for such companies (think Yahoo! or Google), database access is a near-constant process, and database content changes continually, often on a second-by-second basis. Data replication, which involves continual data transfer between two (or more) servers to maintain a […]
Read More
Replication in MySQL is the dynamic process of synchronizing data between a primary (main) database server and one or more secondary (replica) database servers in near-real time. Using this process, it’s possible to create copies of one or more databases so that even if the primary server fails, data can still be recovered from one […]
Read More