…I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I… allocate a lot of memory to mysqld. Next I…I‘m on a machine with 32GB of memory and there is very little load. I see that mysqld is using 10g of memory with…mental calculation can then tell me how much total gain I can …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…allocate additional space outside of the page for _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much space InnoDB allocates…8-core boxes are going to be common place. We’re considering buying 40 8-core boxes with 32G of memory…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…can see for J2EE the system with 8 cores was used while for database 4 cores…have smaller sort buffer because allocating it will likely be faster. query_…to deal with implicit memory tables. innodb_file_per_table – so I assume…tuning option is rarely used so I‘m curious how much speed benefit did it…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…cores so we can forget about spinlocks wasting CPU time on single CPU boxes without much… 100K of memory not 8-16M as you need with page …I have 8GB of RAM I can assume I want 4GB allocated to row cache and I do not really care about how…see how “compact” they would be in real world cases and how much…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…can get 8 core x86-64 box with 32G with good price/performance value while if you would like to go significantly higher like 32 cores…-2GB of memory may be couple…as you can get server much …hard time allocating resources to get…how to optimize it another 10-15% may be a great idea. On higher end I…
