Dashboard
PHP:
8.3.33
OS:
Linux
User:
letter7
/
/
usr
/
lib
/
mysqlsh
/
plugins
/
debug
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: sql_collector.cpython-38.pyc
U �C�e�� � @ s� d dl mZ d dlmZ d dlmZmZ d dlmZm Z m Z m Z d dl Z d dl Z d dlZd dlZddlmZmZ eejd�d d �Zd d � Zd d� Zdd� ZG dd� d�Zd�ejeeed�dd�Z g fdddg ddd�ejeeee e e e e e e e e e ed� dd �Z dddd �ejeed �d d �Z ddd!�ejeee e e e e d"�d#d$�Z!dddd%�ejeeee e d&�d'd(�Z"ejeeed)�d*d+�Z#d,d-d.d/� d0d/� dd1fd2d3d4d5d/� dd1fd6d7d8d9d/� dd:fd;d7d8d<d/� dd:fd=d>d?d@d/� dd1fdAd7d8dBd/� ddCfdDd>d?dEd/� ddFfdGdHdIdJd/� dKdLfdMd>d?dNd/� dKdLfdOdPdQdRd/� ddSfdTd>d?dUd/� ddSfdVdWdXdYd/� dKdZfd[d>d?d\d/� dKd]fd^d_d`dad/� dKdbfdcd-ddded/� ddffdgd3d4dhd/� ddffdidjdkdld/� ddmfdndodpdqd/� ddmfdrd>d?dsd/� ddffdtdodpdud/� ddvfdwdxdydzd/� dd{fd|d>d?d}d/� dd{fd~d7d8dd/� dd�fd�dodpd�d/� dd�fd�d>d?d�d/� dd�fgZ$G d�d�� d��Z%G d�d�� d��Z&dg g fejeee'e(ee e e e e d�� d�d��Z)dg fejeee e e d��d�d��Z*ejeee e d��d�d��Z+ed��d�d��Z,ejeee e d��d�d��Z-dd��ejeee d��d�d��Z.d�ejeed��d�d��Z/d�ejeed��d�d��Z0ejeeeed��d�d��Z1ejeeee d��d�d��Z2ejeeed��d�d��Z3dS )�� )� Condition)�Thread)�mysql�Error)�Callable�List�Optional�TupleN� )� ShellExecutor� split_phases)�path�returnc C s t j| ttj�� �� �d�S )N)� date_time)�zipfile�ZipInfo�tuple�datetime�now� timetuple)r � r �//usr/lib/mysqlsh/plugins/debug/sql_collector.py� make_zipinfo" s ��r c C s$ | � dd�� dd�� dd�� dd�S )N� �_�:�\�/)�replace��sr r r �sanitize( s �� �r! c C s~ | d kr d S | dk r"t | �� d�S | dk r:| d d�d�S | dk rR| d d�d�S | dk rj| d d�d �S | d d�d �S d S ) Ni z bytesi �0.2fz KiBi @z MiBl z GiBz TiB)�int)�nr r r � format_bytes. s r% c C s� | d kr d S | dkr$| d d�d�S | dkr<| d d�d�S | dkrT| d d�d�S | dkrl| d d�d �S | d kr�| d d�d �S | d kr�| d d�d �S | dkr�| d d�d�S | dkr�| d d�d�S | � d�S d S )Nl P�9%Cr" z wl 09^Q� z dl b"�(f z hl @_-GZ z ml J)�z si ʚ;z msi@B z usi� z nsz psr )Z picosecondsr r r �format_pico_time= s& r& c @ sB e Zd Zdd� Zdd� Zeed�dd��Zg feed�d d �Z d S ) �InstanceSessionc C s` || _ | �d��� \| _}d|kr0|�d�d }|�d�\}}}t|�d t|�d t|� | _dd� | �d ��� D �| _d d� | �d ��� D �| _ d d� | �d ��� D �| _ dd� | �d��� D �| _ dd� | �d��� D �}d|k| _ d| jk| _ | j �d��� �rPd| _z| j �d��� d | _W n" | j �d��� d | _Y nX n d| _d| _d S )Nz/select @@performance_schema <> 'OFF', @@version�-r �.i' �d c S s g | ] }|d �qS �r r ��.0�tr r r � <listcomp>` s z,InstanceSession.__init__.<locals>.<listcomp>z!show tables in performance_schemac S s g | ] }|d �qS r+ r r, r r r r/ d s z!show tables in information_schemac S s g | ] }|d �qS r+ r �r- �rr r r r/ h s zshow tables in sysc S s g | ] }|d �qS r+ r r0 r r r r/ k s zshow tables in mysqlc S s g | ] }|d �qS r+ r r0 r r r r/ o s zAselect engine from information_schema.engines where support<>'NO'Z NDBCluster� rpd_nodesz1show schemas like 'mysql_innodb_cluster_metadata'TzFselect instance_id from mysql_innodb_cluster_metadata.v2_this_instancez�select instance_id from mysql_innodb_cluster_metadata.instances where cast(mysql_server_uuid as binary)=cast(@@server_uuid as binary)F)�session�run_sql� fetch_one�has_pfs�splitr# �version� fetch_all� pfs_tables� is_tablesZ sys_tables� mysql_tables�has_ndb� has_rapid�has_innodbcluster� instance_id)�selfr3 r8 �a�b�cZsupported_enginesr r r �__init__V sb �"���� � ��� � �� ��zInstanceSession.__init__c C s | j jS �N�r3 �uri�rA r r r �__str__� s zInstanceSession.__str__)r c C s | j jS rF rG rI r r r rH � s zInstanceSession.uri)�sql�argsc C sJ z| j �||�W S tk rD } ztd|t|�� � W 5 d }~X Y nX d S )NzERROR running query: )r3 r4 � Exception�print�str)rA rK rL �er r r r4 � s zInstanceSession.run_sqlN) �__name__� __module__� __qualname__rE rJ �propertyrO rH �listr4 r r r r r' T s 1r' � )�zf�fn�tsv_out�headerc s: � �fdd�}| � t|d �d��}||� W 5 Q R X d S )Nc s< � r| � � �d�� �D ] }| � |�d�� | � d� qd S )N�utf-8� )�write�encode)�f�line�rZ rY r r r] � s zwrite_tsv.<locals>.writez.tsv�w)�openr )rW rX rY rZ r] r_ r ra r � write_tsv� s rd TF)�as_yaml�as_tsv�filter� formatters� ignore_errors�include_warnings) rW rX r3 �queryrL re rf rg rh ri rj r c s2 � ����fdd�} dd� dd� ��d�D �� d ��d7 ��dtj�� �� � d�7 �z|��|�} | �� } W n. tk r� } z| |� W Y �S d }~X Y nX g }g }g }|r�g }| jD ]}|� |j � q�|� d d � |� � �zJt | j d �D �]6}g }|�r||�}|�sq�i }i }t t|��D ]�}|| }||| j| j < | j| j |k�r^|| |�}|� |d k �rtt|�nd � t|�tk�r�d |k�r�d |�d d � d }||| j| j < nBt|�ttttd �tfk�r�||| j| j < nt|�|| j| j < �q$|�r|� d � |�� |� |� |� |� q�W n0 tk �r\ } z| |� W Y �S d }~X Y nX | �r�|�d��� }|�r�|� d|i� |�r�|� d� |D ] }|� d � dd� |D ��� �q��d| � d�7 �|�r�t�� |�d� |�r.��t� d �d��,}|���d�� |�t� |��d�� W 5 Q R X |S )Nc s^ �rD�� t� d �d��"}|��� d| � d��d�� W 5 Q R X g S td�� d| � �� � d S )Nz.errorrb z # � r[ zERROR: While executing "z": )rc r r] r^ rN )rP r_ �rX rZ ri rk rW r r � handle_error� s &z dump_query.<locals>.handle_error� # Query: rl c S s g | ]}d |� ��qS �z# r �r- �lr r r r/ � s z dump_query.<locals>.<listcomp>z# z # Started: �# � �NULL�"z\"z SHOW WARNINGS�Warningsz # Warningsc S s g | ] }t |��qS r )rO )r- r_ r r r r/ � s �# Execution Time: z # )rZ �.yamlrb r[ ) �joinr7 r r � isoformatr4 �get_execution_timerM �columns�append� column_label�iterr5 �range�lenrO �typer r# �bool�floatr9 rd rc r r] r^ �yaml�dump_all) rW rX r3 rk rL re rf rg rh ri rj rn r1 Zexecution_timerP Zraw_outZyaml_outrY r` rD �row�entryZ raw_entry�i�field�warningsrb r_ r rm r � dump_query� s� �� r� )re rg ri )rW rX r3 c C s t | ||d|� �|||d�S )Nzselect * from �rg re ri )r� )rW rX r3 �tablere rg ri r r r � dump_table s �r� �re ri )rW �prefixr3 �tablesre ri r c C sF i }|D ]8}t d|� d�� t| |� t|�� �||||d�||< q|S )N� - Gathering �...r� )rN r� r! )rW r� r3 r� re ri �infor� r r r �collect_tables s � r� )re ri rj )rW r� r3 �queriesri rj c C s� i }|D ]�}t |�tkr>t|�dkr2|\} } d } qN|\} } } n||d } } } td| � d�� z4t| |� t| �� �|| |||| d�|| �dd�< W q tk r� } z| jt j j fkr�� W 5 d } ~ X Y qX q|S )N� r� r� )re ri rj rg r r ) r� r r� rN r� r! r r �coder � ErrorCodeZER_NO_BINARY_LOGGING) rW r� r3 r� re ri rj r� �q�labelrk rg rP r r r �collect_queries% s0 � r� )rW rX r3 r� c C s� | � t|�d���h}|D �]Z}td|� d�� dd�dd� |�d�D �� d }|�|�d�� z�|�|�}|�d |�� � d ��d�� |�d � |�d d �dd� |j D �� d �d�� g }t |j d �D ]8} t t | ��D ]&} | | } |�| d k r�t| �nd� q�q�d �|�}|�|� d��d�� W q tk �rr } z*|�d| � d��d�� td| � �� W 5 d } ~ X Y qX qW 5 Q R X d S )Nrb z - Executing r� ro rl c S s g | ]}d |� ��qS rp r rq r r r r/ O s z/collect_queries_single_file.<locals>.<listcomp>r[ rx z r\ rs rt c S s g | ] }|j �qS r )r )r- rD r r r r/ X s ru z # Error: zERROR: )rc r rN rz r7 r] r^ r4 r| r} r� r5 r� r� r~ rO r ) rW rX r3 r� r_ rk rZ �resr` r� r� r� rP r r r �collect_queries_single_fileH sH �� �� ���� r� Z host_summaryz %{TABLE}.statement_latency DESCc C s |d | d pd S )NZstatement_latencyr r �r rP r r r �<lambda>k � r� c C s |d | d pd dkS �NZ statementsr r r� r r r r� l r� �hostZhost_summary_by_file_ioz%{TABLE}.io_latency DESCz+(e.io_latency-IFNULL(s.io_latency, 0)) DESCc C s |d | d pd dkS �NZiosr r r� r r r r� o r� Z host_summary_by_file_io_typez*%{TABLE}.host, %{TABLE}.total_latency DESCz9e.host, (e.total_latency-IFNULL(s.total_latency, 0)) DESCc C s |d | d pd dkS �N�totalr r r� r r r r� r r� zhost,event_nameZhost_summary_by_stagesc C s |d | d pd dkS r� r r� r r r r� u r� Z!host_summary_by_statement_latencyz%{TABLE}.total_latency DESCz1(e.total_latency-IFNULL(s.total_latency, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� x r� Z host_summary_by_statement_typec C s |d | d pd dkS r� r r� r r r r� { r� zhost,statementZio_by_thread_by_latencyc C s |d | d pd dkS r� r r� r r r r� ~ r� z user,thread_id,processlist_id�io_global_by_file_by_bytesz%{TABLE}.total DESCz!(e.total-IFNULL(s.total, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� � r� r* �fileZ io_global_by_file_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� �io_global_by_wait_by_bytesz %{TABLE}.total_requested DESCz5(e.total_requested-IFNULL(s.total_requested, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� � r� Z event_nameZ io_global_by_wait_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� Zschema_index_statisticszf(%{TABLE}.select_latency+%{TABLE}.insert_latency+%{TABLE}.update_latency+%{TABLE}.delete_latency) DESCz�((e.select_latency+e.insert_latency+e.update_latency+e.delete_latency)-IFNULL(s.select_latency+s.insert_latency+s.update_latency+s.delete_latency, 0)) DESCc C sH |d |d |d |d | d | d | d | d p@d dkS )NZ rows_selectedZinsert_latencyZ rows_updatedZ rows_deletedZ rows_insertedr r r� r r r r� � s "��z"table_schema,table_name,index_nameZschema_table_statisticsc C s |d | d pd dkS )N� total_latencyr r r� r r r r� � r� ztable_schema,table_nameZ#schema_tables_with_full_table_scansz %{TABLE}.rows_full_scanned DESCz9(e.rows_full_scanned-IFNULL(s.rows_full_scanned, 0)) DESCc C s |d | d pd dkS )NZrows_full_scannedr r r� r r r r� � r� zobject_schema,object_nameZ user_summaryz9(e.statement_latency-IFNULL(s.statement_latency, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� � r� �userZuser_summary_by_file_ioc C s |d | d pd dkS r� r r� r r r r� � r� Z user_summary_by_file_io_typez$%{TABLE}.user, %{TABLE}.latency DESCz-e.user, (e.latency-IFNULL(s.latency, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� � r� zuser,event_nameZuser_summary_by_stagesz*%{TABLE}.user, %{TABLE}.total_latency DESCz9e.user, (e.total_latency-IFNULL(s.total_latency, 0)) DESCc C s |d | d pd dkS r� r r� r r r r� � r� Z!user_summary_by_statement_latencyc C s |d | d pd dkS r� r r� r r r r� � r� Z user_summary_by_statement_typec C s |d | d pd dkS r� r r� r r r r� � r� zuser,statementZ"wait_classes_global_by_avg_latencyzBIFNULL(%{TABLE}.total_latency / NULLIF(%{TABLE}.total, 0), 0) DESCzhIFNULL((e.total_latency-IFNULL(s.total_latency, 0)) / NULLIF((e.total - IFNULL(s.total, 0)), 0), 0) DESCc C s |d | d pd dkS r� r r� r r r r� � r� Z event_classZ wait_classes_global_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� Zwaits_by_host_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� z host,eventZwaits_by_user_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� z user,eventZwaits_global_by_latencyc C s |d | d pd dkS r� r r� r r r r� � r� �eventsc @ sr e Zd Zg dfeee ed�dd�Zej ed�dd�Z ej ed�dd �Z ej ee d �d d �Z ej ed�d d�ZdS )� SQLExecutorT)r3 � custom_sql� allow_phasesc C sX || _ t|�}|s*|d s"|d r*td��g | _|D ] }| j�dd� t|�D �� q4d S )Nr r� zFOption 'customSql' may not contain before:, during: or after: prefixesc S s g | ]\}}d |� �|f�qS )Zscript_r )r- r� rK r r r r/ � s �z(SQLExecutor.__init__.<locals>.<listcomp>)r3 r r r� r~ � enumerate)rA r3 r� r� Zphasesrr r r r rE � s � �zSQLExecutor.__init__�rW r� c C s4 | j d }|r0td� t||� d�| j|dd� d S )Nr z Executing custom sql scriptsz custom_sql-F�ri �r� rN r� r3 �rA rW r� rr r r r �execute� s �zSQLExecutor.executec C s4 | j d }|r0td� t||� d�| j|dd� d S )Nr z%Executing custom 'before' sql scriptszcustom_sql-before-Fr� r� r� r r r �execute_before� s �zSQLExecutor.execute_before�rW r� � iterationc C s: | j d }|r6td� t||� d|� d�| j|dd� d S )Nr z/Executing custom 'during' iteration sql scriptszcustom_sql-iterationr( Fr� r� )rA rW r� r� rr r r r �execute_during� s �zSQLExecutor.execute_duringc C s4 | j d }|r0td� t||� d�| j|dd� d S )Nr� z$Executing custom 'after' sql scriptszcustom_sql-after-Fr� r� r� r r r � execute_after� s �zSQLExecutor.execute_afterN)rQ rR rS r' r rO r� rE r �ZipFiler� r� r# r� r� r r r r r� � s �� r� c @ s" e Zd Zeed�dd�Zejeed�dd�Z ejee d�dd �Z e ejee d �d d �Z d d� Zejed�dd�Zejed�dd�Zdd� Zdd� Zeejed�dd�Zejed�dd �Zejeee d�d d �Zejed�d d �Zejed�d!d"�Zejeee d�d#d$�Zejed�d%d&�Zd'S )(�DiagnosticsSession)r3 � innodb_mutexc C s� || _ d | _i | _i | _i | _i | _d| _d| _|| _| j j rl| j � d�� � d | _ | j � d�� � d | _ n d| _ d| _ | j jr�dd� | j � d��� D �| _ng | _| j � d� | j � d �� � \}}|r�|d kr�| j j r�d | _| j � d � nd| _d S ) NFzFselect sys.ps_is_consumer_enabled('events_waits_history_long') = 'YES'r zpselect EXISTS(SELECT 1 FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/%' AND ENABLED = 'YES')c S s g | ]}d |d �qS )zndbinfo.r r r, r r r r/ s z/DiagnosticsSession.__init__.<locals>.<listcomp>zshow tables in ndbinfoz%set session group_concat_max_len=2048z%select @@sql_log_bin, @@binlog_formatZROWTzSET SESSION sql_log_bin = 0)r3 �pfs_instrumentation�metrics� metrics_info� status_start� status_end�pfs_instrumentation_changed�has_performance_analyzerr� r6 r4 r5 � pfs_events_wait_history_long�pfs_memory_instrumentedr= r9 �ndbinfo_tables�disabled_binlog)rA r3 r� Zlog_binZ binlog_formatr r r rE � sJ ������ � zDiagnosticsSession.__init__)rW r� r� c C s� |dks t �| jjr8| �|� | �||� d|� d�� n|dkrHtd��| �d||�| _| �||d� | jjr�t d� z d D ]}| j� |� q|d | _ W nD t k r� } z&t d |� d |� �� t d � d| _ W 5 d }~X Y nX d S )N)�current�medium�fullz -applied_r( r� zAperformance_schema is disabled, instrumentation cannot be changed�startr z. - Preparing statement performance analyzer...)�4DROP TEMPORARY TABLE IF EXISTS sys.tmp_digests_startzPCALL sys.statement_performance_analyzer('create_tmp', 'tmp_digests_start', NULL)z?CALL sys.statement_performance_analyzer('snapshot', NULL, NULL)zJCALL sys.statement_performance_analyzer('save', 'tmp_digests_start', NULL)TzError executing �: z Related checks will be skippedF) �AssertionErrorr3 r6 �enable_pfs_instruments�collect_pfs_configr � fetch_statusr� �collect_metricsrN r4 r� rM )rA rW r� r� r� rP r r r r� $ s. �� zDiagnosticsSession.startr� c C s | � |||� | �|||� d S rF )r� �collect_other_stats)rA rW r� r� r r r �iterateG s zDiagnosticsSession.iterate)�delayrW r� �iter_fnc sb � ����fdd�}d �_ t� }t||fd��_�j�� �j d kr^|�� |�� |�� q:d S )Nc s| | � � d�_| �� | �� d}�jsxtd� ����|d � �|� |d7 }t� �D ]}�j�d� �jrZ q"qZq"d S )NFr zCollecting metrics...r zselect sleep(1)) �acquire� end_thread�notify�releaserN r� r� r3 r4 )�condr� r �r� r� r� rA rW r r �runloopN s z4DiagnosticsSession.start_background.<locals>.runloop)�targetrL )r� r r �threadr� r� �waitr� )rA r� rW r� r� r� r� r r� r �start_backgroundK s z#DiagnosticsSession.start_backgroundc C s d| _ | j�� d S )NT)r� r� rz rI r r r �stop_backgroundl s z"DiagnosticsSession.stop_backgroundr� c C s� | j jr�td� | �||� | �d||�| _| �||� dD ]}| j �|� q<| jr�t ||� d�| j ddd� dD ]}| j �|� qr| � ||� d S ) Nz( - Writing delta of collected metrics...�end)z-CALL sys.ps_statement_avg_latency_histogram()z%-statement_performance_analyzer-deltaziCALL sys.statement_performance_analyzer('delta', 'tmp_digests_start', 'with_runtimes_in_95th_percentile')F�re )r� z>CALL sys.statement_performance_analyzer('cleanup', NULL, NULL)) r3 r6 rN �dump_metrics_deltar� r� �dump_status_deltar4 r� r� �cleanup)rA rW r� r� r r r �finishp s$ �zDiagnosticsSession.finishc C s& | j jr| �� | jr"| j �d� d S )NzSET sql_log_bin = 1)r3 r6 �restore_pfs_instrumentsr� r4 )rA rW r� r r r r� � s zDiagnosticsSession.cleanupc C s� || _ | j�d� |dkrp| j�d��� d }|dkr>td� | jjdkr�| j�d��� d }|dkr�td� nhtd � | j�d � d | _|d kr�| j�d � | j�d� n |dkr�| j�d� | j�d� | j�d� d S )Nz1CALL sys.ps_setup_disable_thread(CONNECTION_ID())r� zKselect count(*) from performance_schema.setup_consumers where enabled='YES'r zCWARNING: performance_schema.setup_consumers is completely disabled.i�8 zIselect count(*) from performance_schema.setup_threads where enabled='YES'zAWARNING: performance_schema.setup_threads is completely disabled.z.Configuring Performance Schema InstrumentationzCALL sys.ps_setup_save(0)Tr� z�UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME NOT LIKE '%\_history%'z�UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME NOT LIKE 'wait/synch/%'r� zQUPDATE performance_schema.setup_consumers SET ENABLED = 'YES'zzUPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES'zzUPDATE performance_schema.threads SET INSTRUMENTED = 'YES' WHERE PROCESSLIST_ID <> CONNECTION_ID())r� r3 r4 r5 rN r8 r� )rA �levelrD r r r r� � sT ���� ��� ����z)DiagnosticsSession.enable_pfs_instrumentsc C s. | j dkr*| jr*td� | j�d� d| _d S )Nr� z+Restoring Performance Schema Configurationsz CALL sys.ps_setup_reload_saved()F)r� r� rN r3 r4 rI r r r r� � s z*DiagnosticsSession.restore_pfs_instruments)�stagerW r� c s� t tt d�� fdd� }i }tD ]~^}}}|s2t�d|�dd|� �� }d|� d|pVd � �} ||�} td |� d �� t||� d |� d |� �� j| d| d�||< q |S )N)r� r c s� � j �d| g��� }g }|D ]�\}|�� }| dkr:|dksJ| dkrV|dkrV|�t� q |�d�rl|�t� q |�d�s�|�d�s�|�d �s�|�d �s�|�d �r�|�d �s�|�t� q |�d d� � q |S )zb Assemble a query on a sys view, formatting columns to be human readable. �vselect column_name from information_schema.columns where table_schema='sys' and table_name=? order by ordinal_positionr� r� r� �total_requested�latency�_memory�_memory_allocated�_read�_written�_write�count_c S s | S rF r )r_ r r r r� � r� zODiagnosticsSession.fetch_status.<locals>.formatters_for_table.<locals>.<lambda>) r3 r4 r9 �lowerr~ r% �endswithr& � startswith)r� r} rh �column�lcolumnrI r r �formatters_for_table� s> � ��� ����� z=DiagnosticsSession.fetch_status.<locals>.formatters_for_tablez ORDER BY z%{TABLE}zx$zSELECT * FROM `sys`.`x$�`rV z - Gathering sys.r� z-raw/r) F)re rh ) rO r r �k_sys_views_deltar� r rN r� r3 ) rA r� rW r� r� �status� table_nameZorder_byr rk rh r rI r r� � s& �� z DiagnosticsSession.fetch_statusc s� t t ttt tt f d�� fdd� }tD ]̐^}}}|||�\}}g } | �dd�|� � t� j| � j | �D ]l\} } g } t |�D ]<\} }z| �|| | �� W q� t || | | � � Y q�X q�| �d�dd� | D ��� qrt ||� d|� �| � q*d S ) N)r �pkr c s& dd� �j �d| g��� D �}g }dd� �|D �]� � �� }d| d d| d krh|�� fdd�� q.| d kr�|d kr��fd d �}|�|� q.| |fd kr�� �fdd �}|�|� q.|d d� dkr�|�d�r�|�� fdd�� q.|dk�r�fdd �}|�|� q.|�d��r8� d d� ���fdd �}|�|� q.� �d��rX|�� fdd�� q.� dk�r�|dk�rpd nd �|dk�r�d nd ����fd d �}|�|� q.|�d ��s�|�d!��s�|�d"��s�|�d#��s�|�d$��r� �d%��s� �fd&d �}|�|� q.� �fd'd �}|�|� q.||fS )(Nc S s g | ] }|d �qS r+ r r0 r r r r/ s zVDiagnosticsSession.dump_status_delta.<locals>.formatters_for_table.<locals>.<listcomp>r� c S s | d kr | S t | �S rF �r� r r r r � float_or_none s zYDiagnosticsSession.dump_status_delta.<locals>.formatters_for_table.<locals>.float_or_none�,c s | � � S rF r r� �r� r r r� r� zTDiagnosticsSession.dump_status_delta.<locals>.formatters_for_table.<locals>.<lambda>r� Z write_pctc s� t |d p d�}� | d �}t |d p(d�}� | d �}|d ks\|d ks\|| || dkr`d S d|| || || d d�S )NZ total_readr Z total_writtenr* �.2fr )r rP Ze_readZs_readZ e_writtenZ s_written�r r r �fmt s ���zODiagnosticsSession.dump_status_delta.<locals>.formatters_for_table.<locals>.fmt))r� r� )r� r� c s4 �|� �}t | � pd�} |d kr(d S t|| �S �Nr �r� r% r� �r� r r r r ) s � )Zmax_Zmin_�_latencyc s |� d k r t t|� ��S d S rF �r& r� r� r r r r� 3 s � �Z avg_latencyc sl t |d p d�}� | d �}t |d p(d�}� | d �}|d ksT|d ksT|| dkrXd S t|| || �S )Nr� r r� �r� r& �r rP Ze_latZs_lat�e_total�s_totalr r r r 7 s �Z _avg_latencyi�c s� t |�� d� pd�}� | �� d� �}t |�� d� p:d�}� | �� d� �}|d ksl|d ksl|| dkrpd S t|| || �S )Nr r r r r )r r� r r r E s �r� c s0 t |� d k r*t|� �t| � p$d� nd �S r r r� r r r r� Q s � �)�avg_readZ avg_writeZ avg_writtenr �readZwrittenr] c s� t | d�� � pd�}� | d�� � �}t |d�� � p:d�}� | d�� � �}|d ks`|d krdd S || }|| }|dkr�d S t|| �S )NZtotal_r r� r )r rP r r Ze_countZs_countr$ �d)r �suffix�suffix2r r r X s r� r� r� r� r� r� c s4 �|� �}t | � pd�}|d kr(d S t|| �S r r )r rP �e_�s_r r r r l s c s2 t | � p d�}�|� �}|d kr(d S || � S r r )r rP r r r r r r x s )r3 r4 r9 r� r~ r� r� )r r r} Zfcolumnsr� r rI )r� r r� r r r r� sh �� � ����� zBDiagnosticsSession.dump_status_delta.<locals>.formatters_for_tablers rt c S s g | ] }|pd �qS )r( r )r- r r r r r/ � s z8DiagnosticsSession.dump_status_delta.<locals>.<listcomp>z-delta.) rO r r r r� r~ rz �zipr� r� r� rN rd )rA rW r� r� r r r r} rh �linesZ start_rowZend_rowr� r� r r rI r r� s* � � z$DiagnosticsSession.dump_status_deltac C s� | j js d S |d kr |� d�}n|� d|� d�}t||| j dddd�}|D ]P}|d }|d }|d } |d } d | jkr�| | g| j|< | j�|g ��|� qJd S ) Nr� �-raw/iteration-z.metricszkSELECT Variable_name, REPLACE(Variable_value, ' ', '\\n') AS Variable_value, Type, Enabled FROM sys.metricsF�re rj � Variable_nameZVariable_value�Type�Enabled�name)r3 r6 r� r� r� � setdefaultr~ ) rA rW r� r� rX r� r� r" �valuer� �enabledr r r r� � s* � z"DiagnosticsSession.collect_metricsc s< ddg�dg� ddg��fdd�| j jD �}|� fdd�| j jD �7 }|�fd d�| j jD �7 }| j jrr|�d � | j jr�d D ] }|| j jkr~|�d | � q~d d� }| j jdkr�d}d}nd}d}dddd|� �dd|� d�dd|fd g}| j j�r|d d d g7 }t||| j |d d!� t ||| j |d d!� | � ||� d S )"NZ host_cacheZpersisted_variables�pluginsZaudit_log_userZaudit_log_filterc s( g | ] }|� d �s|� krd|� ��qS )Z replication_�performance_schema.)r� r, )�other_pfs_tablesr r r/ � s �z@DiagnosticsSession.collect_configs_and_state.<locals>.<listcomp>c s g | ]}|� krd |� ��qS )zinformation_schema.r r, )r; r r r/ � s �c s g | ]}|� krd |� ��qS )zmysql.r r, )r< r r r/ � s �zndbinfo.threadblocks)r2 Zrpd_exec_statsZrpd_query_statsr' c S s t | �} d| d< | S )Nz*****� )rU �r� r r r �filter_slave_master_info� s zNDiagnosticsSession.collect_configs_and_state.<locals>.filter_slave_master_infoi�8 ZREPLICAZREPLICASZSLAVEz SLAVE HOSTS)zglobal variablesa SELECT g.variable_name name, g.variable_value value /*!80000, i.variable_source source*/ FROM performance_schema.global_variables g /*!80000 JOIN performance_schema.variables_info i ON g.variable_name = i.variable_name */ ORDER BY namezXA RECOVER CONVERT xidzSHOW BINARY LOGSzSHOW zSHOW MASTER STATUSz STATUSzreplication master_infoz;SELECT * FROM mysql.slave_master_info ORDER BY Channel_name)zreplication relay_log_infoz{SELECT Channel_name, Sql_delay, Number_of_workers, Id FROM mysql.slave_relay_log_info ORDER BY Channel_name)zrapid table statusa SELECT rpd_table_id.ID, rpd_table_id.Name, rpd_tables.* FROM performance_schema.rpd_table_id, performance_schema.rpd_tables WHERE rpd_tables.ID = rpd_table_id.ID ORDER BY rpd_table_id.SCHEMA_NAME,rpd_table_id.TABLE_NAME)zrapid total table sizezCSELECT SUM(IFNULL(SIZE_BYTES,0)) FROM performance_schema.rpd_tables)zrapid avail_rnstate nodesz�SELECT IFNULL(SUM(memory_total), 0), IFNULL(SUM(memory_usage), 0), IFNULL(SUM(BASEREL_MEMORY_USAGE),0) FROM performance_schema.rpd_nodes WHERE status = 'AVAIL_RNSTATE'Tr� ) r3 r: r; r< r= r~ r> r8 r� r� r� ) rA rW r� r� r. r+ Z kw_replicaZ kw_replicasr� r )r; r< r( r �collect_configs_and_state� sZ � � � �� �z,DiagnosticsSession.collect_configs_and_statec C s& dddddg}t ||| j|dd� d S )N)z pfs actorsz-SELECT * FROM performance_schema.setup_actors)z pfs objectsz.SELECT * FROM performance_schema.setup_objects)z pfs consumersz�SELECT NAME AS Consumer, ENABLED, sys.ps_is_consumer_enabled(NAME) AS COLLECTS FROM performance_schema.setup_consumers)zpfs instrumentsa SELECT SUBSTRING_INDEX(NAME, '/', 2) AS 'InstrumentClass', ROUND(100*SUM(IF(ENABLED = 'YES', 1, 0))/COUNT(*), 2) AS 'EnabledPct', ROUND(100*SUM(IF(TIMED = 'YES', 1, 0))/COUNT(*), 2) AS 'TimedPct' FROM performance_schema.setup_instruments GROUP BY SUBSTRING_INDEX(NAME, '/', 2) ORDER BY SUBSTRING_INDEX(NAME, '/', 2))z pfs threadsz�SELECT `TYPE` AS ThreadType, COUNT(*) AS 'Total', ROUND(100*SUM(IF(INSTRUMENTED = 'YES', 1, 0))/COUNT(*), 2) AS 'InstrumentedPct' FROM performance_schema.threads GROUP BY TYPETr� )r� r3 )rA rW r� r� r r r r� � s �z%DiagnosticsSession.collect_pfs_configc C s� ddddddddd g }| j r&|�d � | jr<|d d d dg7 }dddddg}| jrZ|dg7 }| jjr�|ddg7 }|dd� | jD �7 }|dg7 }|d k r�|d|� d�7 }t||| j|d d � t||| j|d d � d S ) Nz!performance_schema.metadata_lockszperformance_schema.threadszsys.schema_table_lock_waitszsys.session_ssl_statusz sys.sessionzsys.processlistz'performance_schema.events_waits_currentz information_schema.innodb_trxz!information_schema.innodb_metricszsys.latest_file_ioz#sys.memory_by_host_by_current_bytesz%sys.memory_by_thread_by_current_bytesz#sys.memory_by_user_by_current_bytesz"sys.memory_global_by_current_byteszSHOW GLOBAL STATUSzSHOW ENGINE INNODB STATUSz%SHOW ENGINE PERFORMANCE_SCHEMA STATUSzSHOW FULL PROCESSLISTzSHOW OPEN TABLESzSHOW ENGINE INNODB MUTEXz SHOW ENGINE NDBCLUSTER STATUS)zndb memoryusagez�SELECT node_id, memory_type, format_bytes(used) AS used, used_pages, format_bytes(total) AS total, total_pages, ROUND(100*(used/total), 2) AS 'Used %' FROM ndbinfo.memoryusagec S s g | ]}|d kr|�qS )zndbinfo.memoryusager r, r r r r/ < s z:DiagnosticsSession.collect_other_stats.<locals>.<listcomp>zinformation_schema.FILESr r) Tr� ) r� r~ r� r� r3 r= r� r� r� )rA rW r� r� r� r� r r r r� sP � � � �� z&DiagnosticsSession.collect_other_statsc C s | j js dS dddddddd d d d d dddddddg}dd� }d}|�|� d�d����}d}| j�� D �]�\}} |r�dg} tdt| �d �D ]8} | �d | � �� | dkr�| �d | d � d | � d �� q�| d d!g7 } |�d"� | �d# � d$�� d%}|g} ||k} d} d&}d}t | �D ]�\} }d'}||�}| �|d|� � | d&k�r�| �s�|dk �r�t | jd( | �}t | jd( | d �}|dk �r�| dk �r�|| k�r�d)}n"|| � d*|| || d+�d,�}| �|� |} �q| | j | 7 } |�d"� | �d# � d$�� qfW 5 Q R X dS )-z� Format all collected metrics iterations and format into a human readable form, also including delta values between each iteration. NZ innodb_buffer_pool_pages_totalZinnodb_page_sizeZlast_query_costZlast_query_partial_plansZqcache_total_blocksZslave_last_heartbeatZssl_ctx_verify_depthZssl_ctx_verify_modeZssl_session_cache_sizeZssl_verify_depthZssl_verify_mode� ssl_versionZbuffer_flush_lsn_avg_rateZbuffer_flush_pct_for_dirtyZbuffer_flush_pct_for_lsnZbuffer_pool_pages_totalZlock_row_lock_time_avgZlock_row_lock_time_maxc S s z t | �W S Y d S X d S rF r r r r r �asnum^ s z4DiagnosticsSession.dump_metrics_delta.<locals>.asnum�2 z-metrics.summary.tsvrb Tr r zOutput zDelta (z -> �)r r! rt rl r[ Fr rV zUNIX_TIMESTAMP()z 0 (0/sec)z (r z/sec))r3 r6 rc r� �itemsr� r� r~ r] rz r^ r� r� r� )rA rW r� Zno_delta_namesr. Zmax_field_lengthr_ �firstr" �valuesr` r� Zno_delta�prevZ prev_timeZnvaluer$ �delta�timer r r r� G st � � " z%DiagnosticsSession.dump_metrics_deltaN)rQ rR rS r' r� rE r r� rO r� r# r� r r� r� r� r� r� r� r� r� r r� r, r� r� r� r r r r r� � s2 ,� #� !80 � P� 2r� ) rW r� r3 � iterationsr� �pfsInstrumentationr� r� � custom_shellc C s� t |dd�} t||d�} �zFt||dd�} | �| |� | �| |� | �| |� � | �| |� d�|� t|�D ]�} td| d � d|� d�� | �| |� d�| d � | � | || � | � | || � | d7 } | |d k�rtd |� d �� z|� d |g� W n t k �r td � � Y nX ql �q"ql|d k�r4td� | � | |� d�� | � | |� | � | |� W n | �| |� � Y nX d S )NT�r� �r� � diagnosticsz+Collecting performance metrics (iteration #r z of z)...z Sleeping for zs...zselect sleep(?)z^C - aborting...r z#Performance metrics collection done)r r� r� r� r, r� r� rN r� r� r4 �KeyboardInterruptr� r� r� ) rW r� r3 r7 r� r8 r� r� r9 �shell�diag�customr� r r r �collect_diagnostics� s@ � rA )rW r� r3 r� r� c C sf t ||d�}zFt||dd�}|�| |� |�| |� |�| |d � |�| |d � W 5 |�| |� X d S )Nr; Fr: )r� r� r� r� r, r� r� )rW r� r3 r� r� r? r@ r r r �collect_diagnostics_once� s rB )rW r� r3 r c C s� d }z|� d��� }W n� tk r� } z�|jtjjksD|jtjjkrP| W Y �hS |r�td|� �� | � t |� d��d��&}|� d� |� |� d�� d�� W 5 Q R X | W Y �S � W 5 d }~X Y nX d}d} td � |D ]p} d | d kr�d }nd | d kr�d } | d dk�r | d dk�r q�| d } t | |� d| � �|d| � �d |d� q�d}|�sZ| �r�|� d��� d } | dk�r|d}n.z |� d��� d } | �r�d}W n Y nX |S )Nz1show full tables in mysql_innodb_cluster_metadataz0ERROR: Could not query InnoDB Cluster metadata: z#mysql_innodb_cluster_metadata.errorrb s2 show full tables in mysql_innodb_cluster_metadata rl r[ Fz/Dumping mysql_innodb_cluster_metadata schema...Zasync_cluster_viewsr TZclusterset_viewsr z BASE TABLE)Zschema_versionz mysql_innodb_cluster_metadata.r� �grzGselect cluster_type from mysql_innodb_cluster_metadata.v2_this_instance�arzDselect count(*) from mysql_innodb_cluster_metadata.v2_cs_clustersets�cs)r4 r9 r r� r r� ZER_BAD_DB_ERRORZER_NO_SUCH_TABLErN rc r r] r^ r� r5 ) rW r� r3 ri � cluster_typer1 rP r_ Z rs_possibleZ cs_possibler� r� r. r r r �collect_cluster_metadata� sv � �� � �� ��rG �r3 c C sD zdd� | � d��� D �W S dd� | � d��� D � Y S X d S )Nc S s g | ]}|d |d f�qS �r r r r0 r r r r/ s z(get_topology_members.<locals>.<listcomp>zLselect instance_id, endpoint from mysql_innodb_cluster_metadata.v2_instancesc S s g | ]}|d |d f�qS rI r r0 r r r r/ s z]select instance_id, addresses->>'$.mysqlClassic' from mysql_innodb_cluster_metadata.instances)r4 r9 rH r r r �get_topology_members s � �rJ )rW r r3 ri r c C s< |j dkr4td� dd� }t| ||d|d|d� dS dS d S ) Ni�8 z - Gathering error_logc S s d| d krd S | S )Nztemporary passwordr) r r* r r r � filter_pwd s z)collect_error_log_sql.<locals>.filter_pwdz performance_schema.error_logFr� T)r8 rN r� )rW r r3 ri rK r r r �collect_error_log_sql s �rL r� )rW r� r3 ri c C s4 ddg}d|j kr |�d� t| |||d|d� d S )N)zslow queries in 95 pctilez=SELECT * FROM sys.statements_with_runtimes_in_95th_percentile)z%slow queries summary by rows examinedaG SELECT DIGEST, substr(DIGEST_TEXT, 1, 50), COUNT_STAR, SUM_ROWS_EXAMINED, SUM_ROWS_SENT, round(SUM_ROWS_SENT/SUM_ROWS_EXAMINED, 5) ratio FROM performance_schema.events_statements_summary_by_digest where DIGEST_TEXT like 'select%' and (SUM_ROWS_SENT/SUM_ROWS_EXAMINED) < .5 ORDER BY SUM_ROWS_EXAMINED/SUM_ROWS_SENT desc limit 20�slow_log)rM z SELECT * FROM mysql.slow_logTr� )r< r~ r� )rW r� r3 ri r� r r r �collect_slow_queries1 s � �rN )rW r� r3 c C s@ t d� |�d��� }| �t|� d��d���}|D ]�}|d |d }}|�d|� d|� d ��d �� z8|jd ||gd ��� D ] } |�| d d �d �� q�W n� tk �r$ } zd|r�t d |� d|� d| � �� |�d|� d|� d| � d ��d �� n t d|� d|� d| � �� � W 5 d } ~ X Y nX |�d� q4W 5 Q R X d S )Nz8Collecting InnoDB Cluster accounts and grant informationzAselect user,host from mysql.user where user like 'mysql_innodb_%'zcluster_accounts.tsvrb r r z-- �@rl r[ zshow grants for ?@?)rL z"WARNING: Error getting grants for r� zCould not get grants for z ERROR: Error getting grants for r\ )rN r4 r9 rc r r] r^ rM ) rW r� r3 ri Zaccountsr_ r� r� r� r1 rP r r r � collect_innodb_cluster_accountsI s4 � � � ��rP c C sF |r t d� ddddg}|r,|dddd g7 }t| |� ||d |d � d S ) Nz,Collecting Schema Information and Statistics)zschema tables without a PKa� SELECT t.table_schema, t.table_name, t.table_rows, t.engine, t.data_length, t.index_length FROM information_schema.tables t LEFT JOIN information_schema.statistics s on t.table_schema=s.table_schema and t.table_name=s.table_name and s.index_name='PRIMARY' WHERE s.index_name is NULL and t.table_type = 'BASE TABLE' and t.table_schema not in ('performance_schema', 'sys', 'mysql', 'information_schema'))zschema routine sizezvSELECT ROUTINE_TYPE, COUNT(*), SUM(LENGTH(ROUTINE_DEFINITION)) FROM information_schema.ROUTINES GROUP BY ROUTINE_TYPE;)zschema table countz.SELECT count(*) FROM information_schema.tables)zschema unused indexesz'SELECT * FROM sys.schema_unused_indexes)zschema object overviewz(select * from sys.schema_object_overview)zschema top biggest tablesa� select t.table_schema, t.table_name, t.row_format, t.table_rows, t.avg_row_length, t.data_length, t.max_data_length, t.index_length, t.table_collation, json_objectagg(idx.index_name, json_object('columns', idx.col, 'type', idx.index_type, 'cardinality', idx.cardinality)) indexes, group_concat((select concat(c.column_name, ':', c.column_type) from information_schema.columns c where c.table_schema = t.table_schema and c.table_name = t.table_name and c.column_type in ('blob'))) blobs from information_schema.tables t join (select s.table_schema, s.table_name, s.index_name, s.index_type, s.cardinality, json_arrayagg(concat(c.column_name, ':', c.column_type)) col from information_schema.statistics s left join information_schema.columns c on s.table_schema=c.table_schema and s.table_name=c.table_name and s.column_name=c.column_name group by s.table_schema, s.table_name, s.index_name, s.index_type, s.cardinality order by s.table_schema, s.table_name, s.index_name, s.index_type, s.cardinality) idx on idx.table_schema=t.table_schema and idx.table_name = t.table_name where t.table_type = 'BASE TABLE' and t.table_schema not in ('mysql', 'information_schema', 'performance_schema') group by t.table_schema, t.table_name, t.engine, t.row_format, t.table_rows, t.avg_row_length, t.data_length, t.max_data_length, t.index_length, t.table_collation order by t.data_length desc limit 20)zschema table enginesa> SELECT ENGINE, COUNT(*) AS NUM_TABLES, sys.format_bytes(SUM(DATA_LENGTH)) AS DATA_LENGTH, sys.format_bytes(SUM(INDEX_LENGTH)) AS INDEX_LENGTH, sys.format_bytes(SUM(DATA_LENGTH+INDEX_LENGTH)) AS TOTAL FROM information_schema.TABLES GROUP BY ENGINE)zschema table infoz'SELECT * FROM information_schema.TABLESTr� )rN r� )rW r� r3 r� ri r� r r r �collect_schema_statsg s* ���rQ )rW r� r3 �schemar� c C s | � t|� dt|�� dt|�� d��d����}dd� }|�d||g��� }|srtd|� d |� d �� W 5 Q R � d S ||�}g }g } g } g } |d d kr�|�d t�|�� dt�|�� ���� d } �n|�dt�|�� dt�|�� ���� d } |�dt�|�� dt�|�� ��} t | jd �D ]}|� ||�� �q |�d||g�} t | jd �D ]}| � ||�� �qN|�d||g�} t | jd �D ]}| � ||�� �q�|�d||g�} t | jd �D ]}| � ||�� �q�|||| || | | d�}|� t � |��d�� W 5 Q R X d S )Nzreferenced_table-r) ry rb c S s t �t| ��dd��S )Nrl z\n)�json�loadsrO r )r r r r � pythonize� s z%collect_table_info.<locals>.pythonizezMSELECT * FROM information_schema.tables WHERE table_schema=? AND table_name=?z WARNING: Could not find table `z`.`z.` referenced in query (try 'USE schema' first)Z TABLE_TYPEZVIEWzSHOW CREATE VIEW r zSHOW CREATE TABLE r zSHOW INDEX IN z^SELECT * FROM information_schema.triggers WHERE EVENT_OBJECT_SCHEMA=? AND EVENT_OBJECT_TABLE=?zMSELECT * FROM mysql.innodb_table_stats WHERE database_name=? AND table_name=?zMSELECT * FROM mysql.innodb_index_stats WHERE database_name=? AND table_name=?)z Table Namez Table Schemaz Table StatusZDDLZIndexesZTriggerszInnoDB Table StatszInnoDB Index Statsr[ )rc r r! r4 �fetch_one_objectrN r �quote_identifierr5 r� r~ r] r� �dumpr^ )rW r� r3 rR r� r_ rU Z table_statusZindexesZtriggersZ table_statsZ index_statsZddlr� r1 r� r r r �collect_table_info� s� ���� ��������� rY )rW r3 rk r� r c C s� dddg}|D ]}|� |� qt| |� d�|d|� �ddd� t| |� d �|d dd � d g}|D ]}|� |� q`d d|� �fg}|jdkr�|�dd|� �f� t| |||dd�S )N�(SET SESSION optimizer_trace='enabled=on'z SET optimizer_trace_offset=-1zSET optimizer_trace_limit=1Zexplain�EXPLAIN FTr zexplain-optimizer_trace�0SELECT * FROM information_schema.optimizer_tracer� �)SET SESSION optimizer_trace='enabled=off'Z explain_jsonzEXPLAIN format=json i�8 Zexplain_analyzezEXPLAIN ANALYZE )rj )r4 r� r8 r~ r� )rW r3 rk r� �beforer� �afterr� r r r � explain_query� s4 � �� r` )rW r3 rk r� c C s@ ddd|� �ddddd|� �ddd d g }t | |� d �||� d S ) Nz#SET SESSION use_secondary_engine=ONz SELECT NOW()r[ z!SHOW SESSION STATUS LIKE 'rapid%'rZ z SET optimizer_trace_offset=-2z~SELECT query, trace->'$**.Rapid_Offload_Fails', trace->'$**.secondary_engine_not_used' FROM information_schema.optimizer_tracer\ z$SET SESSION use_secondary_engine=OFFr] zexplain-rapid.txt)r� )rW r3 rk r� r� r r r �explain_heatwave_query s ��ra )rV )F)FF)4Zmultiprocessingr � threadingr �mysqlshr r �typingr r r r r� rS r r � host_infor r rO r r r! r% r& r' r� rU rd r� r� r� �dictr� r� r� r� r� r� r# r� rA rB rG rJ rL rN rP rQ rY r` ra r r r r �<module> s: B�� � c�� � � �� # � " � � � � � � � � � � � � � � � � � � � � � � � � ��R< &�� 7�� � 7 � �� �� ! �� 9 � I � �
Save
Cancel