… want to: relax InnoDB durability (innodb_flush_log_at_trx_commit) disable binary logging if it’s not useful look at… see that a single query takes most of the total response time of the server: that’s typical of a hot spot… case where one query was taking 90% of the total response time. Q: Do you have a recommendation on when to use…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…warnings is enabled. (Oleg Tsarev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev) innodb…the MySQL global system variable innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size… 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: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… summarize data. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data. Keeping MVs up…, is that triggers can not, under normal conditions, detect the commit order of transactions. This above all makes triggers an unacceptable…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… to warm the server: replay statements and then rollback at commit. That makes prefetch simple but has high overhead from locking… ANALYZE TABLE is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… to warm the server: replay statements and then rollback at commit. That makes prefetch simple but has high overhead from locking… ANALYZE TABLE is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 6 Comments
… | | Com_update | 5214 | | Com_delete | 385 | | Com_insert | 3468 | | Com_commit | 5404 | The result is quite chatty, | | [MEE] | [DM] | [CE] | sec… count of 11 different transactions per 10 secs and 90% response time. and final result [TradeResult(TR) transaction] Succeed: 150243 Lated: 0…
Comment: Performance impact of complex queries
January 22, 2007 By 11 Comments
… to many things like parsing worse cache hit rate, transaction commits etc. In some cases however these are less important compared… complex queries… You may not really care about batch job response time but mainly about response time of interactive queries.
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… of performance: That is to minimize variations in throughput Better response times: This is very important for database performance and I appreciate…_pool_size=120GB, 174GB and innodb_flush_log_at_trx_commit=1, 2. The results in this post are for case…_buffer_pool_size=174GB and innodb_flush_log_at_trx_commit=1 As in all my recent benchmarks, I use long…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… potential to block other queries for a significant amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative… percentile of small PK lookups. If you’re optimizing for response time, you would set it larger to accommodate the larger (important… innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in…
