… A full performance audit is far more extensive than this… the lead consultant does. We want two …64-bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit… 64-bit build, if I’m on a 64-bit OS. Examining MySQL…more efficiently and with better results, due to …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL … the comments of the last post. ICE does not have any indexes (not even primary keys… In general, a column store performs about 8x-10x better than a row store for queries which …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…getting better…64 box with 32G with good price/performance value while if you would like to go significantly higher like 32…64 CPU you can buy would be unlikely more than 2-3 times faster than…does not give you much benefit – you would just need another server a bit later. However if you have 100 MySQL…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…MySQL Performance evaluation on TPC-H…MySQL Also was very slow running some queries so we changed scripts a bit…than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL…queries (Query8 and Query20) which MySQL 6.0 does better but there is also … too bad, however with 16,32,64 cores it …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… leaf nodes. The first 32 pages of a segment are…IO pressure workloads. Q7: Does Innodb has any protection…64 page extent is often done as a single 1 MB file read. PZ: “often” a bit… even that is often better than bad thrashing. Q22: Also,…can get better performance by using couple of MySQL Servers on …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…normally posts about 64 page read …better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot of performance…performance (keeping data smaller) or can a bit…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32… contention? How does this fit into…
