Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    12

    Question Unanswered: "MS SQL Profiler like" for MySQL ??

    Hi,

    i'm experiencing some strange behavior with updateing data using myDac and Delphi7. I'm using MyCommand with a simple SQL statement like
    update table set phone = NNNNN where id = IIIIII
    and most of the time it works fine, but then suddenly updates phone with a "near miss", like NNNNN+2 for example. Is there a way to find out what exatcly (sql statement) went to the server (something like Profiler for MS SQL) other than setting trace on startup (which according to the manual is meant mainly for debugging server crashes)? I have no triggers set on the table nor on the phone column. Any help would be much appreciated.

    Andrej

  2. #2
    Join Date
    Sep 2005
    Posts
    12

    Problem solved

    Problem was caused by updateing float field with integer value (), i'll just have to convert it into integer, but the question about "profiler like" tool is still open.

  3. #3
    Join Date
    Mar 2005
    Location
    Kiev, Ukraine
    Posts
    5
    mytop is a linux tool that shows you what your MySQL server is currently doing. Not exactly profiler-like (and I'm not 100% sure you can log its output), but better than nothing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •