Showing entries 1 to 5
Displaying posts with tag: trace (reset)
Profiling InfiniDB Multi-Join

Welcome to Profiling InfiniDB Multi-Join, part of a series designed to highlight different aspects of the InfiniDB join capabilities. InfiniDB is engineered and optimized to execute join operations for millions or billions of rows using a number of key features:



Hash Joins.
Parallel processing (multi-threaded and optionally distributed).
Join sequencing to minimize data shipping costs. (Right-deep join tree instead of left-deep).
InfiniDB multi-join (stream 1 large table past up to 60 hRead More...

Profiling InfiniDB Multi-Join

Welcome to Profiling InfiniDB Multi-Join, part of a series designed to highlight different aspects of the InfiniDB join capabilities. InfiniDB is engineered and optimized to execute join operations for millions or billions of rows using a number of key features:



Hash Joins.
Parallel processing (multi-threaded and optionally distributed).
Join sequencing to minimize data shipping costs. (Right-deep join tree instead of left-deep).
InfiniDB multi-join (stream 1 large table past up to 60 hRead More...

Profiling InfiniDB Multi-Join

Welcome to Profiling InfiniDB Multi-Join, part of a series designed to highlight different aspects of the InfiniDB join capabilities. InfiniDB is engineered and optimized to execute join operations for millions or billions of rows using a number of key features:



Hash Joins.
Parallel processing (multi-threaded and optionally distributed).
Join sequencing to minimize data shipping costs. (Right-deep join tree instead of left-deep).
InfiniDB multi-join (stream 1 large table past up to 60 hRead More...

Debugging AMP

In a previous post, I mentioned the availability of the dtrace extension for Cool Stack's PHP.  Using this extension and the Cool Stack MySQL, it is possible to analyze the performance of your application running on this stack. At JavaOne, we demoed this using the open source MediaWiki and SugarCRM applications.  dtrace is especially useful in analyzing complex multi-tier applications like AMP. Thanks to Angelo Rajadurai for the creation of the scripts that I describe below.

Analyzing PHP calls

So, let's look at a simple dtrace script that counts how many times a particular PHP function is called :

#!/usr/sbin/dtrace -Zqs

php*:::function-entry
/arg0/
{
        @[copyinstr(arg0)]=count();
}

You can copy the …

[Read more]
Turning on INSERT trace with dbmcli

DB User = dba
DB Pass = dba
DB Name = TEST
command = trace_on
argument = TRACE_INSERT

Voila:

$ dbmcli -u dba,dba -d TEST trace_on TRACE_INSERT

Showing entries 1 to 5