…other for leaf nodes. The first 32 pages of a segment are allocated … page data size drops below this limit, merging it to a neighbor is tried…MySQL Server option, though it may have problems on Linux if you lock very large portion of physical memory… 128 pages would require a bit more work. Now it is …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…data smaller) or can a bit slow it down. Plus…on the availability of RAM? On a dedicated server for Mysql you will still need some memory…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32…testing going on to quantify what are the limits of different…
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…memory, so it is full CPU bound benchmark. The full numbers, script and config are on…32 threads, with AMD a little bit slower. After 32 threads, system based on Intel handles 48-256 threads pretty decent, but on… this is rather MySQL problem, and 32 cores may be limit of scaling for MySQL 5.6. Anyway…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… to go significantly higher like 32 cores and 128G of RAM …on some dedicated (or even virtual) rented server which would usually have 1-2GB of memory…be limited by MySQL server so the alternative would be either spend $5000 on …need another server a bit later. However if you have 100 MySQL servers to …
