… a lot of things like how to build…level of tuning, from completely untuned to a system that’s already had a lot of expert attention. I use “tuning” in a…a 32-bit OS on 64-bit hardware, which is important if you want to allocate a lot…2 hours, and came back to the client with “there’s not a lot…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…32 ‘fragment extent’ pages. PZ: This is the reason why when you delete a lot of scattered rows you may not see a “free space” in…in 5.1: if you set the transaction isolation level… 768. 2. InnoDB…build up INSERTS on our clients and insert values 50 or so at a…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…more application changes such as building summary tables, significant schema changes, … go significantly higher like 32 cores and 128G of … others (like excessive row level locks) may be caused by… than 2-3 times faster than the one in laptop I…risks. In the early stage it often makes sense to do a lot…
