Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: sql_profile.h

This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA */

#ifndef _SQL_PROFILE_H
#define _SQL_PROFILE_H

class Item;
struct TABLE_LIST;
class THD;
class ST_FIELD_INFO;
typedef struct st_schema_table ST_SCHEMA_TABLE;

namespace Show {
extern ST_FIELD_INFO query_profile_statistics_info[];
} // namespace Show

int fill_query_profile_statistics_info(THD *thd, TABLE_LIST *tables, Item *cond);
int make_profile_table_for_show(THD *thd, ST_SCHEMA_TABLE *schema_table);

#define PROFILE_NONE         (uint)0
#define PROFILE_CPU          (uint)(1<<0)
#define PROFILE_MEMORY       (uint)(1<<1)
#define PROFILE_BLOCK_IO     (uint)(1<<2)
#define PROFILE_CONTEXT      (uint)(1<<3)
#define PROFILE_PAGE_FAULTS  (uint)(1<<4)
#define PROFILE_IPC          (uint)(1<<5)
#define PROFILE_SWAPS        (uint)(1<<6)
#define PROFILE_SOURCE       (uint)(1<<16)
#define PROFILE_ALL          (uint)(~0)

#if defined(ENABLED_PROFILING)
#include "sql_priv.h"
#include "unireg.h"

#ifdef _WIN32
#include <psapi.h>
#endif

#ifdef HAVE_SYS_RESOURCE_H
#include <sys/resource.h>
#endif

extern PSI_memory_key key_memory_queue_item;

class PROF_MEASUREMENT;
class QUERY_PROFILE;
class PROFILING;

/**
  Implements a persistent FIFO using server List method names.  Not
  thread-safe.  Intended to be used on thread-local data only.  
*/
template <class T> class Queue
{
private:

struct queue_item
  {
    T *payload;
    struct queue_item *next, *previous;
  };

struct queue_item *first, *last;

public:
  Queue()
  {
    elements= 0;
    first= last= NULL;
  }

void empty()
  {
    struct queue_item *i, *after_i;
    for (i= first; i != NULL; i= after_i)
    {
      after_i= i->next;
      my_free(i);
    }
    elements= 0;
  }

ulong elements;                       /* The count of items in the Queue */

void push_back(T *payload)
  {
    struct queue_item *new_item;

new_item= (struct queue_item *) my_malloc(key_memory_queue_item,
                                              sizeof(struct queue_item), MYF(0));
    if (!new_item)
      return;

new_item->payload= payload;

if (first == NULL)
      first= new_item;
    if (last != NULL)
    {
      DBUG_ASSERT(last->next == NULL);
      last->next= new_item;
    }
    new_item->previous= last;
    new_item->next= NULL;
    last= new_item;

elements++;
  }

T *pop()
  {
    struct queue_item *old_item= first;
    T *ret= NULL;

if (first == NULL)
    {
      DBUG_PRINT("warning", ("tried to pop nonexistent item from Queue"));
      return NULL;
    }

ret= old_item->payload;
    if (first->next != NULL)
      first->next->previous= NULL;
    else
      last= NULL;
    first= first->next;

my_free(old_item);
    elements--;

return ret;
  }

bool is_empty()
  {
    DBUG_ASSERT(((elements > 0) && (first != NULL)) || ((elements == 0) || (first == NULL)));
    return (elements == 0);
  }

void *new_iterator()
  {
    return first;
  }

void *iterator_next(void *current)
  {
    return ((struct queue_item *) current)->next;
  }

T *iterator_value(void *current)
  {
    return ((struct queue_item *) current)->payload;
  }

};

/**
  A single entry in a single profile.
*/
class PROF_MEASUREMENT
{
private:
  friend class QUERY_PROFILE;
  friend class PROFILING;

QUERY_PROFILE *profile;
  char *status;
#ifdef HAVE_GETRUSAGE
  struct rusage rusage;
#elif defined(_WIN32)
  FILETIME ftKernel, ftUser;
  IO_COUNTERS io_count;
  PROCESS_MEMORY_COUNTERS mem_count;
#endif

char *function;
  char *file;
  unsigned int line;

ulong m_seq;
  double time_usecs;
  char *allocated_status_memory;

void set_label(const char *status_arg, const char *function_arg, 
                  const char *file_arg, unsigned int line_arg);
  void clean_up();
  
  PROF_MEASUREMENT();
  PROF_MEASUREMENT(QUERY_PROFILE *profile_arg, const char *status_arg);
  PROF_MEASUREMENT(QUERY_PROFILE *profile_arg, const char *status_arg,
                const char *function_arg,
                const char *file_arg, unsigned int line_arg);
  ~PROF_MEASUREMENT();
  void collect();
};

/**
  The full profile for a single query, and includes multiple PROF_MEASUREMENT
  objects.
*/
class QUERY_PROFILE
{
private:
  friend class PROFILING;

PROFILING *profiling;

query_id_t profiling_query_id;        /* Session-specific id. */
  char *query_source;

double m_start_time_usecs;
  double m_end_time_usecs;
  ulong m_seq_counter;
  Queue<PROF_MEASUREMENT> entries;

QUERY_PROFILE(PROFILING *profiling_arg, const char *status_arg);
  ~QUERY_PROFILE();

void set_query_source(char *query_source_arg, size_t query_length_arg);

/* Add a profile status change to the current profile. */
  void new_status(const char *status_arg,
              const char *function_arg,
              const char *file_arg, unsigned int line_arg);

/* Reset the contents of this profile entry. */
  void reset();

/* Show this profile.  This is called by PROFILING. */
  bool show(uint options);
};

/**
  Profiling state for a single THD; contains multiple QUERY_PROFILE objects.
*/
class PROFILING
{
private:
  friend class PROF_MEASUREMENT;
  friend class QUERY_PROFILE;

/* 
    Not the system query_id, but a counter unique to profiling. 
  */
  query_id_t profile_id_counter;     
  THD *thd;
  bool keeping;
  bool enabled;

QUERY_PROFILE *current;
  QUERY_PROFILE *last;
  Queue<QUERY_PROFILE> history;
 
  query_id_t next_profile_id() { return(profile_id_counter++); }

public:
  PROFILING();
  ~PROFILING();

/**
    At a point in execution where we know the query source, save the text
    of it in the query profile.

This must be called exactly once per descrete statement.
  */
  void set_query_source(char *query_source_arg, size_t query_length_arg)
  {
    if (unlikely(current))
      current->set_query_source(query_source_arg, query_length_arg);
  }

/**
    Prepare to start processing a new query.  It is an error to do this
    if there's a query already in process; nesting is not supported.

@param  initial_state  (optional) name of period before first state change
  */
  void start_new_query(const char *initial_state= "Starting")
  {
    DBUG_ASSERT(!current);
    if (unlikely(enabled))
    {
      QUERY_PROFILE *new_profile= new QUERY_PROFILE(this, initial_state);
      if (new_profile)
        current= new_profile;
    }
  }

void discard_current_query();

void finish_current_query()
  {
    if (unlikely(current))
      finish_current_query_impl();
  }

void finish_current_query_impl();

void status_change(const char *status_arg,
                     const char *function_arg,
                     const char *file_arg, unsigned int line_arg)
  {
    if (unlikely(current))
      current->new_status(status_arg, function_arg, file_arg, line_arg);
  }

inline void set_thd(THD *thd_arg)
  {
    thd= thd_arg;
    reset();
  }

/* SHOW PROFILES */
  bool show_profiles();

/* ... from INFORMATION_SCHEMA.PROFILING ... */
  int fill_statistics_info(THD *thd, TABLE_LIST *tables, Item *cond);
  void reset();
  void restart();
};

#  endif /* ENABLED_PROFILING */
#endif /* _SQL_PROFILE_H */

Name	Type	Actions
atomic	Directory
aligned.h	File
aria_backup.h	File
assume_aligned.h	File
authors.h	File
backup.h	File
bounded_queue.h	File
client_settings.h	File
compat56.h	File
config.h	File
contributors.h	File
create_options.h	File
create_tmp_table.h	File
cset_narrowing.h	File
custom_conf.h	File
datadict.h	File
ddl_log.h	File
debug.h	File
debug_sync.h	File
derived_handler.h	File
derror.h	File
des_key_file.h	File
discover.h	File
dur_prop.h	File
embedded_priv.h	File
event_data_objects.h	File
event_db_repository.h	File
event_parse_data.h	File
event_queue.h	File
event_scheduler.h	File
events.h	File
field.h	File
field_comp.h	File
filesort.h	File
filesort_utils.h	File
ft_global.h	File
gcalc_slicescan.h	File
gcalc_tools.h	File
grant.h	File
group_by_handler.h	File
gstream.h	File
ha_handler_stats.h	File
ha_partition.h	File
ha_sequence.h	File
handle_connections_win.h	File
handler.h	File
hash.h	File
hash_filo.h	File
heap.h	File
hostname.h	File
ilist.h	File
init.h	File
innodb_priv.h	File
item.h	File
item_cmpfunc.h	File
item_create.h	File
item_func.h	File
item_geofunc.h	File
item_jsonfunc.h	File
item_row.h	File
item_strfunc.h	File
item_subselect.h	File
item_sum.h	File
item_timefunc.h	File
item_vers.h	File
item_windowfunc.h	File
item_xmlfunc.h	File
json_table.h	File
key.h	File
keycaches.h	File
lex.h	File
lex_string.h	File
lex_symbol.h	File
lf.h	File
lock.h	File
log.h	File
log_event.h	File
log_event_data_type.h	File
log_event_old.h	File
log_slow.h	File
maria.h	File
mariadb.h	File
mdl.h	File
mem_root_array.h	File
message.h	File
multi_range_read.h	File
my_alarm.h	File
my_apc.h	File
my_atomic.h	File
my_atomic_wrapper.h	File
my_base.h	File
my_bit.h	File
my_bitmap.h	File
my_check_opt.h	File
my_compare.h	File
my_counter.h	File
my_cpu.h	File
my_crypt.h	File
my_decimal.h	File
my_default.h	File
my_handler_errors.h	File
my_json_writer.h	File
my_libwrap.h	File
my_md5.h	File
my_minidump.h	File
my_nosys.h	File
my_rdtsc.h	File
my_rnd.h	File
my_service_manager.h	File
my_stack_alloc.h	File
my_stacktrace.h	File
my_time.h	File
my_tree.h	File
my_uctype.h	File
my_user.h	File
myisam.h	File
myisamchk.h	File
myisammrg.h	File
myisampack.h	File
mysqld.h	File
mysqld_default_groups.h	File
mysqld_suffix.h	File
mysys_err.h	File
opt_range.h	File
opt_subselect.h	File
opt_trace.h	File
opt_trace_context.h	File
parse_file.h	File
partition_element.h	File
partition_info.h	File
password.h	File
pfs_file_provider.h	File
pfs_idle_provider.h	File
pfs_memory_provider.h	File
pfs_metadata_provider.h	File
pfs_socket_provider.h	File
pfs_stage_provider.h	File
pfs_statement_provider.h	File
pfs_table_provider.h	File
pfs_thread_provider.h	File
pfs_transaction_provider.h	File
privilege.h	File
probes_mysql.h	File
probes_mysql_dtrace.h	File
probes_mysql_nodtrace.h	File
procedure.h	File
protocol.h	File
proxy_protocol.h	File
queues.h	File
records.h	File
repl_failsafe.h	File
replication.h	File
rijndael.h	File
rowid_filter.h	File
rpl_constants.h	File
rpl_filter.h	File
rpl_gtid.h	File
rpl_injector.h	File
rpl_mi.h	File
rpl_parallel.h	File
rpl_record.h	File
rpl_record_old.h	File
rpl_reporting.h	File
rpl_rli.h	File
rpl_tblmap.h	File
rpl_utility.h	File
scheduler.h	File
scope.h	File
select_handler.h	File
semisync.h	File
semisync_master.h	File
semisync_master_ack_receiver.h	File
semisync_slave.h	File
service_versions.h	File
session_tracker.h	File
set_var.h	File
slave.h	File
socketpair.h	File
source_revision.h	File
sp.h	File
sp_cache.h	File
sp_head.h	File
sp_pcontext.h	File
sp_rcontext.h	File
span.h	File
spatial.h	File
sql_acl.h	File
sql_admin.h	File
sql_alloc.h	File
sql_alter.h	File
sql_analyse.h	File
sql_analyze_stmt.h	File
sql_array.h	File
sql_audit.h	File
sql_base.h	File
sql_basic_types.h	File
sql_binlog.h	File
sql_bitmap.h	File
sql_bootstrap.h	File
sql_cache.h	File
sql_callback.h	File
sql_class.h	File
sql_cmd.h	File
sql_connect.h	File
sql_const.h	File
sql_crypt.h	File
sql_cte.h	File
sql_cursor.h	File
sql_db.h	File
sql_debug.h	File
sql_delete.h	File
sql_derived.h	File
sql_digest.h	File
sql_digest_stream.h	File
sql_do.h	File
sql_error.h	File
sql_explain.h	File
sql_expression_cache.h	File
sql_get_diagnostics.h	File
sql_handler.h	File
sql_help.h	File
sql_hset.h	File
sql_i_s.h	File
sql_insert.h	File
sql_join_cache.h	File
sql_lex.h	File
sql_lifo_buffer.h	File
sql_limit.h	File
sql_list.h	File
sql_load.h	File
sql_locale.h	File
sql_manager.h	File
sql_mode.h	File
sql_parse.h	File
sql_partition.h	File
sql_partition_admin.h	File
sql_plist.h	File
sql_plugin.h	File
sql_plugin_compat.h	File
sql_prepare.h	File
sql_priv.h	File
sql_profile.h	File
sql_reload.h	File
sql_rename.h	File
sql_repl.h	File
sql_schema.h	File
sql_select.h	File
sql_sequence.h	File
sql_servers.h	File
sql_show.h	File
sql_signal.h	File
sql_sort.h	File
sql_statistics.h	File
sql_string.h	File
sql_table.h	File
sql_tablespace.h	File
sql_test.h	File
sql_time.h	File
sql_trigger.h	File
sql_truncate.h	File
sql_tvc.h	File
sql_type.h	File
sql_type_fixedbin.h	File
sql_type_fixedbin_storage.h	File
sql_type_geom.h	File
sql_type_int.h	File
sql_type_json.h	File
sql_type_real.h	File
sql_type_string.h	File
sql_udf.h	File
sql_union.h	File
sql_update.h	File
sql_view.h	File
sql_window.h	File
ssl_compat.h	File
strfunc.h	File
structs.h	File
sys_vars_shared.h	File
t_ctype.h	File
table.h	File
table_cache.h	File
thr_alarm.h	File
thr_lock.h	File
thr_malloc.h	File
thr_timer.h	File
thread_cache.h	File
threadpool.h	File
threadpool_generic.h	File
threadpool_winsockets.h	File
transaction.h	File
tzfile.h	File
tztime.h	File
uniques.h	File
unireg.h	File
vers_string.h	File
violite.h	File
waiting_threads.h	File
welcome_copyright_notice.h	File
win_tzname_data.h	File
winservice.h	File
wqueue.h	File
wsrep.h	File
wsrep_applier.h	File
wsrep_binlog.h	File
wsrep_client_service.h	File
wsrep_client_state.h	File
wsrep_condition_variable.h	File
wsrep_high_priority_service.h	File
wsrep_mutex.h	File
wsrep_mysqld.h	File
wsrep_mysqld_c.h	File
wsrep_on.h	File
wsrep_priv.h	File
wsrep_schema.h	File
wsrep_server_service.h	File
wsrep_server_state.h	File
wsrep_sst.h	File
wsrep_storage_service.h	File
wsrep_thd.h	File
wsrep_trans_observer.h	File
wsrep_types.h	File
wsrep_utils.h	File
wsrep_var.h	File
wsrep_xid.h	File
xa.h	File