• Michael Widenius's avatar
    Speed up connection time: · d8986fd6
    Michael Widenius authored
    -Change my_rnd() slightly to make it safer if two threads use it at the same time.
    -Avoid some sprintf and strmov in vio.
    -Changed thread_count to be automaticly incremented (instead of under LOCK_thread_count).
    -Thread cache now uses LOCK_thread_cache instead of LOCK_thread_count.
    -Moved delete thd out from LOCK_thread_count.
    -Save some mysql_cond_broadcast(&COND_thread_count) calls.
    -Removed call to getsockname() during connect.
    -Initialize random generator without locks.
    
    Other things:
    -Fixed test cases that depends on changes for LOCK_grant
    -Added thread_safe_decrement32() and thread_safe_increment32()
    -Removed sql_rnd_with_mutex() and get_thread_running()
    -In check_table_access() don't lock LOCK_grant if we can resolve the grant with user or db level grants (the normal case).
    -Don't use a lock for setting THD->query_id.
    -Fixed bug where thd->set_query_id() could be set to same value by multiple threads.
    
    Thanks to Yoshinori Matsunobu for the benchmark of connection speed and to
    Domas Mituzas for the inspiration for many of the fixes.
    
    
    include/violite.h:
      Change desc to a string pointer
    mysql-test/suite/perfschema/r/all_instances.result:
      Added new mutex
    mysql-test/suite/perfschema/t/func_mutex.test:
      Test for LOCK_system_variables_hash instead of LOCK_grant, as LOCK_grant is not anymore always taken for SELECT's.
    mysys/my_gethwaddr.c:
      More DBUG
    mysys/my_rnd.c:
      Change my_rnd() slightly to make it safer if two threads use it at the same time.
    sql/event_scheduler.cc:
      Changed thread_count to be automically incremented
      Moved some safe things out from LOCK_thread_count.
      Simplify deleting of THD for running thread.
    sql/mysqld.cc:
      Changed thread_count to be automically incremented
      Thread cache now uses LOCK_thread_cache instead of LOCK_thread_count
      Added delete_running_thd()
      Moved delete thd out from LOCK_thread_count
      More DBUG
      Only call  mysql_cond_broadcast(&COND_thread_count) if thread_count is 0
      Removed call to getsockname() (old not anymore needed check)
    sql/mysqld.h:
      Removed sql_rnd_with_mutex() (not needed anymore)
      Removed not used function get_thread_running()
      Added thread_safe_decrement32() and thread_safe_increment32()
      Simplified dec_thread_running() and inc_thread_running()
      next_query_id() should return the original value for global_query_id, not the next one.
      (Bug introduced with MySQL 5.5 merge).
    sql/sql_acl.cc:
      In check_table_access() don't lock LOCK_grant if we can resolve the grant with user or db level grants (the normal case).
    sql/sql_class.cc:
      Removed thd_lock_thread_count() and thd_unlock_thread_count()
      Initialize random generator without locks
      Don't use a lock for setting THD->query_id.
      (This is only accessed by thread owning the THD)
    sql/sql_class.h:
      Don't use a lock for setting THD->query_id.
    sql/sql_insert.cc:
      Changed thread_count to be automically incremented
    sql/sql_parse.cc:
      Changed thread_count to be automically incremented
      Fixed bug where thd->set_query_id() could be set to same value by multiple threads.
    vio/vio.c:
      Don't generate 'desc' with sprintf/strmov. Assign a pointer instead.
      (Good enough as this is just for debugging)
    d8986fd6
sql_insert.cc 140 KB