Slow MariaDB SQL queries in Statistics state

Overview One of the jobs of a database when executing a query is to map out the best way to execute the query itself. While in most instances MariaDB (and MySQL) does a great job of optimisation, for...
  • 0
  • 256

How to determine what database format your site is using

Overview MariaDB / MySQL use two different database formats, InnoDB and MyISAM. To found out more about the differences, we recommend our article comparing InnoDB and MyISAM. If you want to find out what format your website is...
  • 0
  • 545

What’s the difference between InnoDB and MyISAM?

Overview MySQL and MariaDB have two main formats to store databases in, MyISAM and InnoDB. MyISAM is the older and more basic format, which has a number of limitations compared to the newer and more feature complete InnoDB...
  • 0
  • 565

Simple web site redirection via .htaccess

Overview During the life of a web site it may undergo a name change and rather than have visitors hit the old web site you may wish to have them automatically redirected to a new web address. To...
  • 0
  • 744

Providing Single Subscription access in Plesk

Overview At times you may need to provide your clients with direct access to their Plesk subscriptions so they're able to self manage some aspects of their hosting This article takes you through providing a clients access to their...
  • 0
  • 744

Cleaning up Magento Logs

Overview The Magento eCommerce Shopping cart contains a logging facility to record visitor interactions with your store. However most store owners use Google Analytics to get metrics on the performance of their store so the inbuilt logging is...
  • 0
  • 745

How to copy a MySQL database

Overview Copying your existing MySQL database is quite a simple task, in fact you can do it in a single command! There are plenty of times when you want to take a copy of an existing database so...
  • 0
  • 747

How to Create a New Client and Subscription in Plesk Onyx

Overview The following support article demonstrates how to create a new client and a hosting subscription in Plesk. While you can create a client and then later add a subscription, this method demonstrates how to perform both tasks...
  • 1
  • 754

Certificate Transparency Support

Overview Certificate Transparency is an extension of the current SSL issuance and monitoring system to provide publicly auditable logs from Certificate Authorities (CA's) so that the detection of mistakenly issued or maliciously acquired occurrences can be easily detected....
  • 0
  • 795

Linux Memory Usage

Overview While initial views of the Linux memory statistics may suggest the system has run out of memory, the reality is that Linux uses any free RAM available as a disk cache and buffering for network services. By...
  • 0
  • 795

Reducing Disk IO to Increase Performance

Overview In most hosting environments, your entire virtual instance is mounted on a single drive of maybe 10-20GB in size. In self hosted or VPS solutions additional disks are often available and are usually mounted with default parameters....
  • 0
  • 888

MySQL: Basic Command Quick Reference

MySQL Quick Reference Here’s a few of the basic commands to get you started with MySQL from the Linux shell. This article is intended to be a quick reference “cheat sheet” more than an explanation of each command....
  • 0
  • 935

Conetix Firewall Frequently Asked Questions

Overview Conetix uses a multi-layered approach to security to ensure your data is safe. This includes advanced firewalls, server lockdown and security restrictions and for Plesk based systems a number of new security features. We run a clustered,...
  • 0
  • 1025

How Can I disable KernelCare automatic updates?

Overview You may have a requirement to disable KernelCare Automatic updates, the following describes how you do it. Instructions Edit file /etc/sysconfig/kcare/kcare.conf  Set AUTO_UPDATE=False   If you require assistance please contact Conetix support on 1300 789 260 or email...
  • 1
  • 1027

Plesk Onyx: How to install Plesk Repair Kit Extension

Overview Plesk have developed an extension to aid in the management of your Plesk based Virtual Private Server (VPS). While many of the features are available in the Command Line Interface (CLI) version, this extension allows you to...
  • -1
  • 1039

Improve MySQL Database caching

Overview In most Linux systems, the MySQL database instance installed by default is often configured to a safe range of parameters to ensure stable operation. The query caching settings are typically not enabled or set very conservatively. As...
  • 0
  • 1064

Blocking access via a .htaccess file

Overview If you want to block access to a directory on your website or to all of your website, you can do this via a simple Apache .htacess file. This file allows you to override some of the...
  • -1
  • 1098

Plesk MySQL Import fails: the SUPER privileges required

Overview If you encounter “Access denied; you need (at least one of) the SUPER privilege(s) for this operation” during a MySQL import, this could be due to the SQL dump containing DEFINER in the create statement. For example:...
  • -1
  • 1129

How to copy MySQL tables between databases

Overview When you are working on a Development system it is often desirable to have a copy of a Production system database table. mySQL provides a handy method of making a copy of a single table and an...
  • 0
  • 1130

Plesk Onyx VPS: Login to your Plesk Server

Overview This article will detail the process of logging into Plesk directly via your Virtual Private Server (VPS). Instructions Open a New Tab or Web Browser and enter the Plesk URL as provided by Conetix. If you don’t have...
  • 0
  • 1135

301 Redirect using NGINX

Overview A 301 redirect is a way to move traffic to a new site without taking a hit to your SEO rankings. The 301 redirect and is the most popular kind of redirect and nearly always the best...
  • 0
  • 1175

MySQL – Performance Tuning and Optimisation

Overview MySQL is a highly versatile and high performing relational database management system making, used by many web based packages such as WordPress, Joomla and Magento. While the default configuration offers reasonable performance, there’s always ways to ensure...
  • 0
  • 1261

How to Enable for Fail2Ban for Plesk 12

Overview Note: An updated version of this article to suit Plesk Onyx is available here: Plesk Onyx – Enable Fail2Ban. This article will show you how to enable Fail2Ban within your Parallels Plesk 12 based Virtual Private Server (VPS). This was...
  • 0
  • 1357

How to Stop a Process within MySQL

Overview If you have a long running query which is incorrect or taking too long to complete, you can stop the individual query without affecting other databases.  Don’t forcibly kill MySQL the MySQL process directly. Doing so will most...
  • 0
  • 1687

MySQL – Converting to Per Table Data for InnoDB

Overview The InnoDB data format is a data storage engine, which provides greater data reliability and performance enhancements over the older MyISAM format. As of MySQL 5.5, InnoDB is also now the default data storage engine. By default,...
  • 1
  • 1689

Increase Fast-CGI timeout for Plesk

Overview For a Plesk 11.5 installation, the default timeout for FastCGI scripts is 45 seconds. This is too low for systems which run have update processes (eg WordPress or Joomla), or if you are running intensive scripting. Instructions To...
  • 1
  • 1693

Install PHP Mcrypt on CentOS 6 VPS

Overview The PHP module "Mcrypt" provides encryption and decryption using algorithms such as DES, TripleDES and Blowfish. You can read more about it on the official PHP Mcrypt page. This is required by eCommerce systems such as Magento, however it's not part of the...
  • 0
  • 1744

Tuning Apache Web Server Keepalive

Overview The default configuration for the Apache Web Server provides a set of safe options to enable Apache to perform well in a lightly loaded environment. One key parameter is “Keepalive” which is normally off.  For a content...
  • 0
  • 1843

Scripted MySQL Database Backups

Overview This article outlines a MySQL database backup script that allows you to implement an automated daily (or more frequent) date stamped and compressed backup of your MySQL databases. The advantage of using this script is that it will...
  • 8
  • 4487
  • 2

Simple PHP Mail test

Overview This is a handy little script to help test your hosting to ensure you can send emails from PHP based sites which include a contact form or similar. This includes CMS systems such as WordPress and Joomla as...
  • 10
  • 8231