…) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = … not different MySQL configurations, I didn’t try out different MySQL versions … 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 long… observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a… for query processing was not too bad, however with 16,32,64 cores it is just too bad.
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… 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…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 27 Comments
…MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s a quick excerpt Sometimes you need… PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you… about the mess that 64-bit integers are in PHP. But if the numbers you use do not cover 64-bit range fully, floats…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: A query thread normally posts about 64 page read requests per a readahead…xx. PZ: I should note MySQL 5.0 vs 4.1 has a …Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32…manageable. MySQL Master Master Manager can help you to automate it a bit. I…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… change? One knock on Tokyo -vs- Memcached is Tokyo is not distributed … MySQL/Innodb when I had enough memory but I increased the threads from 64 to…area’s where Tyrant may stumble a bit. Bottom line given a specific application …: The above number were run with 32 Threads, Tyrant was started with 8…
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… and it would write at 100MBps vs 33MBps. Any plans to enable tuning… ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… risks . First lets talk about optimizing application vs getting better hardware. With application optimization …64 box with 32G with good price/performance value while if you would like to go significantly higher like 32… need another server a bit later. However if you have 100 MySQL servers to deal …
