1. 22 Feb, 2007 4 commits
    • cmiller@zippy.cornsilk.net's avatar
      b9170b2c
    • cmiller@zippy.cornsilk.net's avatar
      1944bc11
    • cmiller@zippy.cornsilk.net's avatar
    • cmiller@zippy.cornsilk.net's avatar
      Prevent bugs by making DBUG_* expressions syntactically equivalent · 6e096ee8
      cmiller@zippy.cornsilk.net authored
      to a single statement.
      ---
      Bug#24795: SHOW PROFILE
      
      Profiling is only partially functional on some architectures.  Where 
      there is no getrusage() system call, presently Null values are 
      returned where it would be required.  Notably, Windows needs some love 
      applied to make it as useful.
      
        Syntax this adds:
        
        SHOW PROFILES
        
        SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
         where "n" is an integer
         and "types" is zero or many (comma-separated) of
            "CPU"
            "MEMORY" (not presently supported)
            "BLOCK IO"
            "CONTEXT SWITCHES"
            "PAGE FAULTS"
            "IPC"
            "SWAPS"
            "SOURCE"
            "ALL"
      
      It also adds a session variable (boolean) "profiling", set to "no"
      by default, and (integer) profiling_history_size, set to 15 by 
      default.
      
      This patch abstracts setting THDs' "proc_info" behind a macro that 
      can be used as a hook into the profiling code when profiling 
      support is compiled in.  All future code in this line should use
      that mechanism for setting thd->proc_info.
      
      ---
      
      Tests are now set to omit the statistics.
      
      ---
      
      Adds an Information_schema table, "profiling" for access to 
      "show profile" data.
      ---
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-community-3--bug24795
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-community
      ---
      Fix merge problems.
      ---
      Fixed one bug in the query_source being NULL.  
      
      Updated test results.
      ---
      Include more thorough profiling tests.
      
      Improve support for prepared statements.
      
      Use session-specific query IDs, starting at zero.
      ---
      Selecting from I_S.profiling is no longer quashed in profiling, as
      requested by Giuseppe.
      
      Limit the size of captured query text.
      
      No longer log queries that are zero length.
      6e096ee8
  2. 18 Jan, 2007 3 commits
  3. 14 Jan, 2007 1 commit
  4. 12 Jan, 2007 7 commits
  5. 11 Jan, 2007 9 commits
  6. 10 Jan, 2007 14 commits
  7. 09 Jan, 2007 2 commits
    • joerg@trift2.'s avatar
      support-files/MySQL-shared-compat.spec.sh : Dummy, irrelevant change -... · b63c167f
      joerg@trift2. authored
      support-files/MySQL-shared-compat.spec.sh  :    Dummy, irrelevant change - just trigger a new build.
      b63c167f
    • evgen@moonbone.local's avatar
      Fixed bug#16861: User defined variable can have a wrong value if a tmp table was · e098f736
      evgen@moonbone.local authored
      used.
      
      The Item::save_in_field() function is called from fill_record() to fill the 
      new row with data while execution of the CREATE TABLE ... SELECT statement.
      Item::save_in_field() calls val_xxx() methods in order to get values.
      val_xxx() methods do not take into account the result field. Due to this
      Item_func_set_user_var::val_xxx() methods returns values from the original
      table, not from the temporary one.
      
      The save_in_field() member function is added to the Item_func_set_user_var
      class. It detects whether the result field should be used and properly updates
      the value of the user variable.
      e098f736