1. 30 Jul, 2007 2 commits
    • unknown's avatar
      Slow query log to file now displays queries with microsecond precission · 21e25f8b
      unknown authored
      --long-query-time is now given in seconds with microseconds as decimals
      --min_examined_row_limit added for slow query log
      long_query_time user variable is now double with 6 decimals
      Added functions to get time in microseconds
      Added faster time() functions for system that has gethrtime()  (Solaris)
      We now do less time() calls.
      Added field->in_read_set() and field->in_write_set() for easier field manipulation by handlers
      set_var.cc and my_getopt() can now handle DOUBLE variables.
      All time() calls changed to my_time()
      my_time() now does retry's if time() call fails.
      Added debug function for stopping in mysql_admin_table() when tables are locked
      Some trivial function and struct variable renames to avoid merge errors.
      Fixed compiler warnings
      Initialization of some time variables on windows moved to my_init() 
      
      
      include/my_getopt.h:
        Added support for double arguments
      include/my_sys.h:
        Fixed wrong type to packfrm()
        Added new my_time functions
      include/mysql/plugin.h:
        Added support for DOUBLE
      libmysql/CMakeLists.txt:
        Added new time functions
      libmysql/Makefile.shared:
        Added new time functions
      mysql-test/r/variables.result:
        Testing of long_query_time
      mysql-test/t/variables.test:
        Testing of long_query_time
      mysys/charset.c:
        Fixed compiler warnings
      mysys/default_modify.c:
        Fixed compiler warnings
      mysys/hash.c:
        Fixed compiler warnings
      mysys/mf_getdate.c:
        Use my_time()
      mysys/mf_iocache2.c:
        Fixed compiler warnings
      mysys/mf_pack.c:
        Fixed compiler warnings
      mysys/mf_path.c:
        Fixed compiler warnings
      mysys/my_append.c:
        Fixed compiler warnings
      mysys/my_compress.c:
        Fixed compiler warnings
      mysys/my_copy.c:
        Fixed compiler warnings
      mysys/my_gethwaddr.c:
        Fixed compiler warnings
      mysys/my_getopt.c:
        Added support for double arguments
      mysys/my_getsystime.c:
        Added functions to get time in microseconds.
        Added faster time() functions for system that has gethrtime()  (Solaris)
        Moved windows initialization code to my_init()
      mysys/my_init.c:
        Added initializing of variables needed for windows time functions
      mysys/my_static.c:
        Added variables needed for windows time functions
      mysys/my_static.h:
        Added variables needed for windows time functions
      mysys/my_thr_init.c:
        Added THR_LOCK_time, used for faster my_time()
      mysys/mysys_priv.h:
        Added THR_LOCK_time, used for faster my_time()
      mysys/thr_alarm.c:
        time() -> my_time()
      sql/event_data_objects.cc:
        end_time() -> set_current_time()
      sql/event_queue.cc:
        end_time() -> set_current_time()
      sql/event_scheduler.cc:
        Fixed compiler warnings
      sql/field.h:
        Added field->in_read_set() and field->in_write_set() for easier field manipulation by handlers
      sql/item.h:
        Added decimal to Item_float(double)
      sql/item_cmpfunc.h:
        Added decimal to Item_float(double)
      sql/item_timefunc.cc:
        time() -> my_time()
      sql/item_xmlfunc.cc:
        Fixed compiler warning
      sql/lock.cc:
        lock_time() -> set_time_after_lock()
      sql/log.cc:
        Timing in slow query log to file is now done in microseconds
        Changed some while() loops to for() loops.
        Fixed indentation
        time() -> my_time()
      sql/log.h:
        Slow query logging is now done based on microseconds
      sql/log_event.cc:
        time() -> my_time()
        Fixed arguments to new Item_float()
      sql/mysql_priv.h:
        Fixed compiler warnings
        Added opt_log_slow_slave_statements
      sql/mysqld.cc:
        Added --log_slow_slave_statements and --min_examined_row_limit
        --long-query-time now takes a double argument with microsecond resolution
        Don't write shutdown message when using --help
        Removed not needed \n
        Thread create time and connect time is now done in microseconds
        time() -> my_time()
        Avoid some time() calls
      sql/net_serv.cc:
        Fixed compiler warnings
      sql/parse_file.cc:
        time() -> my_time()
      sql/set_var.cc:
        Added support for DOUBLE variables
        Added support for variables that are given in seconds with microsecond resolution
      sql/set_var.h:
        Added support for variables that are given in seconds with microsecond resolution
      sql/slave.cc:
        Allow logging of slave queries to slow query log if 'opt_log_slow_slave_statements' is given
        time() -> my_time()
      sql/sql_cache.h:
        Fixed compiler warning()
      sql/sql_class.cc:
        Initialize new THD variables
      sql/sql_class.h:
        long_query_time is now in microseconds
        Added min_examined_row_limit
        Reordered some THD elements for higher efficency
        Added timers in microseconds (connect_utime, thr_create_utime, start_utime and utime_after_lock)
        Start of query is now recorded both in seconds and in microseconds.
        Following renames was made for more clarity and avoid merge problems from earlier versions:
        connect_time -> connect_utime
        thr_create_time -> thr_create_utime
        end_time()  -> set_current_time()
        lock_time() -> set_time_after_lock()
        
        Added THD::start_utime, which is start of query in microseconds from some arbitary time
        Added function THD::current_utime()
        
        Removed safe_time() as retry's are handled in my_time()
      sql/sql_connect.cc:
        User resources are now using microsecond resolution
      sql/sql_insert.cc:
        end_time() -> set_current_time()
      sql-common/client.c:
        time() -> my_time()
      sql/sql_parse.cc:
        Testing if we should print to slow_query_log() is now done with microsecond precission.
        If min_examined_row_limit is given, only log queries to slow query log that has examined more rows than this.
      sql/sql_select.cc:
        Simplify code now that Item_float() takes decimals as argument
      sql/sql_show.cc:
        time() -> my_time()
        Added support for SYS_DOUBLE
      sql/sql_table.cc:
        Added debug function for stopping in mysql_admin_table() when tables are locked
      sql/structs.h:
        intime -> reset_utime
      21e25f8b
    • unknown's avatar
      Add 'extension' field to all client library structures to make them extensible · c5d66dc6
      unknown authored
      Reorder structure elements to make structures smaller and faster on 64 bit systems
      This is a first step in cleaning up the client include files (but should be enough to allow us to do future fixes without breaking the library)
      This change is part of WL#2872,  Make client library extensible.
      
      
      configure.in:
        Increased shared library version of client library
        Detect gethrtime (for future)
      include/mysql.h:
        Add 'extension' field to all structures to make them extensible
        Reorder structure elements to make structures smaller and faster on 64 bit systems
        Removed an old define that is not needed for MySQL 5.1
      include/mysql_com.h:
        Add 'extension' field to all structures to make them extensible
        Reorder structure elements to make structures smaller and faster on 64 bit systems
      c5d66dc6
  2. 24 Jul, 2007 1 commit
    • unknown's avatar
      Added support for 'internal temporary tables' in HEAP tables. · eed1f001
      unknown authored
      Now we don't take any mutexes when creating or dropping internal HEAP tables during SELECT.
      Change buffer sizes to size_t to make keycache 64 bit safe on platforms where sizeof(ulong) != sizeof(size_t)
      
      
      BitKeeper/etc/ignore:
        added support-files/mysqld_multi.server
      include/heap.h:
        Added 'internal_table' to HP_CREATE_INFO
      include/keycache.h:
        Change buffer sizes to size_t to make keycache 64 bit safe
      include/my_base.h:
        Added HA_OPEN_INTERNAL_TABLE to mark temporary tables that should be deleted on close
      mysys/mf_keycache.c:
        Change buffer sizes to size_t to make keycache 64 bit safe
      sql/sql_select.cc:
        Added HA_OPEN_INTERNAL_TABLE to mark temporary tables that should be deleted on close
        Removed not anymore needed call to delete_table()
      storage/heap/ha_heap.cc:
        Added support for internal temporary tables that should be deleted on close.
        Internal tables now use dedicated open and close calls to avoid taking mutexes.
        If heap_open() failes, now delete the newly created table. (This fixes a possible memory leak)
        Remove never executed info() in create()
      storage/heap/ha_heap.h:
        Added slots needed to handle internal temporary tables
      storage/heap/heapdef.h:
        Protect against C++ inclusion
      storage/heap/hp_close.c:
        Don't call list_delete() for internal temporary tables (They are not in the list)
      storage/heap/hp_create.c:
        Added HP_SHARE ** element to heap_create() to store the SHARE of the newly created table.
        For internal temporary tables: Don't take any mutex and don't put them into the open table list.
      storage/heap/hp_open.c:
        Split heap_open() into sub functions to be able to create internal temporary tables without putting them in the heap_share_list.
        Add faster open() functions for when we already know the 'share'.
      storage/heap/hp_test1.c:
        Update call to heap_create()
        Initialize all keyinfo members.
      storage/heap/hp_test2.c:
        Update call to heap_create()
      eed1f001
  3. 23 Jul, 2007 1 commit
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1 · dafcbfa8
      unknown authored
      into  mysql.com:/home/my/mysql-5.1
      
      
      client/mysqltest.c:
        Auto merged
      mysql-test/lib/mtr_report.pl:
        Auto merged
      mysql-test/t/disabled.def:
        Auto merged
      mysys/hash.c:
        Auto merged
      mysys/my_conio.c:
        Auto merged
      sql/ha_ndbcluster_binlog.cc:
        Auto merged
      sql/ha_partition.cc:
        Auto merged
      sql/log.cc:
        Auto merged
      sql/slave.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/stacktrace.c:
        Auto merged
      strings/ctype-ucs2.c:
        Auto merged
      dafcbfa8
  4. 21 Jul, 2007 1 commit
    • unknown's avatar
      Merge trift2.:/MySQL/M50/push-5.0 · 9e9f196b
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      
      libmysql/libmysql.c:
        Auto merged
      scripts/make_binary_distribution.sh:
        Auto merged
      sql/field.cc:
        Auto merged
      9e9f196b
  5. 20 Jul, 2007 10 commits
  6. 19 Jul, 2007 25 commits
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.1 · 496ddec1
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      mysql-test/t/disabled.def:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_insert.cc:
        SCCS merged
      tests/mysql_client_test.c:
        SCCS merged
      496ddec1
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0 · 900f8d8a
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      
      sql/set_var.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      900f8d8a
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · 5c4c5941
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      mysql-test/r/func_gconcat.result:
        Auto merged
      mysql-test/t/func_gconcat.test:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      5c4c5941
    • unknown's avatar
      Merge pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0.44 · 25491503
      unknown authored
      into  pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0.46
      
      
      configure.in:
        Auto merged
      libmysql/libmysql.c:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      25491503
    • unknown's avatar
      BUG#20815 Errno 12 on Windows after 197 connections · 2163d202
      unknown authored
      
      CMakeLists.txt:
        BUG#20815 Set stack size. This value is really supposed to be the linker's default. I'm not quite sure why we have to specify it manually too.
      2163d202
    • unknown's avatar
      Bug#29898: Item_date_typecast::val_int doesn't reset the null_value flag. · 7122b729
      unknown authored
      The Item_date_typecast::val_int function doesn't reset null_value flag.
      This makes all values that follows the first null value to be treated as nulls
      and led to a wrong result.
      
      Now the Item_date_typecast::val_int function correctly sets the null_value flag
      for both null and non-null values.
      
      
      mysql-test/t/cast.test:
        Added a test case for the bug#29898:  Item_date_typecast::val_int doesn't reset
        the null_value flag.
      mysql-test/r/cast.result:
        Added a test case for the bug#29898:  Item_date_typecast::val_int doesn't reset
        the null_value flag.
      sql/item_timefunc.cc:
        Bug#29898: Item_date_typecast::val_int doesn't reset the null_value flag.
        Now the Item_date_typecast::val_int function correctly sets the null_value flag
        for both null and non-null values.
      7122b729
    • unknown's avatar
      mysql_client_test fixed · f8c9269f
      unknown authored
      
      tests/mysql_client_test.c:
        rc assignement added
      f8c9269f
    • unknown's avatar
      Merge trift2.:/MySQL/M50/push-5.0 · dab67085
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      dab67085
    • unknown's avatar
      Merge trift2.:/MySQL/M51/mysql-5.1 · 927063c7
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      
      sql/mysql_priv.h:
        Auto merged
      927063c7
    • unknown's avatar
      Merge trift2.:/MySQL/M50/mysql-5.0 · 4358b4b9
      unknown authored
      into  trift2.:/MySQL/M50/push-5.0
      
      4358b4b9
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 6a34c8fc
      unknown authored
      into  moonbone.local:/mnt/gentoo64/work/29850-bug-5.0-opt-mysql
      
      6a34c8fc
    • unknown's avatar
      Bug#29850: Wrong charset of GROUP_CONCAT result when the select employs · 134138bb
      unknown authored
      a temporary table.
      
      The result string of the Item_func_group_concat wasn't initialized in the 
      copying constructor of the Item_func_group_concat class. This led to a
      wrong charset of GROUP_CONCAT result when the select employs a temporary
      table.
      
      The copying constructor of the Item_func_group_concat class now correctly
      initializes the charset of the result string.
      
      
      mysql-test/t/func_gconcat.test:
        Added a test case for the bug#29850: Wrong charset of the GROUP_CONCAT result
        when the select employs a temporary table.
      mysql-test/r/func_gconcat.result:
        Added a test case for the bug#29850: Wrong charset of the GROUP_CONCAT result
        when the select employs a temporary table.
      sql/item_sum.cc:
        Bug#29850: Wrong charset of GROUP_CONCAT result when the select employs
        a temporary table.
        The copying constructor of the Item_func_group_concat class now correctly
        initializes the charset of the result string.
      134138bb
    • unknown's avatar
      After-merge fix for bug#14151. · 3fe13ea5
      unknown authored
      
      sql/sql_partition.cc:
        After-merge fix for bug#14151:
        This use of "md5.h" is new in 5.1 and must be changed to "my_md5.h" as well.
      3fe13ea5
    • unknown's avatar
      Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · f95d1f07
      unknown authored
      into  mysql.com:/home/hf/work/29687/my51-29687
      
      f95d1f07
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.1-opt · 3785950f
      unknown authored
      into  mysql.com:/home/hf/work/29687/my51-29687
      
      3785950f
    • unknown's avatar
      Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 8425b356
      unknown authored
      into  mysql.com:/home/hf/work/29687/my50-29687
      
      8425b356
    • unknown's avatar
      test case for memory leak added · 23666e3f
      unknown authored
      
      tests/mysql_client_test.c:
        test case added
      23666e3f
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0-opt · 8a63be0d
      unknown authored
      into  mysql.com:/home/hf/work/29687/my50-29687
      
      8a63be0d
    • unknown's avatar
      Merge mysql.com:/home/hf/work/29687/my50-29687 · 888b2e9d
      unknown authored
      into  mysql.com:/home/hf/work/29687/my51-29687
      
      
      libmysql/libmysql.c:
        Auto merged
      888b2e9d
    • unknown's avatar
      Merge bk-internal.mysql.com:/data0/bk/tsmith-tmp/mysql-5.0-maint · b7c5c9b8
      unknown authored
      into  bk-internal.mysql.com:/data0/bk/tsmith-tmp/mysql-5.1-maint
      
      
      sql/mysql_priv.h:
        Auto merged
      b7c5c9b8
    • unknown's avatar
      Merge bk-internal.mysql.com:/data0/bk/mysql-4.1-maint · db2ccdea
      unknown authored
      into  bk-internal.mysql.com:/data0/bk/tsmith-tmp/mysql-5.0-maint
      
      db2ccdea
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · 16d0f727
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      sql/sql_select.cc:
        Auto merged
      storage/myisam/ha_myisam.cc:
        Auto merged
      16d0f727
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.1 · fe29a12e
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      client/mysqldump.c:
        Auto merged
      include/my_base.h:
        Auto merged
      mysql-test/include/mix1.inc:
        Auto merged
      mysql-test/r/innodb_mysql.result:
        Auto merged
      mysql-test/t/disabled.def:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      storage/myisam/ha_myisam.cc:
        Auto merged
      fe29a12e
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0 · cec66c3d
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      
      sql/ha_myisam.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      cec66c3d
    • unknown's avatar
      Merge trift-lap.none:/MySQL/M50/bug14151-5.0 · 5b657b1a
      unknown authored
      into  trift-lap.none:/MySQL/M51/bug14151-5.1
      
      
      BitKeeper/deleted/.del-MySQL-Source.icc~edded3c3a5cf83b1:
        Auto merged
      BitKeeper/deleted/.del-mysqlmanager-pwgen.c~d8f5f91ec54432b9:
        Auto merged
      BitKeeper/deleted/.del-mysqlmanager.c~e97636d71145a0b:
        Auto merged
      include/Makefile.am:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      5b657b1a