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…
Backup SQL files with CustomBuild 2.0
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…
An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘X’ for key ‘PRIMARY’
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…
How to optimize PHP performance on Windows
In order to optimize PHP performance on Windows Server, the following steps can be performed:
Cannot start PHP FPM service: cannot get uid for user
Cannot start PHP FPM service: systemctl status php5-fpm.service...ERROR: 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 Manager.Unit php5-fpm.service…
Error connecting to MySQL: Access denied for user: ‘da_admin@localhost’ (Using password: YES)
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…