#� �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� �
Long-Term Supported Versions
Innovation Versions