…with significant amounts of memory (or reducing amount of usable memory). The system …: multi-threaded system evaluation benchmark 128 files, 1024Kb each, 128Mb total …O_DIRECT however the impact is much less in this case compared to Write … optimize seeks. Lets us see how writes are doing: For writes …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…: How Innodb decided how many pages to flush at each checkpoint interval HT: Usually it is 128…8xN bytes will be allocated) Question: How much space InnoDB allocates for each …in conflict with the Linux kernel’s buffer pool. In high load situations where INNODB is using most of the system’s memory…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is…` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar…falcon_min_record_memory=1G –falcon_max_record_memory=2GB –… the results are much worse. READ_KEY_…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…In many cases however we’re facing a need to answer a question how much load a given system can handle when load is… how “wait free your system is“. If it system is already have low wait ratio increasing amount of memory for example is… # InnoDB: # IO r bytes 50 7.50G 0 128.00k 4.49k 15.96k 8.37k 0 # …
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… one) to demonstrate how much improvement could be made to MySQL so that is could better utilize all available resources (that is, scale better… workload fits entirely in the buffer pool so adding CPUs will help only until we run out of memory bandwidth. Test #2 My second test involved the next four queries on Vadim’s list. The purpose of this test is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…how I align IO, now I want to share results of the benchmark that I have been running to see how much…128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | MegaRAID SAS 8704EM2, PCIE interface, 8 ports Cache | 128MB Memory…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…much sense to me, since SQL is…is very little data shipping because of the distributed reduction discussed above. If you have any limitation in resources in a cluster (cpu, memory…IN list with 2 items * IN list compression is not required — 2 items is less than the inlist-merge-threshold of 128…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…in the /etc/my.cnf file if you really want to try micro instances.*EDIT* The storage worker currently logs too much…is important to examine the differences in size. This will give us some interesting information about how…in the need for fewer nodes in order to keep data entirely in memory…cache=128 …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…( why a smaller buffer pool? This simulates a much larger data set. A BP of 256M …is I started to hit bottlenecks in MySQL/Innodb when I had enough memory but I increased the threads from 64 to 128… try and understand whether an RDBMS is really needed or not. How did I do these tests: The …
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
… TCP traffic. What is this good for? In a nutshell, it is a lightweight way … 284181 25 442 127 7432 701 128 114 4157 173 293 1276827993 1448 …, so if you have suggestions on how to improve it, that’s great. …memory leaks or other problems. Nevertheless, it’s a first prototype release, and we want much…
