…databases, we care most about the work the database is doing. That is, queries. There are other things we care about, but not…not optimal ( e.g. full tablescan, not using indexes). The trick is not to look for sub-optimality, but which SQL statement have a big impact on the database…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…the conferences, read on the blogs, forums and Internet articles and they ask me if they should use them. My advice is frequently – do not. It is…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…if Innodb needs to do crash recovery. I’m often something like what…the database and may not be as buffer pool flushes are not predictable. As Innodb is…the crash Even though this looks like something which has serious impact in reality it is not that significant. If checkpoints are not…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…impacting variables. For example are you selling 100 items or millions of items as amazon.com. What…optimization you can even get it to 5000 orders/min from the…is the same for database server handling custom application – no it is not. So am I saying we do not… sure there is not catastrophy if you …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…If you get bitten, the impact can be severe. But the likelihood of that happening is not extremely high in the…the way that the application uses the database. These changes can give a much greater improvement in your database…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
…the box is having or is it worse than that ? Swapping is going to impact…The database internals algorithms are tuned for things being in memory and if they start dealing with data which is…do react on them promptly and do not…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…impacts application functionality wise. As long a you go over normal upgrade checks you should be fine. Q: What are the…is jumping over 2 Major versions and many years of development so it is the road less traveled and something not…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…what is happening in the server. To generate some load on the database I’m going to use the benchmark software tpcc-mysql. After some runs we…is our job to check and benchmark the changes on our testing environment to measure the impact…
