…. The plugin writes its output in json format, and supports writing it directly to a file…the plugin is its flexibility, and not its performance, which seems to be on par with …”,”cmd”:”Connect”,”query”:”Connect”} {“msg-type”:”activity”,”date“:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… at a later date. I also promised more low concurrency SSB tests when Peter blogged about the importance of performance at low… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I…_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…asynchronous mode, read performance is an extremely steady 3202MiB/sec with almost no deviation. Write performance is also both very…fairly significant margin. The approximate raw numbers, in tabular format, are: – EXT4 XFS 13GiB BP 22000 7500 25GiB BP… fastest one that I have personally seen to date…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…’,'customer_name’,'customer_name’); CALL flexviews.add_expr(@mvid,’GROUP’,’DATE_FORMAT(order_date,”%Y%m”)’,'sale_when’); CALL flexviews.add_expr(@mvid….03 sec) Notice the difference in response time. Refresh method performance comparison For demonstration purposes, I did the following: Created one…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… mention looking at performance statistics for the day overall is often not enough. Application performs as good as it performs during its worst… example: mysql> select date_format(logged,’%H’) h,count(*),avg(wtime),avg(sphinx_time/wtime) sphinx_ratio from performance_log_081221 where page…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters?…server I start off with these commands: date uname -a cat /etc/*release The …sent | 7796961 | | Com_admin_commands | 11893 | … snip … Then I format the second set of values up beside…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…the values in the date_id column. There will be another blog post about the usage and performance of the splitter. It…*************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_… DEFAULT NULL, `l_shipDATE` date DEFAULT NULL, `l_commitDATE` date DEFAULT NULL, `l_receiptDATE` date DEFAULT NULL, `l_… in comparison. Block Nested Loop Join would perform better than Hash Join when you are …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…the non-aggregated data. Keeping MVs up-to-date (refreshing) is usually expensive. A change data … database table, or tables for changes. Improve ETL performance by identifying the data which has changed. Maintain… so there is no worry about binary log format changes. FlexCDC is written in PHP so it…
