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

Displaying posts with tag: debug (reset)

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 5: "Profiling in Eclipse with OProfile"
+1 Vote Up -0Vote Down

Section 6: "Profile a real case"


Profiling & Debugging is an argument that would require an entire book, the aim of this(and the others) posts of this series is to give you the basic knowledge on how to work with these tools and techniques withing Eclipse. For instance if you want to learn to profile with OProfile you should study on the abundant and separate resources, you may start from:


read more

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 4: "Profiling in Eclipse - Preparation"
+0 Vote Up -0Vote Down

Section 5: "Prepare Eclipse for profiling"


In this part we will prepare Eclipse to profile our recently compiled(see Part 3) MariaDB(or MySQL).
Profiling means basically measuring where the time is spent by the application.
You may be interested in knowing how much time is spent in a specific function execution,
or you may want to know statistics about the dustribution of function calls, that is operating a data aggregation.

read more

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 3: "Running in Eclipse"
+4 Vote Up -0Vote Down


To run MariaDB from Eclipse we will actually create and install the tar.gz package resulting from compilation(See Part 2) in a separate directory, this will allow us to have MariaDB cleanly installed on a separate location and so it will be also easily possible to run it independently from Eclipse.

In these Blog posts series we assume:

yoda							as developer user

read more

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 2: "Compile in Eclipse"
+2 Vote Up -0Vote Down


2.1 Download and prepare sources folder

We will need a directory to use as our playground, if you create the user yoda in Section 1:

$ su - yoda
$ mkdir -p ~/playground

Download latest MariaDB 10 sources tar.gz and copy the archive into the above directory, you can latest sources from:

read more

Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 1: "Setup the building environment"
+0 Vote Up -0Vote Down
This guide will help you in compiling and debugging MariaDB (MySQL, Percona) within the Eclipse IDE on Linux and using cmake for source project preparation. It will be split in parts to keep each post lightweight and with a finite objective. At the end of reading this series of blog posts you should be able to:
  • Prepare for compilation any MariaDB (MySQL, Percona) source release based on cmake framework.
  • read more

    MySQL Stored Routines Debugger & Debugging API: sneak preview II, video
    +0 Vote Up -0Vote Down

    This is the 2nd sneak preview of common_schema's rdebug: debugger & debugging API for MySQL stored routines (see 1st preview here).

    rdebug will be released as part of common_schema, free and open sourced.

    In this sneak preview I present:

    • Compiling multiple routines with debug info
    • Starting/stopping a debug session
    • Step-over, step-in, step-out
    • Showing stack trace
    • Showing the next-statement to execute
    • Viewing and manipulating local routine variables
    • Misc. meta routines

    The quick technical overview

      [Read more...]
    MySQL Stored Routines Debugger & Debugging API: sneak preview video
    +2 Vote Up -0Vote Down

    This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines.

    MySQL does not provide server side debugging capabilities for stored routines. Some tools exist, including MySQL's own, that assist in stored routine debugging. These are all GUI based and, to the best of my knowledge, MS Windows based. There is one solution in alpha stage that is developed for Java/eclipse; I did not look at the code. See discussion here and here.

    An ideal solution would be to have debugging API in the server itself - independently of your client, programming language or operating system. To the

      [Read more...]
    How to obtain all executing queries from a core file
    Employee_Team +2 Vote Up -1Vote Down
    When investigating core files from crashes, one can quite easily figure out which query crashed, as we've seen.

    Sometimes you want to just list all the currently executing statements, this is useful for diagnosing hangs or corruptions.

    At least GDB 7 supports python macros, which can help us a lot here.   I use a core file from 5.5.27, also a non-debug build but not "stripped".   So it's a standard build made with -g allowing us to reference symbols.

    I wrote a simplistic macro to iterate through

      [Read more...]
    Using the MySQL stack trace to isolate bugs
    +2 Vote Up -0Vote Down

    I came across an interesting error reported on #mysql the other day. When I went through it with the reporter it looks like we uncovered up to two bugs in InnoDB (or rather XtraDB as it was Percona Server). I thought it might be useful to go through the error message, including the stack trace, to show that you don't need to be a developer to track down some useful information.

    read more

    How to produce a full stack trace for mysqld
    +0 Vote Up -0Vote Down

    The information here was adapted from the AskMonty Knowledgebase.

    There are two main parts to MariaDB and MySQL: The mysqld server and whatever client you use to interact with the server. The server is absolutely essential and must remain up and running. mysqld is normally very reliable, but there are rare occasions when it will fail. When mysqld fails hard (or core dump) it will, by default, write a stack trace in the 'hostname'.err file in the database directory. However, in some cases this is not enough to find out exactly what happened.

    If you ever run into a situation where mysqld crashes and the 'hostname'.err file does not contain enough information for your DBA or support provider to diagnose the problem, you may need to use

      [Read more...]
    Showing entries 1 to 10 of 15 5 Older Entries

    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.