Database Manager

Managing your databases is easier than before, due to the Web Site Control Panel user interface for MySQL and PgSQL control! Assuming you do not have extensive knowledge of managing databases, you will find it simple to manage our Database Manager.

You can create a new database by only typing the username and security password or make a database back–up with merely a mouse click. In addition, via the Data Manager you will possess direct access to the administration area for each individual database, so you can easily modify it.

We have developed the manual database back–up formation into a very easy activity. To execute that: inside of the Database Manager, click the ’clock’ icon next to the database that you intend to back up and afterwards wait around for a couple of seconds for the process to take place. Depending on the size of the database, the building of a backup file will need somewhere between a few seconds and a minute.

You can create as many backups of a database as you want. We haven’t set any restrictions on the volume of databases you can back up too.

PgSQL databases are less sought after when compared to the standard MySQL databases. Then again, they are a preferred choice for programmers who are looking for the finest safety for their web sites and applications. Thanks to the user–friendly Database Manager incorporated into the Profyt Solutions Control Panel, you can control all your PostgreSQL databases with a simple click of the mouse.

You can find PgSQL databases included by default inside the advanced shared plans packages. Provided that you are with a standard hosting package, you can ask for PgSQL databases to be added in your account as upgrades.

We have set up InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is ideal for sizeable database websites that demand high general performance and scalability. Experiments have revealed that sites employing InnoDB based tables attain a 3–fold functionality grow for big joins, compared with those employing MyISAM tables.

InnoDB utilizes row–level locking so as to take away the overall performance difficulties noticed at the high usage times of the earlier version of the database engine – MyISAM, which uses table–level locking.

Checking the load generated by the databases in your busy site makes it possible to reduce all sorts of overload difficulties that might slow it down and chase away site visitors. For this reason, we’ve built–in a in depth Database Stats tool into your Web Site Control Panel. There you can get all–encompassing information about the arriving requests to your databases for every single hour, day and month.

Using the amount of daily and hourly queries, you will be able to determine which databases are being used the most as well as consider steps to optimize their work.