There is a nice tool like Percona’s ‘pt-query-digest’ tool at http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html, which will automatically parse the slow_query_log and analyze it for the slowest queries. you run the command Wich should output a summary and a list of the longest-to-execute queries.
Usage: With files: With folders:
Running a script on WHM server Add curl SSL support in WHM or curl
Once you have entered the values correctly, press Ctrl+Enter to save it with the current filename, then press Ctrl+X to exit the editor. Provided you entered your values correctly, verify the new settings by retyping the cat command: Apply setting to Interface After you have determined the values entered are correct, restart networking with the … Read more
Create an index to a mysql table. Say there is a product_id column: Add to existing table
Checking the log shows: Check the processlist on a plesk server: Kill the process: Create an index on the table
Error in plesk postfix email logs: Notice: Error: EHLO not accepted from server! in /var/www/vhosts/domain.com/httpdocs/system/library/mail.php on line 237 Check postfix main and comment out non_smtpd_milters: Restart postfix:
More info: http://www.cisco.com/c/en/us/support/docs/security-vpn/kerberos/13634-newsflash.html
BUSY: Update operation was locked by another update process. Having trouble updating Plesk? Check for the installer: Kill the process There’s a psa-installer.lock file in /tmp/ which indicates Plesk a running installer. Be sure no installer is running and then delete this little bugger.
CSF Firewall is blocking these attacks in /var/log/messages Check with You have set the following in your csf configuration but having such a setting, we definitely block SYN connections but legit connections as well. With the above settings, you will see a drop down in SYN connections but you won’t be able to browse your … Read more