Long-Term Supported Versions

    Innovation Versions

      #� �M�y�S�Q�L� �P�e�r�f�o�r�m�a�n�c�e� �T�u�n�i�n�g� �G�u�i�d�e� � � � �#�#� �I�n�t�r�o�d�u�c�t�i�o�n� � � � �#�#�#� �T�u�n�i�n�g� �G�u�i�d�e�l�i�n�e�s� � � � �T�h�e� �M�y�S�Q�L� �p�e�r�f�o�r�m�a�n�c�e� �v�a�r�i�e�s� �d�e�p�e�n�d�i�n�g� �o�n� �t�h�e� �h�a�r�d�w�a�r�e�,� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m� �(�O�S�)�,� �a�n�d� �b�a�s�i�c� �s�o�f�t�w�a�r�e� �i�n� �u�s�e�.� �I�t� �i�s� �a�l�s�o� �a�f�f�e�c�t�e�d� �b�y� �t�h�e� �d�e�s�i�g�n� �o�f� �e�a�c�h� �s�u�b�s�y�s�t�e�m�,� �a�l�g�o�r�i�t�h�m�s� �u�s�e�d�,� �a�n�d� �c�o�m�p�i�l�e�r� �s�e�t�t�i�n�g�s�.� � � � �O�b�s�e�r�v�e� �t�h�e� �f�o�l�l�o�w�i�n�g� �g�u�i�d�e�l�i�n�e�s� �w�h�e�n� �t�u�n�i�n�g� �t�h�e� �p�e�r�f�o�r�m�a�n�c�e�:� �T�h�e� �g�u�i�d�e�l�i�n�e�s� �a�r�e� �a�s� �f�o�l�l�o�w�s�:� � � � �D�u�r�i�n�g� �p�e�r�f�o�r�m�a�n�c�e� �a�n�a�l�y�s�i�s�,� �a�n�a�l�y�z�e� �s�y�s�t�e�m� �r�e�s�o�u�r�c�e� �b�o�t�t�l�e�n�e�c�k�s� �f�r�o�m� �m�u�l�t�i�p�l�e� �a�s�p�e�c�t�s�.� �P�o�o�r� �s�y�s�t�e�m� �p�e�r�f�o�r�m�a�n�c�e� �m�a�y� �n�o�t� �b�e� �c�a�u�s�e�d� �b�y� �t�h�e� �s�y�s�t�e�m� �i�t�s�e�l�f� �b�u�t� �b�y� �o�t�h�e�r� �f�a�c�t�o�r�s�.� �F�o�r� �e�x�a�m�p�l�e�,� �h�i�g�h� �C�P�U� �u�s�a�g�e� �m�a�y� �b�e� �c�a�u�s�e�d� �b�y� �i�n�s�u�f�f�i�c�i�e�n�t� �m�e�m�o�r�y� �c�a�p�a�c�i�t�y� �a�n�d� �t�h�e� �C�P�U� �r�e�s�o�u�r�c�e�s� �m�a�y� �b�e� �e�x�h�a�u�s�t�e�d� �b�y� �m�e�m�o�r�y� �s�c�h�e�d�u�l�i�n�g�.� � � � �-� �A�d�j�u�s�t� �o�n�l�y� �o�n�e� �p�a�r�a�m�e�t�e�r� �o�f� �a� �s�p�e�c�i�f�i�c� �a�s�p�e�c�t� �t�h�a�t� �a�f�f�e�c�t�s� �t�h�e� �p�e�r�f�o�r�m�a�n�c�e� �a�t� �a� �t�i�m�e�.� �I�t� �i�s� �d�i�f�f�i�c�u�l�t� �t�o� �d�e�t�e�r�m�i�n�e� �w�h�i�c�h� �p�a�r�a�m�e�t�e�r� �c�a�u�s�e�s� �t�h�e� �i�m�p�a�c�t� �o�n� �p�e�r�f�o�r�m�a�n�c�e� �w�h�e�n� �m�u�l�t�i�p�l�e� �p�a�r�a�m�e�t�e�r�s� �a�r�e� �a�d�j�u�s�t�e�d� �a�t� �t�h�e� �s�a�m�e� �t�i�m�e�.� � � � �-� �D�u�r�i�n�g� �t�h�e� �s�y�s�t�e�m� �p�e�r�f�o�r�m�a�n�c�e� �a�n�a�l�y�s�i�s�,� �t�h�e� �p�e�r�f�o�r�m�a�n�c�e� �a�n�a�l�y�s�i�s� �t�o�o�l� �a�l�s�o� �c�o�n�s�u�m�e�s� �c�e�r�t�a�i�n� �C�P�U� �a�n�d� �m�e�m�o�r�y� �r�e�s�o�u�r�c�e�s�,� �w�h�i�c�h� �m�a�y� �w�o�r�s�e�n� �t�h�e� �r�e�s�o�u�r�c�e� �b�o�t�t�l�e�n�e�c�k� �o�f� �t�h�e� �s�y�s�t�e�m�.� � �-� �E�n�s�u�r�e� �t�h�a�t� �t�h�e� �p�r�o�g�r�a�m� �r�u�n�s� �p�r�o�p�e�r�l�y� �a�f�t�e�r� �p�e�r�f�o�r�m�a�n�c�e� �t�u�n�i�n�g�.� � �-� �P�e�r�f�o�r�m�a�n�c�e� �t�u�n�i�n�g� �i�s� �a� �c�o�n�t�i�n�u�o�u�s� �p�r�o�c�e�s�s�.� �T�h�e� �r�e�s�u�l�t� �o�f� �e�a�c�h� �t�u�n�i�n�g� �s�h�o�u�l�d� �b�e� �f�e�d� �t�o� �t�h�e� �s�u�b�s�e�q�u�e�n�t� �v�e�r�s�i�o�n� �d�e�v�e�l�o�p�m�e�n�t�.� � �-� �P�e�r�f�o�r�m�a�n�c�e� �t�u�n�i�n�g� �c�a�n�n�o�t� �c�o�m�p�r�o�m�i�s�e� �c�o�d�e� �r�e�a�d�a�b�i�l�i�t�y� �a�n�d� �m�a�i�n�t�a�i�n�a�b�i�l�i�t�y�.� � � � �#�#�#� �T�u�n�i�n�g� �F�l�o�w� � � � �I�d�e�n�t�i�f�y� �p�r�o�b�l�e�m�s�,� �f�i�n�d� �p�e�r�f�o�r�m�a�n�c�e� �b�o�t�t�l�e�n�e�c�k�s�,� �a�n�d� �d�e�t�e�r�m�i�n�e� �a� �t�u�n�i�n�g� �m�e�t�h�o�d� �b�a�s�e�d� �o�n� �t�h�e� �b�o�t�t�l�e�n�e�c�k� �l�e�v�e�l�.� � � � �T�h�e� �f�o�l�l�o�w�i�n�g� �f�i�g�u�r�e� �s�h�o�w�s� �t�h�e� �M�y�S�Q�L� �t�u�n�i�n�g� �f�l�o�w�.� � � � �!�[�]�(�.�/�f�i�g�u�r�e�s�/�m�y�s�q�l�-�t�u�n�i�n�g�-�f�l�o�w�.�p�n�g�)� � � � �T�h�e� �t�u�n�i�n�g� �a�n�a�l�y�s�i�s� �p�r�o�c�e�s�s� �i�s� �a�s� �f�o�l�l�o�w�s�:� � � � �-� �I�n� �m�o�s�t� �c�a�s�e�s�,� �e�v�e�n� �b�e�f�o�r�e� �t�h�e� �e�n�t�i�r�e� �p�r�e�s�s�u�r�e� �t�e�s�t� �t�r�a�f�f�i�c� �e�n�t�e�r�s� �t�h�e� �s�e�r�v�e�r�,� �t�h�e� �p�r�e�s�s�u�r�e� �t�e�s�t� �r�e�s�u�l�t� �m�a�y� �f�a�i�l� �t�o� �m�e�e�t� �t�h�e� �e�x�p�e�c�t�a�t�i�o�n� �d�u�e� �t�o� �n�e�t�w�o�r�k� �f�a�c�t�o�r�s�,� �s�u�c�h� �a�s� �t�h�e� �b�a�n�d�w�i�d�t�h�,� �m�a�x�i�m�u�m� �n�u�m�b�e�r� �o�f� �c�o�n�n�e�c�t�i�o�n�s�,� �a�n�d� �l�i�m�i�t� �o�n� �t�h�e� �n�u�m�b�e�r� �o�f� �n�e�w� �c�o�n�n�e�c�t�i�o�n�s�.� � �-� �C�h�e�c�k� �w�h�e�t�h�e�r� �t�h�e� �k�e�y� �m�e�t�r�i�c�s� �m�e�e�t� �r�e�q�u�i�r�e�m�e�n�t�s�.� �I�f� �n�o�t�,� �l�o�c�a�t�e� �t�h�e� �p�o�s�s�i�b�l�e� �p�r�o�b�l�e�m� �c�a�u�s�e�s�.� �T�h�e� �p�r�o�b�l�e�m�s� �m�a�y� �e�x�i�s�t� �o�n� �a� �s�e�r�v�e�r� �(�i�n� �m�o�s�t� �c�a�s�e�s�)� �o�r� �a� �c�l�i�e�n�t� �(�i�n� �f�e�w� �c�a�s�e�s�)�.� � �-� �I�f� �t�h�e� �p�r�o�b�l�e�m� �c�a�u�s�e� �i�s� �o�n� �a� �s�e�r�v�e�r�,� �c�h�e�c�k� �t�h�e� �h�a�r�d�w�a�r�e� �m�e�t�r�i�c�s� �s�u�c�h� �a�s� �t�h�e� �C�P�U�,� �m�e�m�o�r�y�,� �d�r�i�v�e� �I�/�O�,� �a�n�d� �n�e�t�w�o�r�k� �I�/�O� �m�e�t�r�i�c�s�.� �I�f� �a�n�y� �a�b�n�o�r�m�a�l� �h�a�r�d�w�a�r�e� �m�e�t�r�i�c� �i�s� �d�e�t�e�c�t�e�d�,� �f�u�r�t�h�e�r� �a�n�a�l�y�s�i�s� �i�s� �r�e�q�u�i�r�e�d�.� � �-� �I�f� �t�h�e� �h�a�r�d�w�a�r�e� �m�e�t�r�i�c�s� �a�r�e� �n�o�r�m�a�l�,� �c�h�e�c�k� �t�h�e� �d�a�t�a�b�a�s�e� �m�e�t�r�i�c�s�,� �s�u�c�h� �a�s� �t�h�e� �w�a�i�t� �e�v�e�n�t�s� �a�n�d� �m�e�m�o�r�y� �h�i�t� �r�a�t�i�o�.� � �-� �I�f� �h�a�r�d�w�a�r�e� �a�n�d� �d�a�t�a�b�a�s�e� �m�e�t�r�i�c�s� �a�r�e� �n�o�r�m�a�l�,� �c�h�e�c�k� �t�h�e� �a�l�g�o�r�i�t�h�m�s�,� �b�u�f�f�e�r�,� �c�a�c�h�e�,� �s�y�n�c�h�r�o�n�i�z�a�t�i�o�n�,� �a�n�d� �a�s�y�n�c�h�r�o�n�i�z�a�t�i�o�n�.� �I�f� �a�n�y� �a�b�n�o�r�m�a�l� �m�e�t�r�i�c� �i�s� �d�e�t�e�c�t�e�d�,� �f�u�r�t�h�e�r� �a�n�a�l�y�s�i�s� �i�s� �r�e�q�u�i�r�e�d�.� � � � �#�#� �H�a�r�d�w�a�r�e� �T�u�n�i�n�g� � � � �#�#�#� �P�u�r�p�o�s�e� � � � �Y�o�u� �c�a�n� �c�o�n�f�i�g�u�r�e� �a�d�v�a�n�c�e�d� �B�I�O�S� �s�e�t�t�i�n�g�s� �f�o�r� �d�i�f�f�e�r�e�n�t� �s�e�r�v�e�r� �h�a�r�d�w�a�r�e� �t�o� �i�m�p�r�o�v�e� �s�e�r�v�e�r� �p�e�r�f�o�r�m�a�n�c�e�.� � � � �#�#�#� �M�e�t�h�o�d� � � � �T�h�i�s� �m�e�t�h�o�d� �a�p�p�l�i�e�s� �t�o� �K�u�n�p�e�n�g� �s�e�r�v�e�r�s�.� �F�o�r� �x�8�6� �s�e�r�v�e�r�s�,� �s�u�c�h� �a�s� �I�n�t�e�l� �s�e�r�v�e�r�s�,� �y�o�u� �c�a�n� �r�e�t�a�i�n� �t�h�e� �d�e�f�a�u�l�t� �B�I�O�S� �c�o�n�f�i�g�u�r�a�t�i�o�n�s�.� � � � �1�.� � �D�i�s�a�b�l�e� �t�h�e� �S�M�M�U� �(�o�n�l�y� �f�o�r� �t�h�e� �K�u�n�p�e�n�g� �s�e�r�v�e�r�)�.� � �2�.� � �D�u�r�i�n�g� �t�h�e� �s�e�r�v�e�r� �r�e�s�t�a�r�t�,� �p�r�e�s�s� ��D�e�l�e�t�e�� �t�o� �a�c�c�e�s�s� �t�h�e� �B�I�O�S�,� �c�h�o�o�s�e� ��A�d�v�a�n�c�e�d�� �\�>� ��M�I�S�C� �C�o�n�f�i�g��,� �a�n�d� �p�r�e�s�s� ��E�n�t�e�r��.� � �3�.� � �S�e�t� ��S�u�p�p�o�r�t� �S�m�m�u�� �t�o� ��D�i�s�a�b�l�e��.� � � � � � � � �N�o�t�e�:� �D�i�s�a�b�l�e� �t�h�e� �S�M�M�U� �f�e�a�t�u�r�e� �o�n�l�y� �i�n� �n�o�n�-�v�i�r�t�u�a�l�i�z�a�t�i�o�n� �s�c�e�n�a�r�i�o�s�.� �I�n� �v�i�r�t�u�a�l�i�z�a�t�i�o�n� �s�c�e�n�a�r�i�o�s�,� �e�n�a�b�l�e� �t�h�e� �S�M�M�U�.� � � � �4�.� � �D�i�s�a�b�l�e� �p�r�e�f�e�t�c�h�.� � � � � � � � �-� �O�n� �t�h�e� �B�I�O�S�,� �c�h�o�o�s�e� ��A�d�v�a�n�c�e�d�� �\�>� ��M�I�S�C� �C�o�n�f�i�g�� �a�n�d� �p�r�e�s�s� ��E�n�t�e�r��.� � � � � � � � �-� �S�e�t� ��C�P�U� �P�r�e�f�e�t�c�h�i�n�g� �C�o�n�f�i�g�u�r�a�t�i�o�n�� �t�o� ��D�i�s�a�b�l�e�d�� �a�n�d� �p�r�e�s�s� ��F�1�0��.� � � � �#�#� �O�S� �T�u�n�i�n�g� � � � �#�#�#� �N�I�C� �I�n�t�e�r�r�u�p�t�-�C�o�r�e� �B�i�n�d�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �T�o� �i�m�p�r�o�v�e� �s�y�s�t�e�m� �n�e�t�w�o�r�k� �p�e�r�f�o�r�m�a�n�c�e�,� �y�o�u� �c�a�n� �d�i�s�a�b�l�e� �t�h�e� �i�r�q�b�a�l�a�n�c�e� �s�e�r�v�i�c�e� �a�n�d� �m�a�n�u�a�l�l�y� �b�i�n�d� �N�I�C� �i�n�t�e�r�r�u�p�t�s� �t�o� �d�e�d�i�c�a�t�e�d� �c�o�r�e�s� �t�o� �i�s�o�l�a�t�e� �N�I�C� �i�n�t�e�r�r�u�p�t�s� �f�r�o�m� �s�e�r�v�i�c�e� �r�e�q�u�e�s�t�s�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �T�h�e� �o�p�t�i�m�a�l� �n�u�m�b�e�r� �o�f� �C�P�U�s� �f�o�r� �b�i�n�d�i�n�g� �i�n�t�e�r�r�u�p�t�s� �v�a�r�i�e�s� �d�e�p�e�n�d�i�n�g� �o�n� �t�h�e� �h�a�r�d�w�a�r�e� �c�o�n�f�i�g�u�r�a�t�i�o�n�.� �F�o�r� �e�x�a�m�p�l�e�,� �t�h�e� �o�p�t�i�m�a�l� �n�u�m�b�e�r� �o�f� �C�P�U�s� �f�o�r� �b�i�n�d�i�n�g� �i�n�t�e�r�r�u�p�t�s� �o�n� �t�h�e� �K�u�n�p�e�n�g� �9�2�0� �5�2�5�0� �p�r�o�c�e�s�s�o�r� �i�s� �5�.� �Y�o�u� �c�a�n� �o�b�s�e�r�v�e� �t�h�e� �u�s�a�g�e� �o�f� �t�h�e� �f�i�v�e� �C�P�U�s� �t�o� �d�e�t�e�r�m�i�n�e� �w�h�e�t�h�e�r� �t�o� �a�d�j�u�s�t� �t�h�e� �n�u�m�b�e�r�.� � � � �T�h�e� �f�o�l�l�o�w�i�n�g� �s�c�r�i�p�t� �i�s� �u�s�e�d� �t�o� �s�e�t� �t�h�e� �o�p�t�i�m�a�l� �i�n�t�e�r�r�u�p�t� �b�i�n�d�i�n�g� �f�o�r� �M�y�S�Q�L� �w�h�e�n� �t�h�e� �K�u�n�p�e�n�g� �9�2�0� �5�2�5�0� �p�r�o�c�e�s�s�o�r� �a�n�d� �H�u�a�w�e�i� �T�M�2�8�0� �2�5�G� �N�I�C� �a�r�e� �u�s�e�d�.� ��$�1�� �i�n�d�i�c�a�t�e�s� �t�h�e� �N�I�C� �n�a�m�e�,� ��$�2�� �i�n�d�i�c�a�t�e�s� �t�h�e� �n�u�m�b�e�r� �o�f� �q�u�e�u�e�s� �(�5�)�,� �a�n�d� �t�h�e� ��$�3�� �i�n�d�i�c�a�t�e�s� �t�h�e� �b�u�s� �n�a�m�e� �c�o�r�r�e�s�p�o�n�d�i�n�g� �t�o� �t�h�e� �N�I�C�,� �w�h�i�c�h� �c�a�n� �b�e� �q�u�e�r�i�e�d� �b�y� �r�u�n�n�i�n�g� �ethtool -i <NIC_name>�:� � � � �shell #!/bin/bash eth1=$1 cnt=$2 bus=$3 ethtool -L $eth1 combined $cnt irq1=�c�a�t� �/�p�r�o�c�/�i�n�t�e�r�r�u�p�t�s�|� �g�r�e�p� �-�E� �$�{�b�u�s�}� �|� �h�e�a�d� �-�n�$�c�n�t� �|� �a�w�k� �-�F� �'�:�'� �'�{�p�r�i�n�t� �$�1�}�'� irq1=�e�c�h�o� �$�i�r�q�1� cpulist=(91 92 93 94 95) # Set the cores dedicated for handling interrupts. c=0 forirq in $irq1 do echo ${cpulist[c]} "->" $irq echo ${cpulist[c]} > /proc/irq/$irq/smp_affinity_list let "c++" done � � � � ��N�o�t�e�:� �I�f� �G�a�z�e�l�l�e� �i�s� �u�s�e�d�,� �y�o�u� �d�o� �n�o�t� �n�e�e�d� �t�o� �u�s�e� �t�h�e� �m�e�t�h�o�d� �d�e�s�c�r�i�b�e�d� �i�n� �t�h�i�s� �s�e�c�t�i�o�n�.�� � � � �#�#�#� �N�U�M�A� �C�o�r�e� �B�i�n�d�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �N�U�M�A� �c�o�r�e� �b�i�n�d�i�n�g� �r�e�d�u�c�e�s� �c�r�o�s�s�-�N�U�M�A� �m�e�m�o�r�y� �a�c�c�e�s�s� �a�n�d� �i�m�p�r�o�v�e�s� �s�y�s�t�e�m� �m�e�m�o�r�y� �a�c�c�e�s�s� �p�e�r�f�o�r�m�a�n�c�e�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �B�a�s�e�d� �o�n� �t�h�e� �N�I�C� �i�n�t�e�r�r�u�p�t� �s�e�t�t�i�n�g�s� �i�n� �t�h�e� �p�r�e�v�i�o�u�s� �s�e�c�t�i�o�n�,� �s�e�t� �t�h�e� �N�U�M�A� �c�o�r�e� �b�i�n�d�i�n�g� �r�a�n�g�e� �t�o� �t�h�e� �r�e�m�a�i�n�i�n�g� �c�o�r�e�s� �(�0� �t�o� �9�0�)� �b�e�f�o�r�e� �r�u�n�n�i�n�g� �t�h�e� �M�y�S�Q�L� �s�t�a�r�t�u�p� �c�o�m�m�a�n�d�.� ��$�m�y�s�q�l�_�p�a�t�h�� �i�n�d�i�c�a�t�e�s� �t�h�e� �M�y�S�Q�L� �i�n�s�t�a�l�l�a�t�i�o�n� �p�a�t�h�.� � � � �shell numactl -C 0-90 -i 0-3 $mysql_path/bin/mysqld --defaults-file=/etc/my.cnf & � � � � ��N�o�t�e�:� �I�f� �G�a�z�e�l�l�e� �i�s� �u�s�e�d�,� �y�o�u� �d�o� �n�o�t� �n�e�e�d� �t�o� �u�s�e� �t�h�e� �m�e�t�h�o�d� �d�e�s�c�r�i�b�e�d� �i�n� �t�h�i�s� �s�e�c�t�i�o�n�.�� � � � �#�#�#� �S�c�h�e�d�u�l�i�n�g� �P�a�r�a�m�e�t�e�r� �T�u�n�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �I�n� �h�i�g�h�-�l�o�a�d� �s�c�e�n�a�r�i�o�s�,� �t�h�e� �C�P�U� �u�t�i�l�i�z�a�t�i�o�n� �c�a�n�n�o�t� �r�e�a�c�h� �1�0�0�%�.� �I�n�-�d�e�p�t�h� �a�n�a�l�y�s�i�s� �o�f� �t�h�e� �s�c�h�e�d�u�l�i�n�g� �t�r�a�c�e� �o�f� �e�a�c�h� �t�h�r�e�a�d� �s�h�o�w�s� �t�h�a�t� �t�h�e� �k�e�r�n�e�l� �c�a�n�n�o�t� �f�i�n�d� �a� �p�r�o�p�e�r� �p�r�o�c�e�s�s� �f�o�r� �m�i�g�r�a�t�i�o�n� �d�u�r�i�n�g� �l�o�a�d� �b�a�l�a�n�c�i�n�g�.� �A�s� �a� �r�e�s�u�l�t�,� �t�h�e� �C�P�U� �i�s� �i�n�t�e�r�m�i�t�t�e�n�t�l�y� �i�d�l�e� �a�n�d� �l�o�a�d� �b�a�l�a�n�c�i�n�g� �f�a�i�l�s�,� �w�a�s�t�i�n�g� �C�P�U� �r�e�s�o�u�r�c�e�s�.� �Y�o�u� �c�a�n� �e�n�a�b�l�e� �t�h�e� �o�p�e�n�E�u�l�e�r� �S�T�E�A�L� �m�o�d�e� �t�o� �f�u�r�t�h�e�r� �i�m�p�r�o�v�e� �t�h�e� �C�P�U� �u�t�i�l�i�z�a�t�i�o�n� �a�n�d� �s�y�s�t�e�m� �p�e�r�f�o�r�m�a�n�c�e�.� �(��T�h�i�s� �f�e�a�t�u�r�e� �i�s� �a�v�a�i�l�a�b�l�e� �i�n� �o�p�e�n�E�u�l�e�r� �2�0�.�0�3� �S�P�2� �a�n�d� �l�a�t�e�r� �v�e�r�s�i�o�n�s�.��)� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �1�.� �A�d�d� ��s�c�h�e�d�_�s�t�e�a�l�_�n�o�d�e�_�l�i�m�i�t�=�4�� �t�o� �t�h�e� �e�n�d� �o�f� �t�h�e� �k�e�r�n�e�l� �s�t�a�r�t�u�p� �i�t�e�m�s� �i�n� ��/�e�t�c�/�g�r�u�b�2�-�e�f�i�.�c�f�g��,� �a�s� �s�h�o�w�n� �i�n� �t�h�e� �f�o�l�l�o�w�i�n�g� �f�i�g�u�r�e�.� � � � �!�[�]�(�.�/�f�i�g�u�r�e�s�/�k�e�r�n�e�l�-�b�o�o�t�-�o�p�t�i�o�n�-�p�a�r�a�m�e�t�e�r�s�.�p�n�g�)� � � � �A�f�t�e�r� �t�h�e� �m�o�d�i�f�i�c�a�t�i�o�n�,� �r�e�b�o�o�t� �t�h�e� �s�y�s�t�e�m� �f�o�r� �t�h�e� �m�o�d�i�f�i�c�a�t�i�o�n� �t�o� �t�a�k�e� �e�f�f�e�c�t�.� � � � �1�.� �S�e�t� �t�h�e� �S�T�E�A�L� �s�c�h�e�d�u�l�i�n�g� �f�e�a�t�u�r�e� �a�s� �f�o�l�l�o�w�s� �a�f�t�e�r� �t�h�e� �r�e�b�o�o�t�:� � � � �shell echo STEAL > /sys/kernel/debug/sched_features � � � � �#�#�#� �M�e�m�o�r�y� �H�u�g�e�p�a�g�e� �O�p�t�i�m�i�z�a�t�i�o�n� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �T�h�e� �t�r�a�n�s�l�a�t�i�o�n� �l�o�o�k�a�s�i�d�e� �b�u�f�f�e�r� �(�T�L�B�)� �i�s� �t�h�e� �h�i�g�h�-�s�p�e�e�d� �c�a�c�h�e� �i�n� �t�h�e� �C�P�U� �f�o�r� �t�h�e� �p�a�g�e� �t�a�b�l�e� �t�h�a�t� �s�t�o�r�e�s� �t�h�e� �m�a�p�p�i�n�g� �b�e�t�w�e�e�n� �t�h�e� �p�a�g�e� �a�d�d�r�e�s�s�e�s� �o�f� �t�h�e� �v�i�r�t�u�a�l� �a�d�d�r�e�s�s�e�s� �a�n�d� �t�h�e� �p�a�g�e� �a�d�d�r�e�s�s�e�s� �o�f� �t�h�e� �p�h�y�s�i�c�a�l� �a�d�d�r�e�s�s�e�s�.� �A� �h�i�g�h�e�r� �T�L�B� �h�i�t� �r�a�t�i�o� �i�n�d�i�c�a�t�e�s� �b�e�t�t�e�r� �p�a�g�e� �t�a�b�l�e� �q�u�e�r�y� �p�e�r�f�o�r�m�a�n�c�e�.� �I�n� �a� �g�i�v�e�n� �s�e�r�v�i�c�e� �s�c�e�n�a�r�i�o�,� �i�n�c�r�e�a�s�i�n�g� �t�h�e� �m�e�m�o�r�y� �p�a�g�e� �s�i�z�e� �c�a�n� �i�m�p�r�o�v�e� �t�h�e� �T�L�B� �h�i�t� �r�a�t�i�o� �a�n�d� �a�c�c�e�s�s� �e�f�f�i�c�i�e�n�c�y�,� �t�h�e�r�e�b�y� �i�m�p�r�o�v�i�n�g� �t�h�e� �s�e�r�v�e�r� �p�e�r�f�o�r�m�a�n�c�e�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �-� �C�h�a�n�g�e� �t�h�e� �m�e�m�o�r�y� �p�a�g�e� �s�i�z�e� �o�f� �t�h�e� �k�e�r�n�e�l�.� � � � � � �R�u�n� �t�h�e� �getconf PAGESIZE� �c�o�m�m�a�n�d� �t�o� �c�h�e�c�k� �t�h�e� �m�e�m�o�r�y� �p�a�g�e� �s�i�z�e�.� �I�f� �t�h�e� �m�e�m�o�r�y� �p�a�g�e� �s�i�z�e� �i�s� �4�0�9�6� �(�4� �K�B�)�,� �y�o�u� �c�a�n� �i�n�c�r�e�a�s�e� �t�h�e� �p�a�g�e� �s�i�z�e� �b�y� �c�h�a�n�g�i�n�g� �t�h�e� �m�e�m�o�r�y� �p�a�g�e� �s�i�z�e� �v�a�l�u�e� �o�f� �t�h�e� �L�i�n�u�x� �k�e�r�n�e�l�.� �Y�o�u� �n�e�e�d� �t�o� �r�e�c�o�m�p�i�l�e� �t�h�e� �k�e�r�n�e�l� �a�f�t�e�r� �m�o�d�i�f�y�i�n�g� �t�h�e� �k�e�r�n�e�l� �c�o�m�p�i�l�a�t�i�o�n� �o�p�t�i�o�n�s�.� �T�h�e� �p�r�o�c�e�d�u�r�e� �i�s� �a�s� �f�o�l�l�o�w�s�:� � � � � � �1�.� �R�u�n� �make menuconfig�.� � � � � � �2�.� �S�e�t� ��P�A�G�E�S�I�Z�E�� �t�o� �6�4�K� �(��K�e�r�n�e�l� �F�e�a�t�u�r�e�s�-�-�\�>�P�a�g�e� �s�i�z�e�(�6�4�K�B�)��)�.� � � � � � �3�.� �C�o�m�p�i�l�e� �a�n�d� �i�n�s�t�a�l�l� �t�h�e� �k�e�r�n�e�l�.� � � � �#�#�#� �G�a�z�e�l�l�e� �P�r�o�t�o�c�o�l� �S�t�a�c�k� �T�u�n�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �T�h�e� �d�e�e�p� �l�a�y�e�r�s� �o�f� �t�h�e� �n�a�t�i�v�e� �k�e�r�n�e�l� �n�e�t�w�o�r�k� �p�r�o�t�o�c�o�l� �s�t�a�c�k� �b�r�i�n�g� �h�i�g�h� �o�v�e�r�h�e�a�d� �a�n�d� �h�i�g�h� �s�y�s�t�e�m� �c�a�l�l� �c�o�s�t�s�.� �T�h�e� �G�a�z�e�l�l�e� �u�s�e�r�-�m�o�d�e� �p�r�o�t�o�c�o�l� �s�t�a�c�k� �c�a�n� �b�e� �u�s�e�d� �t�o� �r�e�p�l�a�c�e� �t�h�e� �k�e�r�n�e�l� �p�r�o�t�o�c�o�l� �s�t�a�c�k�.� �B�y� �h�o�o�k�i�n�g� �t�h�e� �P�O�S�I�X� �i�n�t�e�r�f�a�c�e�s�,� �G�a�z�e�l�l�e� �e�l�i�m�i�n�a�t�e�s� �o�v�e�r�h�e�a�d�s� �c�a�u�s�e�d� �b�y� �s�y�s�t�e�m� �c�a�l�l�s�,� �t�h�e�r�e�b�y� �g�r�e�a�t�l�y� �i�m�p�r�o�v�i�n�g� �t�h�e� �n�e�t�w�o�r�k� �I�/�O� �t�h�r�o�u�g�h�p�u�t� �o�f� �a�n� �a�p�p�l�i�c�a�t�i�o�n�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �1�.� �I�n�s�t�a�l�l� �t�h�e� �d�e�p�e�n�d�e�n�c�y� �p�a�c�k�a�g�e�s�.� � � � �C�o�n�f�i�g�u�r�e� �t�h�e� �Y�u�m� �s�o�u�r�c�e� �o�f� �o�p�e�n�E�u�l�e�r� �a�n�d� �r�u�n� �t�h�e� �yum� �c�o�m�m�a�n�d� �t�o� �i�n�s�t�a�l�l� �t�h�e� �d�e�p�e�n�d�e�n�c�i�e�s�.� � � � �shell yum install dpdk libconfig numactl libboundsheck libcap gazelle � � � � �I�n�s�t�a�l�l� �t�h�e� �k�o� �f�i�l�e� �a�s� �t�h�e� ��r�o�o�t�� �u�s�e�r�.� � � � �B�i�n�d� �t�h�e� �N�I�C� �f�r�o�m� �t�h�e� �k�e�r�n�e�l� �d�r�i�v�e�r� �t�o� �t�h�e� �u�s�e�r�-�m�o�d�e� �d�r�i�v�e�r�.� �C�h�o�o�s�e� �o�n�e� �o�f� �t�h�e� �f�o�l�l�o�w�i�n�g� �.�k�o� �f�i�l�e�s� �a�s� �r�e�q�u�i�r�e�d�.� �T�h�e� �M�L�X�4� �a�n�d� �M�L�X�5� �N�I�C�s� �d�o� �n�o�t� �n�e�e�d� �t�o� �b�e� �b�o�u�n�d� �t�o� �t�h�e� �V�F�I�O� �o�r� �U�I�O� �d�r�i�v�e�r�.� � � � �shell #If the IOMMU is available modprobe vfio-pci #If the IOMMU is not available and the VFIO supports the no-IOMMU mode modprobe vfio enable_unsafe_noiommu_mode=1 modprobe vfio-pci #Other cases modprobe igb_uio � � � � �3�.� �B�i�n�d� �D�P�D�K� �t�o� �a�n� �N�I�C�.� � � � �B�i�n�d� �t�h�e� �s�e�r�v�i�c�e� �N�I�C� �(�e�n�p�3�s�0� �i�s� �u�s�e�d� �a�s� �a�n� �e�x�a�m�p�l�e�)� �t�o� �t�h�e� �d�r�i�v�e�r� �s�e�l�e�c�t�e�d� �i�n� �t�h�e� �p�r�e�v�i�o�u�s� �s�t�e�p� �t�o� �p�r�o�v�i�d�e� �a�n� �i�n�t�e�r�f�a�c�e� �f�o�r� �t�h�e� �u�s�e�r�-�m�o�d�e� �N�I�C� �d�r�i�v�e�r� �t�o� �a�c�c�e�s�s� �N�I�C� �r�e�s�o�u�r�c�e�s�.� � � � �shell #Remove the service NIC enp3s0. ip link set enp3s0 down #Use vfio-pci dpdk-devbind -b vfio-pci enp3s0 #Use igb_uio dpdk-devbind -b igb_uio enp3s0 � � � � �4�.� �C�o�n�f�i�g�u�r�e� �m�e�m�o�r�y� �h�u�g�e�p�a�g�e�s�.� � � � �G�a�z�e�l�l�e� �u�s�e�s� �h�u�g�e�p�a�g�e� �m�e�m�o�r�y� �t�o� �i�m�p�r�o�v�e� �e�f�f�i�c�i�e�n�c�y�.� �Y�o�u� �c�a�n� �c�o�n�f�i�g�u�r�e� �a�n�y� �s�i�z�e� �f�o�r� �t�h�e� �m�e�m�o�r�y� �h�u�g�e�p�a�g�e�s� �r�e�s�e�r�v�e�d� �b�y� �t�h�e� �s�y�s�t�e�m� �u�s�i�n�g� �t�h�e� ��r�o�o�t�� �p�e�r�m�i�s�s�i�o�n�s�.� �S�e�l�e�c�t� �a� �p�a�g�e� �s�i�z�e� �b�a�s�e�d� �a�s� �r�e�q�u�i�r�e�d� �a�n�d� �c�o�n�f�i�g�u�r�e� �s�u�f�f�i�c�i�e�n�t� �m�e�m�o�r�y� �h�u�g�e�p�a�g�e�s�.� �B�y� �d�e�f�a�u�l�t�,� �2� �G�B� �h�u�g�e�p�a�g�e� �m�e�m�o�r�y� �i�s� �c�o�n�f�i�g�u�r�e�d� �f�o�r� �e�a�c�h� �m�e�m�o�r�y� �n�o�d�e�,� �a�n�d� �t�h�e� �p�a�g�e� �s�i�z�e� �i�s� �2� �M�B�.� � � � �shell #Statically allocate 2 MB memory hugepages: 2M * 1024*4 = 8G echo 8192 > /sys/kernel/mm/hugepages/hugepages-2048kB/nr_hugepages #View configuration results. grep Huge /proc/meminfo � � � � �5�.� �M�o�u�n�t� �h�u�g�e�p�a�g�e� �m�e�m�o�r�y�.� � � � �T�o� �c�r�e�a�t�e� �a� �d�i�r�e�c�t�o�r�y� �f�o�r� �t�h�e� �l�s�t�a�c�k� �p�r�o�c�e�s�s� �t�o� �a�c�c�e�s�s� �h�u�g�e�p�a�g�e� �m�e�m�o�r�y�,� �r�u�n� �t�h�e� �f�o�l�l�o�w�i�n�g� �c�o�m�m�a�n�d�s�:� � � � �shell mkdir -p /mnt/hugepages-gazelle chmod -R 700 /mnt/hugepages-gazelle mount -t hugetlbfs nodev /mnt/hugepages-gazelle -o pagesize=2M � � � � �6�.� �U�s�e� �G�a�z�e�l�l�e� �f�o�r� �t�h�e� �a�p�p�l�i�c�a�t�i�o�n�.� � � � �U�s�e� ��L�D�_�P�R�E�L�O�A�D�� �t�o� �p�r�e�l�o�a�d� �t�h�e� �d�y�n�a�m�i�c� �l�i�b�r�a�r�y� �o�f� �G�a�z�e�l�l�e�.� �U�s�e� ��G�A�Z�E�L�L�E�_�B�I�N�D�_�P�R�O�C�N�A�M�E�� �t�o� �s�p�e�c�i�f�y� �t�h�e� �M�y�S�Q�L� �p�r�o�c�e�s�s� �n�a�m�e�.� � � � �shell GAZELLE_BIND_PROCNAME=mysqld LD_PRELOAD=/usr/lib64/liblstack.so $mysql_path/bin/mysqld --defaults-file=/etc/my.cnf --bind-address=192.168.1.10 & � � � � �I�n� �t�h�e� �p�r�e�c�e�d�i�n�g� �c�o�m�m�a�n�d�,� �t�h�e� �p�a�r�a�m�e�t�e�r� �o�f� �bind-address� �i�s� �t�h�e� �I�P� �a�d�d�r�e�s�s� �o�f� �t�h�e� �s�e�r�v�i�c�e� �N�I�C� �o�n� �t�h�e� �s�e�r�v�e�r�,� �w�h�i�c�h� �m�u�s�t� �b�e� �t�h�e� �s�a�m�e� �a�s� �t�h�e� �v�a�l�u�e� �o�f� ��h�o�s�t�_�a�d�d�r�� �i�n� �t�h�e� �G�a�z�e�l�l�e� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e�.� � � � �7�.� �M�o�d�i�f�y� �t�h�e� �G�a�z�e�l�l�e� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e�.� � � � �T�M�o�d�i�f�y� �t�h�e� �G�a�z�e�l�l�e� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e� ��/�e�t�c�/�g�a�z�e�l�l�e�/�l�s�t�a�c�k�.�c�o�n�f�� �b�a�s�e�d� �o�n� �t�h�e� �h�a�r�d�w�a�r�e� �e�n�v�i�r�o�n�m�e�n�t� �a�n�d� �s�o�f�t�w�a�r�e� �r�e�q�u�i�r�e�m�e�n�t�s�.� �T�h�e� �f�o�l�l�o�w�i�n�g� �i�s� �a�n� �e�x�a�m�p�l�e�:� � � � �shell dpdk_args=["--socket-mem", "2048,2048,2048,2048", "--huge-dir", "/mnt/hugepages-gazelle", "--proc-type", "primary", "--legacy-mem", "--map-perfect"] use_ltran=0 kni_switch=0 low_power_mode=0 listen_shadow=1 num_cpus="18,38,58,78 " host_addr="192.168.1.10" mask_addr="255.255.255.0" gateway_addr="192.168.1.1" devices="aa:bb:cc:dd:ee:ff" � � � � �T�h�e� ��-�-�s�o�c�k�e�t�-�m�e�m�� �p�a�r�a�m�e�t�e�r� �i�n�d�i�c�a�t�e�s� �t�h�e� �m�e�m�o�r�y� �a�l�l�o�c�a�t�e�d� �t�o� �e�a�c�h� �m�e�m�o�r�y� �n�o�d�e�.� �T�h�e� �d�e�f�a�u�l�t� �v�a�l�u�e� �i�s� �2�0�4�8� �(�M�B�)�.� �I�n� �t�h�i�s� �e�x�a�m�p�l�e�,� �f�o�u�r� �m�e�m�o�r�y� �n�o�d�e�s� �a�r�e� �a�l�l�o�c�a�t�e�d� �w�i�t�h� �2� �G�B� �(�2�0�4�8�)� �m�e�m�o�r�y�.� �T�h�e� ��-�-�h�u�g�e�-�d�i�r�� �p�a�r�a�m�e�t�e�r� �i�n�d�i�c�a�t�e�s� �t�h�e� �d�i�r�e�c�t�o�r�y� �t�o� �w�h�i�c�h� �h�u�g�e�p�a�g�e� �m�e�m�o�r�y� �i�s� �m�o�u�n�t�e�d�.� ��n�u�m�_�c�p�u�s�� �r�e�c�o�r�d�s� �t�h�e� �I�D�s� �o�f� �t�h�e� �C�P�U�s� �b�o�u�n�d� �t�o� �t�h�e� �l�s�t�a�c�k� �t�h�r�e�a�d�.� �Y�o�u� �c�a�n� �s�e�l�e�c�t� �C�P�U�s� �b�y� �N�U�M�A� �n�o�d�e�.� �T�h�e� ��h�o�s�t�_�a�d�d�r��,� ��m�a�s�k�_�a�d�d�r��,� ��g�a�t�e�w�a�y�_�a�d�d�r��,� �a�n�d� ��d�e�v�i�c�e�s�� �p�a�r�a�m�e�t�e�r�s� �i�n�d�i�c�a�t�e� �t�h�e� �I�P� �a�d�d�r�e�s�s�,� �s�u�b�n�e�t� �m�a�s�k�,� �g�a�t�e�w�a�y� �a�d�d�r�e�s�s�,� �a�n�d� �M�A�C� �a�d�d�r�e�s�s� �o�f� �t�h�e� �s�e�r�v�i�c�e� �N�I�C�,� �r�e�s�p�e�c�t�i�v�e�l�y� �.� � � � �F�o�r� �d�e�t�a�i�l�s�,� �s�e�e� �t�h�e� �[�G�a�z�e�l�l�e� �U�s�e�r� �G�u�i�d�e�]�(�h�t�t�p�s�:�/�/�g�i�t�e�e�.�c�o�m�/�o�p�e�n�e�u�l�e�r�/�g�a�z�e�l�l�e�/�b�l�o�b�/�m�a�s�t�e�r�/�d�o�c�/�G�a�z�e�l�l�e�%�E�4�%�B�D�%�B�F�%�E�7�%�9�4�%�A�8�%�E�6�%�8�C�%�8�7�%�E�5�%�8�D�%�9�7�.�m�d�)� � � � �#�#� �M�y�S�Q�L� �T�u�n�i�n�g� � � � �#�#�#� �D�a�t�a�b�a�s�e� �P�a�r�a�m�e�t�e�r� �T�u�n�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �M�o�d�i�f�y� �d�a�t�a�b�a�s�e� �p�a�r�a�m�e�t�e�r� �s�e�t�t�i�n�g�s� �t�o� �i�m�p�r�o�v�e� �s�e�r�v�e�r� �p�e�r�f�o�r�m�a�n�c�e�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �T�h�e� �d�e�f�a�u�l�t� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e� �p�a�t�h� �i�s� ��/�e�t�c�/�m�y�.�c�n�f��.� �Y�o�u� �c�a�n� �u�s�e� �t�h�e� �f�o�l�l�o�w�i�n�g� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e� �p�a�r�a�m�e�t�e�r�s� �t�o� �s�t�a�r�t� �t�h�e� �d�a�t�a�b�a�s�e�:� � � � �shell [mysqld_safe] log-error=/data/mysql/log/mysql.log pid-file=/data/mysql/run/mysqld.pid [client] socket=/data/mysql/run/mysql.sock default-character-set=utf8 [mysqld] basedir=/usr/local/mysql tmpdir=/data/mysql/tmp datadir=/data/mysql/data socket=/data/mysql/run/mysql.sock port=3306 user=root default_authentication_plugin=mysql_native_password ssl=0 # Disable SSL. max_connections=2000 # Set the maximum number of connections. back_log=2048 #Set the number of cached session requests. performance_schema=OFF # Disable the performance mode. max_prepared_stmt_count=128000 #file innodb_file_per_table=on # Set one file for each table. innodb_log_file_size=1500M # Set the log file size. innodb_log_files_in_group=32 # Set the number of log file groups. innodb_open_files=4000 # Set the maximum number of tables that can be opened. #buffers innodb_buffer_pool_size=230G # Set the buffer pool size, which is generally 60% of the server memory. innodb_buffer_pool_instances=16 # Set the number of buffer pool instances to improve the concurrency capability. innodb_log_buffer_size=64M # Set the log buffer size. #tune sync_binlog=1 # Set the number of sync_binlog transactions to be submitted for drive flushing each time. innodb_flush_log_at_trx_commit=1 # Each time when a transaction is submitted, MySQL writes the data in the log buffer to the log file and flushes the data to drives. innodb_use_native_aio=1 # Enable asynchronous I/O. innodb_spin_wait_delay=180 # Set the spin_wait_delay parameter to prevent system spin. innodb_sync_spin_loops=25 # Set the spin_loops loop times to prevent system spin. innodb_spin_wait_pause_multiplier=25 # Set a multiplier value used to determine the number of PAUSE instructions in spin-wait loops. innodb_flush_method=O_DIRECT # Set the open and write modes of InnoDB data files and redo logs. innodb_io_capacity=20000 # Set the maximum IOPS of InnoDB background threads. innodb_io_capacity_max=40000 # Set the maximum IOPS of InnoDB background threads under pressure. innodb_lru_scan_depth=9000 # Set the number of dirty pages flushed by the page cleaner thread each time. innodb_page_cleaners=16 # Set the number of threads for writing dirty data to drives. table_open_cache_instances=32 # Set the maximum number of table cache instances. table_open_cache=30000 # Set the maximum number of open tables cached in one table cache instance. #perf special innodb_flush_neighbors=0 # Check all pages in the extent where the page is located. If the page is dirty, flush all pages. This parameter is disabled for SSDs. innodb_write_io_threads=16 # Set the number of write threads. innodb_read_io_threads=16 # Set the number of read threads. innodb_purge_threads=32 # Set the number of undo page threads to be purged. innodb_adaptive_hash_index=0 sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL_TABLES � � � � �T�a�b�l�e� �1� �D�a�t�a�b�a�s�e� �p�a�r�a�m�e�t�e�r�s� � � � �|� �P�a�r�a�m�e�t�e�r� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �D�e�s�c�r�i�p�t�i�o�n� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �T�u�n�i�n�g� �S�u�g�g�e�s�t�i�o�n� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-� �|� �-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-� �|� �-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-�-� �|� � �|� �i�n�n�o�d�b�_�t�h�r�e�a�d�_�c�o�n�c�u�r�r�e�n�c�y� � � � � � � � � � � � � � � � � � � � � � � � � � �|� �O�S� �t�h�r�e�a�d�s� �u�s�e�d� �b�y� �I�n�n�o�D�B� �t�o� �p�r�o�c�e�s�s� �t�h�e� �u�s�e�r� �t�r�a�n�s�a�c�t�i�o�n� �r�e�q�u�e�s�t�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �T�h�e� �d�e�f�a�u�l�t� �v�a�l�u�e� ��0�� �i�s� �r�e�c�o�m�m�e�n�d�e�d�,� �t�h�a�t� �i�s�,� �t�h�e� �n�u�m�b�e�r� �o�f� �c�o�n�c�u�r�r�e�n�t� �t�h�r�e�a�d�s� �i�s� �n�o�t� �l�i�m�i�t�e�d� �b�y� �d�e�f�a�u�l�t�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�r�e�a�d�_�i�o�_�t�h�r�e�a�d�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �t�h�r�e�a�d�s� �t�h�a�t� �p�r�o�c�e�s�s� �t�h�e� �r�e�a�d� �r�e�q�u�e�s�t�s� �i�n� �t�h�e� �r�e�q�u�e�s�t� �q�u�e�u�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �b�a�s�e�d� �o�n� �t�h�e� �n�u�m�b�e�r� �o�f� �C�P�U� �c�o�r�e�s� �a�n�d� �t�h�e� �r�e�a�d�/�w�r�i�t�e� �r�a�t�i�o�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�w�r�i�t�e�_�i�o�_�t�h�r�e�a�d�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �t�h�r�e�a�d�s� �t�h�a�t� �p�r�o�c�e�s�s� �t�h�e� �w�r�i�t�e� �r�e�q�u�e�s�t�s� �i�n� �t�h�e� �r�e�q�u�e�s�t� �q�u�e�u�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �b�a�s�e�d� �o�n� �t�h�e� �n�u�m�b�e�r� �o�f� �C�P�U� �c�o�r�e�s� �a�n�d� �t�h�e� �r�e�a�d�/�w�r�i�t�e� �r�a�t�i�o�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�b�u�f�f�e�r�_�p�o�o�l�_�i�n�s�t�a�n�c�e�s� � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �m�e�m�o�r�y� �b�u�f�f�e�r� �p�o�o�l�s�.� �E�n�a�b�l�e� �m�u�l�t�i�p�l�e� �m�e�m�o�r�y� �b�u�f�f�e�r� �p�o�o�l�s� �t�o� �h�a�s�h� �d�a�t�a� �t�o� �b�e� �b�u�f�f�e�r�e�d� �t�o� �d�i�f�f�e�r�e�n�t� �b�u�f�f�e�r� �p�o�o�l�s�.� �I�n� �t�h�i�s� �w�a�y�,� �t�h�e� �m�e�m�o�r�y� �c�a�n� �b�e� �r�e�a�d� �a�n�d� �w�r�i�t�t�e�n� �c�o�n�c�u�r�r�e�n�t�l�y�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� �8� �t�o� �3�2� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�o�p�e�n�_�f�i�l�e�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �f�i�l�e�s� �t�h�a�t� �c�a�n� �b�e� �o�p�e�n�e�d� �b�y� �I�n�n�o�D�B� �i�n� �t�h�e� �i�n�n�o�d�b�_�f�i�l�e�_�p�e�r�_�t�a�b�l�e� �m�o�d�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �A� �l�a�r�g�e�r� �v�a�l�u�e� �i�s� �r�e�c�o�m�m�e�n�d�e�d�,� �e�s�p�e�c�i�a�l�l�y� �w�h�e�n� �t�h�e�r�e� �a�r�e� �a� �l�a�r�g�e� �n�u�m�b�e�r� �o�f� �t�a�b�l�e�s�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�b�u�f�f�e�r�_�p�o�o�l�_�s�i�z�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�i�z�e� �o�f� �t�h�e� �b�u�f�f�e�r� �t�h�a�t� �c�a�c�h�e�s� �d�a�t�a� �a�n�d� �i�n�d�e�x�e�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� �6�0�%� �o�f� �t�h�e� �m�e�m�o�r�y� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�l�o�g�_�b�u�f�f�e�r�_�s�i�z�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�i�z�e� �o�f� �t�h�e� �b�u�f�f�e�r� �t�h�a�t� �c�a�c�h�e�s� �r�e�d�o� �l�o�g�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �D�e�f�a�u�l�t� �v�a�l�u�e�:� �6�4� �M�B�.� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �b�a�s�e�d� �o�n� �t�h�e� �v�a�l�u�e� �o�f� ��i�n�n�o�d�b�_�l�o�g�_�w�a�i�t��.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�i�o�_�c�a�p�a�c�i�t�y� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �M�a�x�i�m�u�m� �I�O�P�S� �o�f� �I�n�n�o�D�B� �b�a�c�k�g�r�o�u�n�d� �t�h�r�e�a�d�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� �7�5�%� �o�f� �t�h�e� �t�o�t�a�l� �I�/�O� �Q�P�S� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�l�o�g�_�f�i�l�e�s�_�i�n�_�g�r�o�u�p� � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �N�u�m�b�e�r� �o�f� �r�e�d�o� �l�o�g� �g�r�o�u�p�s� � � � � � � � � � � � � � � � � � � � � � � � � � �|� �-� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�l�o�g�_�f�i�l�e�_�s�i�z�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�i�z�e� �o�f� �t�h�e� �r�e�d�o� �l�o�g� �f�i�l�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �A� �l�a�r�g�e�r� �v�a�l�u�e� �i�s� �r�e�c�o�m�m�e�n�d�e�d� �f�o�r� �w�r�i�t�e�-�i�n�t�e�n�s�i�v�e� �s�c�e�n�a�r�i�o�s�.� �H�o�w�e�v�e�r�,� �l�a�r�g�e� �s�i�z�e� �o�f� �t�h�e� �r�e�d�o� �l�o�g� �f�i�l�e� �p�r�o�l�o�n�g�s� �d�a�t�a� �r�e�s�t�o�r�a�t�i�o�n�.� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �t�h�e� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �i�n�c�r�e�a�s�e� �t�h�e� �l�o�g� �f�i�l�e� �s�i�z�e� �a�s� �l�a�r�g�e� �a�s� �p�o�s�s�i�b�l�e�.� �I�n� �c�o�m�m�e�r�c�i�a�l� �s�c�e�n�a�r�i�o�s�,� �c�o�n�s�i�d�e�r� �t�h�e� �d�a�t�a� �r�e�s�t�o�r�a�t�i�o�n� �t�i�m�e� �w�h�e�n� �s�e�t�t�i�n�g� �t�h�i�s� �p�a�r�a�m�e�t�e�r�.� �|� � �|� �i�n�n�o�d�b�_�f�l�u�s�h�_�m�e�t�h�o�d� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �M�e�t�h�o�d� �o�f� �f�l�u�s�h�i�n�g� �d�r�i�v�e�s� �f�o�r� �l�o�g�s� �a�n�d� �d�a�t�a�.� �T�h�e� �o�p�t�i�o�n�s� �i�n�c�l�u�d�e� �t�h�e� �f�o�l�l�o�w�i�n�g�:�<�/�b�r�>��d�a�t�a�s�y�n�c��:� �T�h�e� �d�a�t�a� �w�r�i�t�e� �o�p�e�r�a�t�i�o�n� �i�s� �c�o�n�s�i�d�e�r�e�d� �c�o�m�p�l�e�t�e� �w�h�e�n� �d�a�t�a� �i�s� �w�r�i�t�t�e�n� �t�o� �t�h�e� �b�u�f�f�e�r� �o�f� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m�.� �T�h�e�n�,� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m� �f�l�u�s�h�e�s� �t�h�e� �d�a�t�a� �f�r�o�m� �t�h�e� �b�u�f�f�e�r� �t�o� �d�r�i�v�e�s� �a�n�d� �u�p�d�a�t�e�s� �t�h�e� �m�e�t�a�d�a�t�a� �o�f� �f�i�l�e�s� �i�n� �d�r�i�v�e�s�.�<�/�b�r�>��O�_�D�S�Y�N�C��:� �L�o�g�s� �a�r�e� �w�r�i�t�t�e�n� �t�o� �d�r�i�v�e�s�,� �a�n�d� �d�a�t�a� �f�i�l�e�s� �a�r�e� �f�l�u�s�h�e�d� �t�h�r�o�u�g�h� �f�s�y�n�c�.�<�/�b�r�>��O�_�D�I�R�E�C�T��:� �D�a�t�a� �f�i�l�e�s� �a�r�e� �d�i�r�e�c�t�l�y� �w�r�i�t�t�e�n� �f�r�o�m� �t�h�e� �M�y�S�Q�L� �I�n�n�o�D�B� �b�u�f�f�e�r� �t�o� �d�r�i�v�e�s� �w�i�t�h�o�u�t� �b�e�i�n�g� �b�u�f�f�e�r�e�d� �i�n� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m�.� �T�h�e� �w�r�i�t�e� �o�p�e�r�a�t�i�o�n� �i�s� �c�o�m�p�l�e�t�e�d� �b�y� �t�h�e� �f�l�u�s�h� �o�p�e�r�a�t�i�o�n�.� �L�o�g�s� �a�r�e� �b�u�f�f�e�r�e�d� �b�y� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m�.� �|� � �|� �i�n�n�o�d�b�_�s�p�i�n�_�w�a�i�t�_�d�e�l�a�y� � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �P�o�l�l�i�n�g� �i�n�t�e�r�v�a�l� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� �a� �v�a�l�u�e� �a�s� �l�o�n�g� �a�s� �t�h�e�r�e� �i�s� �n�o� �s�p�i�n�_�l�o�c�k� �h�o�t�s�p�o�t� �f�u�n�c�t�i�o�n�.� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� ��1�8�0�� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�s�y�n�c�_�s�p�i�n�_�l�o�o�p�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �p�o�l�l�i�n�g� �t�i�m�e�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� �a� �v�a�l�u�e� �a�s� �l�o�n�g� �a�s� �t�h�e�r�e� �i�s� �n�o� �s�p�i�n�_�l�o�c�k� �h�o�t�s�p�o�t� �f�u�n�c�t�i�o�n�.� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� ��2�5�� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�s�p�i�n�_�w�a�i�t�_�p�a�u�s�e�_�m�u�l�t�i�p�l�i�e�r� � � � � � � � � � � � � � � � � � �|� � �|� �R�a�n�d�o�m� �n�u�m�b�e�r� �u�s�e�d� �t�o� �c�o�n�t�r�o�l� �t�h�e� �p�o�l�l�i�n�g� �i�n�t�e�r�v�a�l� �|� �S�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� �a� �v�a�l�u�e� �a�s� �l�o�n�g� �a�s� �t�h�e�r�e� �i�s� �n�o� �s�p�i�n�_�l�o�c�k� �h�o�t�s�p�o�t� �f�u�n�c�t�i�o�n�.� �D�e�f�a�u�l�t� �v�a�l�u�e�:� ��5�0��;� �r�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� ��2�5�� �t�o� ��5�0�� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�l�r�u�_�s�c�a�n�_�d�e�p�t�h� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �a�v�a�i�l�a�b�l�e� �p�a�g�e�s� �i�n� �t�h�e� �L�R�U� �l�i�s�t� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �D�e�f�a�u�l�t� �v�a�l�u�e�:� ��1�0�2�4��.� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �t�h�e� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �y�o�u� �c�a�n� �i�n�c�r�e�a�s�e� �t�h�e� �v�a�l�u�e� �t�o� �r�e�d�u�c�e� �t�h�e� �n�u�m�b�e�r� �o�f� �c�h�e�c�k�p�o�i�n�t�s�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�p�a�g�e�_�c�l�e�a�n�e�r�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �t�h�r�e�a�d�s� �f�o�r� �r�e�f�r�e�s�h�i�n�g� �d�i�r�t�y� �d�a�t�a� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�e�t� �i�t� �t�o� �t�h�e� �s�a�m�e� �v�a�l�u�e� �a�s� ��i�n�n�o�d�b�_�b�u�f�f�e�r�_�p�o�o�l�_�i�n�s�t�a�n�c�e�s��.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�p�u�r�g�e�_�t�h�r�e�a�d�s� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �t�h�r�e�a�d�s� �f�o�r� �p�u�r�g�i�n�g� �u�n�d�o� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �-� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�f�l�u�s�h�_�l�o�g�_�a�t�_�t�r�x�_�c�o�m�m�i�t� � � � � � � � � � � � � � � � � � � � � �|� ��0��:� �w�r�i�t�e�s� �b�i�n�l�o�g� �e�v�e�r�y� �s�e�c�o�n�d� �n�o� �m�a�t�t�e�r� �w�h�e�t�h�e�r� �t�r�a�n�s�a�c�t�i�o�n�s� �a�r�e� �s�u�b�m�i�t�t�e�d�.�<�/�b�r�>��1��:� �w�r�i�t�e�s� �t�h�e� �c�o�n�t�e�n�t� �i�n� �t�h�e� �l�o�g� �b�u�f�f�e�r� �t�o� �d�r�i�v�e�s� �e�a�c�h� �t�i�m�e� �a� �t�r�a�n�s�a�c�t�i�o�n� �i�s� �s�u�b�m�i�t�t�e�d�.� �T�h�e� �l�o�g� �f�i�l�e�s� �a�r�e� �u�p�d�a�t�e�d� �t�o� �d�r�i�v�e�s�.� �T�h�i�s� �m�o�d�e� �d�e�l�i�v�e�r�s� �t�h�e� �b�e�s�t� �s�e�c�u�r�i�t�y�.�<�/�b�r�>��2��:� �w�r�i�t�e�s� �d�a�t�a� �t�o� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m� �c�a�c�h�e� �e�a�c�h� �t�i�m�e� �a� �t�r�a�n�s�a�c�t�i�o�n� �i�s� �s�u�b�m�i�t�t�e�d�,� �a�n�d� �t�h�e� �o�p�e�r�a�t�i�n�g� �s�y�s�t�e�m� �u�p�d�a�t�e�s� �d�a�t�a� �t�o� �t�h�e� �d�r�i�v�e�s�.� �T�h�i�s� �m�o�d�e� �d�e�l�i�v�e�r�s� �t�h�e� �b�e�s�t� �p�e�r�f�o�r�m�a�n�c�e�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �a� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �s�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� ��0��.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �i�n�n�o�d�b�_�d�o�u�b�l�e�w�r�i�t�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�t�h�e�r� �t�o� �e�n�a�b�l�e� �t�h�e� �d�o�u�b�l�e� �w�r�i�t�e� �f�u�n�c�t�i�o�n� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �a� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �s�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� ��0�� �t�o� �d�i�s�a�b�l�e� �d�o�u�b�l�e� �w�r�i�t�e�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �s�s�l� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�t�h�e�r� �t�o� �e�n�a�b�l�e� �S�S�L� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �S�S�L� �h�a�s� �g�r�e�a�t� �i�m�p�a�c�t� �o�n� �p�e�r�f�o�r�m�a�n�c�e�.� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �a� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �s�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� �0� �t�o� �d�i�s�a�b�l�e� �S�S�L�.� �I�n� �c�o�m�m�e�r�c�i�a�l� �s�c�e�n�a�r�i�o�s�,� �s�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �b�a�s�e�d� �o�n� �c�u�s�t�o�m�e�r� �r�e�q�u�i�r�e�m�e�n�t�s�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �t�a�b�l�e�_�o�p�e�n�_�c�a�c�h�e�_�i�n�s�t�a�n�c�e�s� � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �p�a�r�t�i�t�i�o�n�s� �t�h�a�t� �c�a�c�h�e� �t�a�b�l�e� �h�a�n�d�l�e�s� �i�n� �M�y�S�Q�L� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� ��1�6�� �t�o� ��3�2�� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �t�a�b�l�e�_�o�p�e�n�_�c�a�c�h�e� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �N�u�m�b�e�r� �o�f� �t�a�b�l�e�s� �o�p�e�n�e�d� �b�y� �M�y�s�q�l�d� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �R�e�c�o�m�m�e�n�d�e�d� �v�a�l�u�e�:� ��3�0�0�0�0�� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �s�k�i�p�_�l�o�g�_�b�i�n� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�t�h�e�r� �t�o� �e�n�a�b�l�e� �b�i�n�l�o�g� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �a� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �a�d�d� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� �t�h�e� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e� �a�n�d� �d�i�s�a�b�l�e� �b�i�n�l�o�g� �(�a�d�d� �t�h�e� �f�o�l�l�o�w�i�n�g� �c�o�n�t�e�n�t� �t�o� �t�h�e� �c�o�n�f�i�g�u�r�a�t�i�o�n� �f�i�l�e�:�<�/�b�r�>�s�k�i�p�_�l�o�g�_�b�i�n�<�/�b�r�>�#�l�o�g�-�b�i�n�=�m�y�s�q�l�-�b�i�n�<�/�b�r�>�)�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � �|� �p�e�r�f�o�r�m�a�n�c�e�_�s�c�h�e�m�a� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�t�h�e�r� �t�o� �e�n�a�b�l�e� �t�h�e� �p�e�r�f�o�r�m�a�n�c�e� �s�c�h�e�m�a� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� �W�h�e�n� �t�e�s�t�i�n�g� �t�h�e� �u�l�t�i�m�a�t�e� �p�e�r�f�o�r�m�a�n�c�e� �i�n� �a� �n�o�n�-�p�r�o�d�u�c�t�i�o�n� �e�n�v�i�r�o�n�m�e�n�t�,� �s�e�t� �t�h�i�s� �p�a�r�a�m�e�t�e�r� �t�o� ��O�F�F�� �t�o� �d�i�s�a�b�l�e� �t�h�e� �p�e�r�f�o�r�m�a�n�c�e� �s�c�h�e�m�a�.� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �|� � � � �#�#�#� �D�a�t�a�b�a�s�e� �K�e�r�n�e�l� �T�u�n�i�n�g� � � � �#�#�#�#� �P�u�r�p�o�s�e� � � � �M�o�d�i�f�y� �t�h�e� �s�o�u�r�c�e� �c�o�d�e� �o�f� �t�h�e� �M�y�S�Q�L� �d�a�t�a�b�a�s�e� �t�o� �i�m�p�r�o�v�e� �t�h�e� �d�a�t�a�b�a�s�e� �p�e�r�f�o�r�m�a�n�c�e�.� �T�o� �u�s�e� �t�h�e� �d�a�t�a�b�a�s�e� �k�e�r�n�e�l� �o�p�t�i�m�i�z�a�t�i�o�n� �p�a�t�c�h�,� �y�o�u� �n�e�e�d� �t�o� �r�e�c�o�m�p�i�l�e� �t�h�e� �d�a�t�a�b�a�s�e�.� � � � �#�#�#�#� �M�e�t�h�o�d� � � � �M�y�S�Q�L� �d�a�t�a�b�a�s�e� �k�e�r�n�e�l� �t�u�n�i�n�g� �i�n�v�o�l�v�e�s� �t�w�o� �s�c�e�n�a�r�i�o�s�:� �o�n�l�i�n�e� �t�r�a�n�s�a�c�t�i�o�n� �p�r�o�c�e�s�s�i�n�g� �(�O�L�T�P�)� �a�n�d� �o�n�l�i�n�e� �a�n�a�l�y�t�i�c�a�l� �p�r�o�c�e�s�s�i�n�g� �(�O�L�A�P�)�.� �D�i�f�f�e�r�e�n�t� �o�p�t�i�m�i�z�a�t�i�o�n� �p�a�t�c�h�e�s� �a�r�e� �u�s�e�d� �i�n� �d�i�f�f�e�r�e�n�t� �s�c�e�n�a�r�i�o�s�.� � � � �O�L�T�P� �i�s� �a� �t�r�a�n�s�a�c�t�i�o�n�-�o�r�i�e�n�t�e�d� �p�r�o�c�e�s�s�i�n�g� �s�y�s�t�e�m�.� �I�t� �m�a�i�n�l�y� �p�r�o�c�e�s�s�e�s� �s�m�a�l�l� �t�r�a�n�s�a�c�t�i�o�n�s� �a�n�d� �q�u�e�r�i�e�s� �a�n�d� �r�e�s�p�o�n�d�s� �q�u�i�c�k�l�y� �t�o� �u�s�e�r� �o�p�e�r�a�t�i�o�n�s�.� �F�o�r� �d�e�t�a�i�l�s� �a�b�o�u�t� �t�h�e� �O�L�T�P� �k�e�r�n�e�l� �o�p�t�i�m�i�z�a�t�i�o�n� �p�a�t�c�h�,� �s�e�e� �[�M�y�S�Q�L� �F�i�n�e�-�G�r�a�i�n�e�d� �L�o�c�k� �T�u�n�i�n�g�]�(�h�t�t�p�s�:�/�/�w�w�w�.�h�i�k�u�n�p�e�n�g�.�c�o�m�/�d�o�c�u�m�e�n�t�/�d�e�t�a�i�l�/�e�n�/�k�u�n�p�e�n�g�d�b�s�/�f�g�/�k�u�n�p�e�n�g�p�a�t�c�h�_�2�0�_�0�0�0�1�.�h�t�m�l�)�.� � � � �O�L�A�P� �a�n�a�l�y�z�e�s� �a�n�d� �q�u�e�r�i�e�s� �c�u�r�r�e�n�t� �a�n�d� �h�i�s�t�o�r�i�c�a�l� �d�a�t�a� �a�n�d� �g�e�n�e�r�a�t�e�s� �r�e�p�o�r�t�s� �t�o� �s�u�p�p�o�r�t� �m�a�n�a�g�e�m�e�n�t� �a�n�d� �d�e�c�i�s�i�o�n�-�m�a�k�i�n�g�.� �F�o�r� �d�e�t�a�i�l�s� �a�b�o�u�t� �t�h�e� �O�L�A�P� �k�e�r�n�e�l� �o�p�t�i�m�i�z�a�t�i�o�n� �p�a�t�c�h�,� �s�e�e� �[�M�y�S�Q�L� �O�L�A�P� �P�a�r�a�l�l�e�l� �O�p�t�i�m�i�z�a�t�i�o�n�]�(�h�t�t�p�s�:�/�/�w�w�w�.�h�i�k�u�n�p�e�n�g�.�c�o�m�/�d�o�c�u�m�e�n�t�/�d�e�t�a�i�l�/�e�n�/�k�u�n�p�e�n�g�d�b�s�/�f�g�/�k�u�n�p�e�n�g�o�l�a�p�_�2�0�_�0�0�0�2�.�h�t�m�l�)�.� � �

      Bug Catching

      Buggy Content

      Bug Description

      Submit As Issue

      It's a little complicated....

      I'd like to ask someone.

      PR

      Just a small problem.

      I can fix it online!

      Bug Type
      Specifications and Common Mistakes

      ● Misspellings or punctuation mistakes;

      ● Incorrect links, empty cells, or wrong formats;

      ● Chinese characters in English context;

      ● Minor inconsistencies between the UI and descriptions;

      ● Low writing fluency that does not affect understanding;

      ● Incorrect version numbers, including software package names and version numbers on the UI.

      Usability

      ● Incorrect or missing key steps;

      ● Missing prerequisites or precautions;

      ● Ambiguous figures, tables, or texts;

      ● Unclear logic, such as missing classifications, items, and steps.

      Correctness

      ● Technical principles, function descriptions, or specifications inconsistent with those of the software;

      ● Incorrect schematic or architecture diagrams;

      ● Incorrect commands or command parameters;

      ● Incorrect code;

      ● Commands inconsistent with the functions;

      ● Wrong screenshots.

      Risk Warnings

      ● Lack of risk warnings for operations that may damage the system or important data.

      Content Compliance

      ● Contents that may violate applicable laws and regulations or geo-cultural context-sensitive words and expressions;

      ● Copyright infringement.

      How satisfied are you with this document

      Not satisfied at all
      Very satisfied
      Submit
      Click to create an issue. An issue template will be automatically generated based on your feedback.
      Bug Catching
      编组 3备份