.. _slb_mysql_stats:

slb mysql stats
===============

Statistics for the object mysql


mysql Specification
-------------------

	===================================== ========================================================
	===================================== ========================================================
	 **Type**                              *Configuration Resource*

	 **Element Name**                      mysql

	 **Element URI**                       /axapi/v3/slb/mysql/stats

	 **Element Attributes**                mysql_attributes

	 **Schema**                             :download:`mysql schema <slb-mysql-stats/slb-mysql-stats.txt>`
	===================================== ========================================================





	**Operations Allowed:**




.. raw:: html

   <script type="text/javascript">
 function showExample(a,b) { document.getElementById(a+'_div').style.display = 'block'; document.getElementById(a+'_cl').style.display = 'block'; document.getElementById(a+'_eg').style.display = 'none';}
   function closeExample(a,b) { document.getElementById(a+'_div').style.display = 'none'; document.getElementById(a+'_cl').style.display = 'none'; document.getElementById(a+'_eg').style.display = 'block';}
 </script>
   <table width='90%' style='margin-left:5%'>



.. raw:: html

   <tr style='border-bottom: thin solid; border-top: thin solid'><th width=15%>Operation</th><th width=10%>Method</th><th>URI</th><th width=15%>Payload</th><th width=10%></th></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Create Object



.. raw:: html

   </td><td valign = 'top'>


POST



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql/stats



.. raw:: html

   </td><td valign = 'top'>


:ref:`1696_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Get Object



.. raw:: html

   </td><td valign = 'top'>


GET



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql/stats



.. raw:: html

   </td><td valign = 'top'>


:ref:`1696_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Modify Object



.. raw:: html

   </td><td valign = 'top'>


POST



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql/stats



.. raw:: html

   </td><td valign = 'top'>


:ref:`1696_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Replace Object



.. raw:: html

   </td><td valign = 'top'>


PUT



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql/stats



.. raw:: html

   </td><td valign = 'top'>


:ref:`1696_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Delete Object



.. raw:: html

   </td><td valign = 'top'>


DELETE



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql/stats



.. raw:: html

   </td><td valign = 'top'>


:ref:`1696_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   </table>

.. _1696_mysql_attributes:

mysql attributes
----------------

    **stats**

        **Description:** stats is a **JSON Block**.  Please see below for :ref:`1696_stats` 

        **Type:** Object

.. _1696_stats:

stats
^^^^^
	=============================== ===================================================
	**Specification**
	=============================== ===================================================
	 **Type**                        *object*

	=============================== ===================================================

    **client_fin**

        **Description** Client FIN

        **Type:** number

        **Format:** counter

    **commands**

        **Description** DB commands reply

        **Type:** number

        **Format:** counter

    **curr_be_enc**

        **Description** Curr BE Encryption Conns

        **Type:** number

        **Format:** counter

    **curr_fe_enc**

        **Description** Curr FE Encryption Conns

        **Type:** number

        **Format:** counter

    **curr_proxy**

        **Description** Curr Proxy Conns

        **Type:** number

        **Format:** counter

    **queries**

        **Description** DB Queries

        **Type:** number

        **Format:** counter

    **server_fin**

        **Description** Server FIN

        **Type:** number

        **Format:** counter

    **session_err**

        **Description** Session err

        **Type:** number

        **Format:** counter

    **total_be_enc**

        **Description** Total BE Encryption Conns

        **Type:** number

        **Format:** counter

    **total_fe_enc**

        **Description** Total FE Encryption Conns

        **Type:** number

        **Format:** counter

    **total_proxy**

        **Description** Total Proxy Conns

        **Type:** number

        **Format:** counter