…to help you determine how indexes are used in more flexible ways. The default report just prints out ALTER statements for removing unused… over the SSH tunnel to query EXPLAIN and find out the index usage on… comment_post_id = ? and comment_type not regexp ? and comment_approved = ? sample: SELECT …
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… wants to know how to deal with an application that is growing. The simplest way is to prevent… server really needs to keep in memory to function well. That’s because unused rows can bloat…not be telling you when the service is down. Be the first to know, and have enough information to help you find…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…have to decide on couple few questions on how to tackle …not be available and keeping unused spare box can be expensive. Because fewer users use these boxes you also likely to…find them in the situation when they have hard time allocating resources to get application optimized properly – they need to…
