May 24, 2012

Post: Evaluating IO subsystem performance for MySQL Needs

…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

…: 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

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

In many cases however we’re facing a need to answer a question how much load a given system can handle when load ishow “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

… 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

how I align IO, now I want to share results of the benchmark that I have been running to see how much128 # 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

much sense to me, since SQL isis very little data shipping because of the distributed reduction discussed above. If you have any limitation in resources in a cluster (cpu, memoryIN 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

in the /etc/my.cnf file if you really want to try micro instances.*EDIT* The storage worker currently logs too muchis important to examine the differences in size. This will give us some interesting information about howin the need for fewer nodes in order to keep data entirely in memory…cache=128

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3

…( 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

… 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