<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>How and where do we tune mysql it does not seem to wrok from the
gui of the VPS now.</p>
<p>General recommendations:<br>
Control warning line(s) into /var/lib/mysql/blackbass.err file<br>
Control error line(s) into /var/lib/mysql/blackbass.err file<br>
Configure your accounts with ip or subnets only, then update
your configuration with skip-name-resolve=1<br>
Adjust your join queries to always utilize indexes<br>
When making adjustments, make
tmp_table_size/max_heap_table_size equal<br>
Reduce your SELECT DISTINCT queries which have no LIMIT clause<br>
Increase table_open_cache gradually to avoid file descriptor
limits<br>
Read this before increasing table_open_cache over 64:
<a class="moz-txt-link-freetext" href="http://bit.ly/1mi7c4C">http://bit.ly/1mi7c4C</a><br>
Read this before increasing for MariaDB
<a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/optimizing-table_open_cache/">https://mariadb.com/kb/en/library/optimizing-table_open_cache/</a><br>
This is MyISAM only table_cache scalability problem, InnoDB
not affected.<br>
See more details here: <a class="moz-txt-link-freetext" href="https://bugs.mysql.com/bug.php?id=49177">https://bugs.mysql.com/bug.php?id=49177</a><br>
This bug already fixed in MySQL 5.7.9 and newer MySQL
versions.<br>
Beware that open_files_limit (4162) variable <br>
should be greater than table_open_cache (2000)<br>
Performance schema should be activated for better diagnostics<br>
Consider installing Sys schema from
<a class="moz-txt-link-freetext" href="https://github.com/mysql/mysql-sys">https://github.com/mysql/mysql-sys</a> for MySQL<br>
Consider installing Sys schema from
<a class="moz-txt-link-freetext" href="https://github.com/good-dba/mariadb-sys">https://github.com/good-dba/mariadb-sys</a> for MariaDB<br>
Before changing innodb_log_file_size and/or
innodb_log_files_in_group read this: <a class="moz-txt-link-freetext" href="https://bit.ly/2TcGgtU">https://bit.ly/2TcGgtU</a><br>
Variables to adjust:<br>
query_cache_size (=0)<br>
query_cache_type (=0)<br>
query_cache_limit (> 1M, or use smaller result sets)<br>
join_buffer_size (> 256.0K, or always use indexes with
JOINs)<br>
tmp_table_size (> 16M)<br>
max_heap_table_size (> 16M)<br>
table_open_cache (> 2000)<br>
performance_schema = ON enable PFS<br>
innodb_buffer_pool_size (>= 794.4M) if possible.<br>
innodb_log_file_size should be (=16M) if possible, so InnoDB
total log files size equals to 25% of buffer pool size.<br>
</p>
<div class="moz-signature">-- <br>
<style type="text/css">
<!--
.style1 {color: #006600}
-->
</style>
<p><em><strong>Richard C. Barker Sr. <br>
CEO & President <br>
1-813-873-8942 <br>
<span class="style1">ProBass Networks Inc. </span></strong></em><br>
<a href="http://www.probassnetworks.net">www.probassnetworks.net</a>
<br>
<a href="http://www.probass.net">www.probass.net</a> <br>
*************************************** <br>
DISCLAIMER : - <br>
This e-mail is confidential and intended only for the use <br>
of the individual or entity named above and may contain <br>
information that is privileged. If you are not the intended <br>
recipient, you are notified that any dissemination, distribution
<br>
or copying of this e-mail is strictly prohibited. If you have <br>
received this email in error, please notify us immediately <br>
by return email or telephone and destroy the original message. <br>
</p>
</div>
</body>
</html>