Yes, 150 means we added some 30 performance statistics to the MySQL native driver for PHP (mysqlnd) since monday. The new statistics are explained in three words: counting
COM_* commands refers to the command packets of the MySQL client server protocol. For example,
COM_QUERY is used to execute nonprepared SQL statements.
Please check the earlier blog postings on how to use and access the statistics: PHP: 59 tuning screws for mysqlnd, PHP: 120 tuning screws for mysqlnd. The information given in those articles will find its way into the PHP and MySQL manual. The MySQL documentation team is working on an update. But for now, an hour after the latest commit, you are requested to check the blog postings.
|Class: COM_* commands|
Total number of command packets of the MySQL client server protocol sent from PHP to MySQL.
The MySQL client server protocol describes some 28 commands which a client can send to MySQL. The commands serve different purposes from closing a connection to executing SQL statements.
|com_quit, com_init_db, com_query, com_field_list, com_create_db, com_drop_db, com_refresh, com_shutdown, com_statistics, com_process_info, com_connect, com_process_kill, com_debug, com_ping, com_time, com_delayed_insert, com_change_user, com_binlog_dump, com_table_dump, com_connect_out, com_register_slave, com_stmt_prepare, com_stmt_execute, com_stmt_send_long_data, com_stmt_close, com_stmt_reset, com_stmt_set_option, com_stmt_fetch, com_deamon|
Scope: connection. Outgoing traffic: from PHP to MySQL.
Total number of attempts to send a certain