…) 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. …
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 25 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: 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 write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… 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
… 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 17 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: 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: 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 …
