…) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = …5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql… still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…which this box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely …it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run…for query processing was not too bad, however with 16,32,64 cores it is just too bad.
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…the other for leaf nodes. The first 32 pages of a segment are allocated from …64 page extent is often done as a single 1 MB file read. PZ: “often” a bit… one of little known new features in MySQL 5.1 Q15: How frequently does Innodb … and it would write at 100MBps vs 33MBps. Any plans to enable tuning …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… thread normally posts about 64 page read requests …5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32…MySQL Master Master Manager can help you to automate it a bit…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there… to read other columns. But for 6 picture is a bit different. At start I had: Device: rrqm/s wrqm/s… 1.23 534.29 1.85 132547.02 24.64 66273.51 12.32 247.27 0.30 0.55 0.55…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… One knock on Tokyo -vs- Memcached is Tokyo is not…MySQL/Innodb when I had enough memory but I increased the threads from 64… where Tyrant may stumble a bit. Bottom line given a … above number were run with 32 Threads, Tyrant was started … threads ( 1.4 memcached ), mysql was 5.1 XtraDB. Each …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… First lets talk about optimizing application vs getting better hardware. With …64 box with 32G with good price/performance value while if you would like to go significantly higher like 32… subsystem which would cost $5-10K or some $500 … server a bit later. However if you have 100 MySQL servers …
