… probably should. These are essential practices for building successful applications, which everyone should be… 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… Hash Join gives a lot of reduction in query time. The reduction in query time for IO bound workload…rows from the table lineitem for each distinct key value. Also the joining key in this test case D…
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 …, in terms of performance. There are two key commands for this on most operating systems (there are…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…a special column `mview$pk` which is an auto_increment BIGINT surrogate key for the table. For…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 …you might have to build from sources, look here for help. There 2 minimal…” 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 faster, especially for…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…for example if table1 yields 1000 rows then 1000 index lookups are performed on table2. Of course this could mean a lot… table t2. This step is called the build step. After the hash table has been created…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
…tables in use 1, locked 1 3 lock struct(s), heap size 368…key which failed as well as the closest match which was located in parent table. There is a lot of scary information in hex but it is not important for most diagnostic… hash index is hash index Innodb builds for some pages to speed up …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… interesting. I used modified Sysbench table for these tests because original table as….00 sec) So we have about 3.7GB total size out of which…=1 which builds table with primary key only when creating a table and when builds all …_index_creation it can make a whole process a lot faster. P.S The tests…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…contents of query log – it creates a seperate thread for each connection, and runs each query … first 3 lines (); (); (); # Process the query log, and build a couple of hashes from it: # # Hash 1: %queries – keyed…and have learned a lot about how our database behaves. Now – this is not a well tested …
