<link>https://forum.thirtybees.com/blogs/blog/8-factors-corner/</link><description><![CDATA[ <p> Since they say this is the place to put tips and tricks.  I will add my guides here from now on.  Among other ramblings. </p> <p> Brent aka Factor </p> ]]></description><language>en</language><item><title>Database tuning Tid Bithttps://forum.thirtybees.com/blogs/entry/41-database-tuning-tid-bit/ All:

I wanted you all to have this its just a tid bit of a Guide I am working on for MariaDB and or Mysql.  I wanted to tell you about a cool tuning script called tuning-primer.sh.  Should work on CentOS 7 if you have other disto may need to install bc with other package manager. 

#requires bc to be installed
yum install bc -y
#install and correct permissions	
cd /usr/bin
wget https://raw.githubusercontent.com/mattiabasone/tuning-primer/master/tuning-primer.sh -O tuning-primer.sh
chmod +x tuning-primer.sh
#make a backup of your current config
cp /etc/my.cnf /etc/my.cnf.bak
#run script for output on centos backend
sh tuning-primer.sh

Begaining output looks like this:

# sh tuning-primer.sh

    -- MYSQL PERFORMANCE TUNING PRIMER --
         - By: Matthew Montgomery -

MySQL Version 10.4.6-MariaDB x86_64

Uptime = 0 days 13 hrs 59 min 21 sec
Avg. qps = 0
Total Questions = 44479
Threads Connected = 1

Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations

 

Once you have it installed and run it will tell you areas to improve in the config file (my.cnf).  Also your Mysql server needs to be up for at least 2 days between changes.  

PS I didn't write this script.

Hope this helps.

]]>41Thu, 27 Jun 2019 15:55:08 +0000Panel's you use and like?https://forum.thirtybees.com/blogs/entry/40-panels-you-use-and-like/ All:

Since we have so many countries represented here.  Tell us why you use the panel you use.  

]]>40Thu, 27 Jun 2019 14:38:39 +0000Factor's Cornerhttps://forum.thirtybees.com/blogs/entry/37-factors-corner/ Hey All:

I wanted to introduce myself..  Couldn't find a "Hello I am" post.  Since most folks here have a Pen or Ghost name you all can call me Factor or Brent.  I have been in the IT world for almost 30 years.  Mostly on the Application side in the the Healthcare IT world.  I was also a emergency room nurse hence the healthcare IT.  I have mostly done SysAdmin or Architect type jobs.  I am not what most would call a programmer or a coder.  I understand networking, posix systems, windows, mac, oracle, and infrastructure.  I am from USA Murfreesboro, Tennessee.  My hobbies include 19th century culture, photography, gunsmithing and anything tech related.  I also love language.  I have studied Mandarin, Thai, Lao, Greek and Arabic only spoken.  Also only enough to get in trouble.  I am Greek by heritage so I am told.  I got into Thirty Bee's because my wife sells quilt fabric. Apparently I am the CIO of the business. :classic_blink: Seems to be a easy to understand and well coded system.  Any way I hope wherever you are you are doing well.  Stay safe.  

]]>37Thu, 20 Jun 2019 15:18:41 +0000Tips and Tricks - General guide to email and blocklisthttps://forum.thirtybees.com/blogs/entry/39-tips-and-tricks-general-guide-to-email-and-blocklist/ All:

I wanted to put this here for others.  It's a good general guide to email and blocklists.  If you are using saas, cloud, or managed hosting you shouldn't need this guide. If you have your own server unmanaged using cpanel, plesk or others you might find it useful.

As always it's a living document.  Feel free to correct or add to it. Hope it helps.

Blacklist Email Guide.docx

]]>39Thu, 20 Jun 2019 01:33:41 +0000Tips and Tricks - Prestools installhttps://forum.thirtybees.com/blogs/entry/38-tips-and-tricks-prestools-install/ All:

I wanted to put this here for those they might be a bit more "Visual" like me.  I am not affiliated with, own or maintain Prestools. That is @musicmaster  I have spoken to him and he has allowed me to post the guide.

I hope you all find it useful.  If you find error or issue please feel free to correct or update the document.  It is only how to Install not use the software.

 

Prestools install guide.docx

]]>38Thu, 20 Jun 2019 01:31:58 +0000