…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… would benefit a lot from fast compression, such as QuickLZ. Results sets for most queries is highly compressible and light compression… operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform performance as you get very… queries. The good thing about MySQL Query Cache is it knows exactly what is needed to refresh its content and so it…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, … #14 ==9090== at 0x6B79F6F: os_aio_refresh_stats (os0file.c:4408) ==9090== by 0x6BC459F…by 0x6A87FC: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==9090== …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… great thing about Pacemaker is its flexibility but flexibility may results in complexity. With the help of people from the Pacemaker…-quorum-policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… the queries to finish, then projects the synchronously maintained incrementally refreshable materialized view that represents the output. There is no external… right now only MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from the slowest node…
Post: Bug fix of InnoDB scalability problem
November 14, 2006 By 13 Comments
… and now I have it in my hands. Let me refresh results with MySQL 5.0.27 (without bugfix): select sql_calc_found… expecting the same time of execution for each thread). The results with 5.0.30-bk: 1 thread: 19 sec 4…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 2 Comments
… you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it… is lower because incremental refresh is faster than recomputing the contents from scratch. The contents of the result set are updated periodically… a convenient method of creating and refreshing the materialized results The second is refresh method is incremental refresh. This method updates the view. It…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… io-bound benchmarks I made it 3GB. Raw results and rest of mysql parameters are here http://spreadsheets.google.com/ccc?key…. In-memory benchmark, results during run: And averaged final result: As you see XtraDB, 5.0.83-percona and MySQL 5.4 are… XtraDB if 5.4 has the same performance, let me refresh: – XtraDB is based on InnoDB plugin 1.0.3, with…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… the work to move the patches to 5.1. To refresh, the most interesting patches are: Performance patches for InnoDB Â… finalize are results for tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43. The results made for… was stored on FusionIO 320GB MLC card. On chart with results I show amount of TradeResults transactions per 10 sec during…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times… ———- SEMAPHORES ———- … snip … Keep in mind the file will only be refreshed when you run SHOW ENGINE InnoDB STATUS command.
