…a good product, that’s why I decided to test it. For tests I use sysbench fileio, 16KiB block size (to…to the peak throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time, which increases to…to recommend this drive for a database…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode allows to…response time. In general I have very good experience with this card, and it seems suitable to work with MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In a…TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to push the database…how does it affect the response time ? – When we put a load to two nodes instead of three nodes, will it help to improve the response time…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…a nutshell, it is a lightweight way to measure response times on a server such as a database…MySQL, this is the moral equivalent of a query’s response time. The statistics we chose to…to tune this exchange, so if you have suggestions on how to …s a first prototype release, and we want much more testing…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…a situation where a single connection sends two queries and gets two responses, with a response time of R for each request, and a wait time…database took 2R + W time to respond to the first request. Back to the question of, “what is a…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…a difference here and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database…to high concurrency response time in the first case is significantly better. It would be interesting however to run similar benchmarks on a…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…response times compared to accessing the non-aggregated data. Keeping MVs up-to-date (refreshing) is usually expensive. A…databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL…database. The first step is to find out what MySQL instances are on the machine. It doesn’t do to just assume there’s a…a non-trivial part of the app’s response time. And so on, and so on. I’ll often refer to…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks evaluates how… to test these queries on various engines and databases. Following is a list of the queries, followed by a response time table recording the actual response times …
