How to Optimize MySQL
IMPORTANT CentOS There is a default my.cnf that comes with mysql (4+5) that will make mysql run a bit quicker if you have 2+ gig of ram cp -f /usr/share/mysql/my-large.cnf…
IMPORTANT CentOS There is a default my.cnf that comes with mysql (4+5) that will make mysql run a bit quicker if you have 2+ gig of ram cp -f /usr/share/mysql/my-large.cnf…
Before any changes, or for regular intervals, you might want to make backups of your database, which are not specific to the normal DirectAdmin User backup system. This guide will…
Symptoms Cause The AUTO_INCREMENT value for the table is lower than the real maximum PRIMARY KEY value. This issue could be caused when InnoDB and XtraDB use an auto-increment counter…
In order to optimize PHP performance on Windows Server, the following steps can be performed:
Cannot start PHP FPM service: systemctl status php5-fpm.service...ERROR: [pool example.com] cannot get uid for user 'john.doe'ERROR: FPM initialization failedphp5-fpm.service: main process exited, code=exited, status=78/n/aFailed to start The PHP FastCGI Process…
When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the “da_admin” user has not been setup correctly. To resolve this do the following.Desired…
General information for default certificate locations for various services.The order will be cert,key, ca/chain, combined (cert+ca)and their related directadmin.conf settings, where applicable. Apache/LiteSpeed apachecert=/etc/httpd/conf/ssl.crt/server.crtapachekey=/etc/httpd/conf/ssl.key/server.keyapacheca=/etc/httpd/conf/ssl.crt/server.ca OpenLiteSpeed openlitespeed_cert=/usr/local/lsws/ssl.crt/server.crtopenlitespeed_key=/usr/local/lsws/ssl.key/server.keyopenlitespeed_ca=/usr/local/lsws/ssl.crt/server.ca Nginx nginx_cert=/etc/nginx/ssl.crt/server.crtnginx_key=/etc/nginx/ssl.key/server.keynginx_ca=/etc/nginx/ssl.crt/server.ca/etc/nginx/ssl.crt/server.crt.combined Exim +…
Download the latest Java SE SDK version Go to the following link and download jdk7. At the time of writing this guide, the jdk version was jdk-7u45-linux-x64. Note that I’m…
Mozilla announced their ‘mozjpeg’ project with the aim of improving lossless jpeg compression and making the web a faster place. Forked from libjpeg-turbo, mozjpeg is more concerned with reducing filesize…
To revoke the certificate, please run the following (if the cert is still in-place): cd /usr/local/directadmin/scripts./letsencrypt.sh revoke `hostname -f` To stop the auto-renewal: rm -f /usr/local/directadmin/conf/cacert.pem.creation_time