来自于源码Sql_parse.cc源程序中的dispatch_command函数:

(sql/)

case COM_STATISTICS:

  {

    STATUS_VAR current_global_status_var;

    ulong uptime;

    uint length;

    ulonglong queries_per_second1000;

    char buff[250];

    uint buff_len= sizeof(buff);


    general_log_print(thd, command, NullS);

    status_var_increment(thd->status_var.com_stat[SQLCOM_SHOW_STATUS]);

    calc_sum_of_all_status(&current_global_status_var);

    if (!(uptime= (ulong) (thd->start_time - server_start_time)))

      queries_per_second1000= 0;

    else

      queries_per_second1000= thd->query_id * LL(1000) / uptime;


    length= my_snprintf((char*) buff, buff_len - 1,

                        "Uptime: %lu  Threads: %d  Questions: %lu  "

                        "Slow queries: %lu  Opens: %lu  Flush tables: %lu  "

                        "Open tables: %u  Queries per second avg: %u.%u",

                        uptime,

                        (int) thread_count, (ulong) thd->query_id,

                        current_global_status_var.long_query_count,

                        current_global_status_var.opened_tables,

                        refresh_version,

                        cached_open_tables(),

                        (uint) (queries_per_second1000 / 1000),

                        (uint) (queries_per_second1000 % 1000));