… to a MySQL guy. Notes on MonetDB MonetDB was a bit different. I had to be a bit resourceful… 4 million rows into it (this was a 32-bit Amazon machine). The SQL implementation is impressive. It…-purpose” database use — there are a number of limitations (concurrency, for one) and it looks like it…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
…affect MySQL performance in general. This time I would like to explore this topic from a bit different…16 real cores + enabled hyper-threading gives us total – 32 vcpu. In my tests I didn’t … otherwise the performance will be limited by glibc/malloc and not by MySQL. Notes regarding jemalloc version I…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… 2x faster then combining memcached and MySQL, and about 20% slower then the… benchmarks, my server resources are rather limited but I thought I should try…’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…
Comment: The #1 mistake hosting providers make for MySQL servers
July 29, 2008 By 30 Comments
“… MySQL can’t use it because it runs in a single process, which is limited to about 2.5GB of memory.” Does this also apply to 32-bit Windows environments running on 64-bit hardware?
Comment: What to tune in MySQL Server after installation
October 3, 2006 By 118 Comments
… RAM (32G), but with the inherent per-process memory limitations of a 32-bit system. I work with a couple of servers with…. I know some buffers are allocated only once for all MySQL threads/processes, and others are per-thread or per-connection…
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…the page data size drops below this limit, merging it to a neighbor is tried … than 128 pages would require a bit more work. Now it is allocated… ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_…
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
… took sysbench oltp ( both read-only and read-write) and MySQL 5.6.2 as it seems most scalable system at…. Both systems scales pretty decent up to 32 threads, with AMD a little bit slower. After 32 threads, system based on Intel handles…. I actually suspect this is rather MySQL problem, and 32 cores may be limit of scaling for MySQL 5.6. Anyway, we have PERFORMANCE…
Comment: Speeding up GROUP BY if you want aproximate results
April 9, 2008 By 24 Comments
… a bit further and discovered GROUP BY was only taking 2^32 as a max. If I cast crc32 to BINARY though, my results worked perfectly. mysql… crc32(tag) -> ORDER BY count DESC -> LIMIT 10 -> ; +————+——-+————+——————-+ | tag | count | crc32(tag) | BINARY crc32(tag) |…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… you would like to go significantly higher like 32 cores and 128G of RAM it is going… are problems. Over time application still will be limited by MySQL server so the alternative would be either spend… would just need another server a bit later. However if you have 100 MySQL servers to deal with even …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…MonetDB version: server v5.14.2, based on kernel v1.32.2 LucidDB was 0.9.1 The table I … very limited and I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-… for each carrier for 2007 year. It is a bit more trickier, as for InfoBright and MonetDB you need …
