| Server IP : 39.108.156.168 / Your IP : 216.73.216.104 Web Server : nginx/1.24.0 System : Linux e2.ksyuki.com 6.11.0-25-generic #25~24.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue Apr 15 17:20:50 UTC 2 x86_64 User : root ( 0) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/dstat/__pycache__/ |
Upload File : |
�
u�>] � �\ � e j d � xs dadadadadddd�a G d� de� Zy )
� DSTAT_MYSQL� ) )�Queries�qps)�
Com_selectzsel/s)�
Com_insertzins/s)�
Com_updatezupd/s)�
Com_deletezdel/s)� Connectionszcon/s)�Threads_connected�thcon)�Threads_running�thrun)� Slow_queries�slow) )�Innodb_rows_readzr#read)�Innodb_rows_insertedzr#ins)�Innodb_rows_updatedzr#upd)�Innodb_rows_deletedzr#del)�Innodb_data_reads�rdphy)� Innodb_buffer_pool_read_requests�rdlgc)�Innodb_data_writes�wrdat)�Innodb_log_writes�wrlog)�"innodb_buffer_pool_pages_dirty_pctz%dirty)� Innodb_buffer_pool_pages_total� Innodb_buffer_pool_pages_dirty� )r r r
c �" � e Zd ZdZd� Zd� Zd� Zy)� dstat_pluginzt
mysql5-innodb, mysql5-innodb-basic, mysql5-innodb-extra
display various metircs on MySQL5 and InnoDB.
c �< � d| _ d| _ d| _ d| _ y )NzMySQL5 InnoDB �d� i� )�name�type�width�scale)�selfs �'/usr/share/dstat/dstat_mysql5_innodb.py�__init__zdstat_plugin.__init__6 s � �$�� ��� ���
���
� c � � | j j d� dk\ r t }| xj dz
c_ n�| j j d� dk\ r t }| xj dz
c_ nc| j j d� dk\ r#t t z }| xj dz
c_ n"t t z }| xj dz
c_ t t
d� |� � | _ t t
d� |� � | _ d}d}|D ]* }t j |t j � s�(|} n |r) t |�d t ��� \ | _ | _ | _ y t% d � �# t" $ r t% d
� �w xY w)
N�basic� �extra�fullc � � | d S )Nr0 � ��es r+ �<lambda>z$dstat_plugin.check.<locals>.<lambda>J �
� �!�A�$� r- c � � | d S )Nr r4 r5 s r+ r7 z$dstat_plugin.check.<locals>.<lambda>K r8 r- )z/usr/bin/mysqlz/usr/local/bin/mysqlr z -n z"Cannot interface with MySQL binaryTzNeeds MySQL binary)�filename�find�
_basic_statusr& �
_extra_status�tuple�map�vars�nick�os�access�X_OK�dpopen�
mysql_options�stdin�stdout�stderr�IOError� Exception)r* �
target_status�mysql_candidate� mysql_cmd�mcs r+ �checkzdstat_plugin.check< sN � � �=�=� � �g� &�!� +� )�M� �I�I�� �I�
�]�]�
�
��
(�A�
-� )�M� �I�I�� �I�
�]�]�
�
��
'�1�
,� )�M� 9�M� �I�I�� �I� )�M� 9�M� �I�I�� �I��3�� �?�A�� ��3�� �?�A�� �D��� �!� �B��y�y��R�W�W�%� � �� �
�
F�7=�I�Wd�>e�7f�4��
�D�K��� ��,�-�-�� �
F� � D�E�E�
F�s �'E7 �7F c � � | j j d� t | j � D ]s }|dk( r nl|j � }|d | j
v r t
|d � | j |d < �J|d t v s�Vt
|d � | j |d < �u | j
D ]� }|t v r | j | | j |< �(|dk( r0| j d | j d z dz | j |< �]| j | | j | z
d z t z | j |< �� t t j k( r&| j j! | j � y y # t" $ rW}t j$ dkD rt' | j( �d
|��� | j
D ] }d | j |< � Y d }~y d }~wt* $ rW}t j$ dkD rt' d | j( |fz � | j
D ] }d | j |< � Y d }~y d }~ww xY w)
Nzshow global status;
r r0 r r r r �d g �?z: lost pipe to mysql, ���z
%s: exception)rG �write�readpiperH �splitr@ �float�set2�calculating_status�gauge�val�set1�elapsed�step�op�delay�updaterJ �debug�printr: rK )r* �line�s�kr6 r& s r+ �extractzdstat_plugin.extract\ s� � � 7� �J�J� � � 4� 5� ����-�
2���2�:���J�J�L���Q�4�4�9�9�$�&+�A�a�D�k�D�I�I�a��d�O��q�T� /�/�&+�A�a�D�k�D�I�I�a��d�O�
2� �Y�Y�
P����:�"&�)�)�A�,�D�H�H�Q�K��>�>�"&�)�)�,L�"M�PT�PY�PY�Zz�P{�"{� B� #B�D�H�H�Q�K�#'�9�9�Q�<�$�)�)�A�,�#>�#�"E��"O�D�H�H�Q�K�
P� �r�x�x� �� � � � ����+� �� � 7��x�x�!�|�U�4�=�=�RS�#T� U� � � � 6��B�4�8�8�D�>� 6��� 7��x�x�!�|�U�?�d�m�m�Q�5G�#G� H� � � � 6��B�4�8�8�D�>� 6�� 7�s- �BF �C=F � I�A
G"�" I�.A
I � IN)�__name__�
__module__� __qualname__�__doc__r, rP rg r4 r- r+ r" r" 0 s � ��
� .�@ 7r- r" N) rB �getenvrF r< r= rY rZ �dstatr" r4 r- r+ �<module>rn sP �� � � �-�(�.�B�
�
�
� �
� � � )*�()�()� �� I7�5� I7r-