Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: trace (reset)

Profiling InfiniDB Multi-Join
+0 Vote Up -0Vote Down

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
+3 Vote Up -0Vote Down

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
+0 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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 …



  [Read more...]
Turning on INSERT trace with dbmcli
+0 Vote Up -0Vote Down

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

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.