… should. These are essential practices for building successful applications, which everyone should be …automated monitoring system that is watching key elements of their systems. This can …3. Capture and Store Historical Data Likewise, it is vital to have something recording metrics over time. A lot…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…3 hash tables would need to be created each containing a hash table on n/3 rows. And so both the build…| select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra | …a where clause on a ‘non-indexed’ column In this test we can clearly see that Hash Join gives a lot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… hour long, if we’re discussing a lot of things like how to build for massive scalability, how to … doing, in terms of performance. There are two key commands for this on most operating systems (there …A lot of times, customers will tell us up front to limit the work to some number of hours, such as 3…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…build complete refresh views on top of incrementally refreshable view, which can give you a lot… used to prevent wide innodb primary keys on the MV. mysql> select mview… | 1 | 689 | 770793 | 3811 | | 2 | 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 | | 4 | 5825 | 738420 | 3593 | | …
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… start at all. That’s a lot of rules to handle. Since …Pacemaker. A key new features that has been added to Pacemaker recently, a Clone … distributions, you might have to build from sources, look here for help…” score=”INFINITY”/>
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…a great new feature – ability to build indexes by sort instead of via insertion. This process can be a lot…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… are performed on table2. Of course this could mean a lot of random lookups in case the dataset does not …, and obviously when the first operand used in the build step is such that the hash table fits in …A 112 3 1133 1 1 Handler_mrr_key_refills N/A N/A N/A 0 0 0 Handler_mrr_rowid_refills N/A N/A N/A…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…of printout Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT =====================================…key which failed as well as the closest match which was located in parent table. There is a lot…hash index is hash index Innodb builds for some pages to speed…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…in set (0.00 sec) So we have about 3.7GB total size out of which 1.4GB is…_fast_index_creation=1 which builds table with primary key only when creating a table and when builds all indexes by sort…. enable expand_fast_index_creation it can make a whole process a lot faster. P.S The tests were done with…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… real life. It’s worth running this script on a seperate box with lot‘s of cores – it’s very thread-hungry…” ); # skip the first 3 lines (); (); (); # Process the query log, and build a couple of hashes from it: # # Hash 1: %queries – keyed by connection id… our of it, and have learned a lot about how our database behaves. Now – this is not a well tested script – it’s…
