…, response time) while less work is being done in terms of requests per second. Should be easy to see on the graphs. If… mistaken, it is not always just one issue which is responsible for everything. Quite often it is many things which come… bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… be something. This is actually where Trending often comes handy – graphs would often expose which metrics became different, they just need… just dies with the high traffic ? How high is the response time penalty and how long it takes to reach normal performance… Caches In some cases when cold performance gives too bad response time you may want to prime the caches by running/replaying…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… describe few less interesting numbers first, then I’ll show graphs for more interesting results. Let me know if you thought… was in fact lower number of IO operations and higher response time – so it seems in this case misaligned IO had some… the OS perspective is very similar, due to high concurrency response time in the first case is significantly better. It would be…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… 10x) improvement over the baseline, as shown in the following graph: One significant advantage of Shard-Query over Hive is that… a list of the queries, followed by a response time table recording the actual response times for each query. The queries should be self… your data over multiple machines, scaling out to improve query response times significantly. These queries are a great test of Shard-Query…
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… Backend optimization first, have monitoring and graphing setup based on the main HTML page response this means quite frequently we speak about… backend is reasonably fast say you can have under 100ms response time on main HTML page there are still reasons to optimize…. If you can come up with idea to provide same response time just with lower hardware requirements you can save on hardware…
Post: Testing Intel SSD 520
May 1, 2012 By 8 Comments
…. To better understand response time ranges, we need to switch to synchronous IO and vary amount of threads. Throughput: And response times: We still see small hiccups in throughput and response times even for small amount of threads. For 8 threads the 95% response time is… async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1 thread…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
… to observe some artifacts, as you will see in following graphs. Hardware for tests: HP ProLiant DL380 G6, filesystem: ext4, mounted… internal cache or something. To understand better what kind of response time we should expect, I ran random read sync IO mode… throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time, which increases to 1.62ms under…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
… to observe some artifacts, as you will see in following graphs. Hardware for tests: HP ProLiant DL380 G6, filesystem: ext4, mounted… line 222 MiB/sec To understand better what kind of response time we should expect, I ran random read sync IO mode… peak throughput at 8 threads. And response time: For 8 threads, we may expect 0.62ms response time. In general I have very good…
Comment: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 15, 2010 By 13 Comments
… that one day. I have response time histograms for XtraDB and InnoDB-plugin XtraDB: 1.New-Order (time,sec) (count of transactions) 0… that increased throughput affects response time, from queue theory, the response time grow exponentially on increasing throughput. First part on RAID10 graph is just buffer…
Post: Intel 520 SSD in MySQL sysbench oltp benchmark
May 21, 2012 By 11 Comments
… saw that the drive does not provide uniform throughput and response time, but it is interesting how does it affect workload if… there. There I want to publish graphs to compare Intel 520 vs regular RAID10. Throughput: Response time: So despite big variation in raw…, and single Intel 520 SSD gives much better throughput and response time comparing with traditional SAS RAID, and what is interesting it…
