… clearly explained here. The plugin writes its output in json format, and supports writing it directly to a file, or to…-maint”,”host”:”localhost”,”cmd”:”Connect”,”query”:”Connect”} {“msg-type”:”activity”,”date“:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…-maint”,”host”:”localhost”,”cmd”:”Quit”,”query”:”Quit”} {“msg-type”:”activity”,”date“:”1369155747383″,”thread-id”:”6440″,”query-id”:”0″,”user”:”debian-sys…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… to follow up with more SSB tests at a later date. I also promised more low concurrency SSB tests when Peter…_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, pt-query-digest 2.2 can save results in JSON format (–output=json). This feature is still in development while we… (Percona Toolkit tools, MySQL, Perl, etc.) are either out of date or are known bad versions. For example, there are two… may change things like the pt-query-digest –output json format in future releases after receiving real-world feedback. In summary…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… a fairly significant margin. The approximate raw numbers, in tabular format, are: – EXT4 XFS 13GiB BP 22000 7500 25GiB BP 17000… is the fastest one that I have personally seen to date.
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… submitted the odd datetime, and because the value passed the date-format check, it was allowed into the database. Oooops. What, then… it. Even if a piece of data matches the expected format, that does not mean that it’s a valid value… important lesson of all: Always, always range-check your input! Format-checking is not enough. One final aside – I was able…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… table dashboard_customer_sales AS select customer_id, customer_name, DATE_FORMAT(order_date,’%Y%m’) as sale_when, sum(quantity) as total…’,'customer_name’,'customer_name’); CALL flexviews.add_expr(@mvid,’GROUP’,’DATE_FORMAT(order_date,”%Y%m”)’,'sale_when’); CALL flexviews.add_expr(@mvid…_id) as `customer_id`, (customer_name) as `customer_name`, (DATE_FORMAT(order_date,’%Y%m’)) as `sale_when`, SUM(price * quantity) as `total…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Created_tmp_tablesblogpercona.commanual datadirblogpercona.commanual date_formatblogpercona.commanual datetime_formatblogpercona.commanual debugblogpercona….file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 8, 2007 By 22 Comments
…_NO_CACHE E.EntryID, E.Body, E.Subject, E.Private, DATE_FORMAT( E.Date, ‘%m-%d-%y’ ) As EDate, EHC.Hits FROM Entries… BY Date DESC LIMIT 1235,20 Final query: select sql_no_cache E.EntryID, E.Body, E.Subject, E.Private, DATE_FORMAT(E.Date… INDEX (DPrivate) where DiaryID=11693 and Private=0 Order By Date DESC LIMIT 1235,20) D LEFT JOIN Entries E USING…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… has been made to the slow query log in table format. Users of some MySQL appliances like Amazon RDS must use… the query log table into a flat file in the format of a conventional query log file, which you can then…-names –quick –silent –no-auto-rehash –compress $* SELECT CONCAT( ‘# Time: ‘, DATE_FORMAT(start_time, ‘%y%m%d %H:%i:%s’), CHAR(10…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… the stats from the application above for example: mysql> select date_format(logged,’%H’) h,count(*),avg(wtime),avg(sphinx_time/wtime…
