 |
The Center for Strategic IT & Security hosted a presentation by Jay Pipes, an industry leader in MySQL software. Jay's exuberance and knowledge provided a group of 35 - 40 IT professionals and students with an energetic discussion.
As Jay put it: You've got a spiffy new web application. Customers are raving about how cool everything looks and how neat all the new functionality is! In fact, you’ve just passed the one month mark and new customers are streaming to your site. Congratulations!
Two months pass, and then it happens. You get your first call from an angry customer. Their site is "crawling"; it takes fifteen seconds for the search results to appear. Then the emails start coming in confirming that the site is displaying some error message about too many connections.
Think it can't happen to you? Think again. All web applications have their breaking points and you need to know how to properly diagnose your schema and streamline your application code.
He covered topics including how to diagnose MySQL database performance bottlenecks using a variety of tools, how to identify and FIX problem SQL code, and how to build an effective indexing strategy. Other discussion points, the best practices for writing streamlined, efficient SQL code that takes advantage of MySQL's strengths, how to choose appropriate storage engines for different types of data, and how to adjust MySQL server parameters to squeeze the most performance out of an application. Included in the conversation was how to plan for growth, in your code and in your index strategy & about advanced index concepts.
Jay provided best practices on Data Base queries and Data Base Administration. The two hour presentation sparked interest and lively interactive audience discussion.
|