Database Manager

Taking control of your databases is simpler than ever, because of the Online Control Panel user interface for MySQL and PgSQL control! Even though you may not have extensive knowledge in handling databases, you will find it an easy task to work with our Database Manager.

You can create a brand new database by simply typing the username and security password or produce a database backup with only a click of the mouse. Furthermore, via the Data Manager you’ll get direct access to the management area for every single database, so you’re able to quickly edit it.

We’ve designed the manual database back–up creation into a very easy task. To do so: inside of the Database Manager, click the ’clock’ image next to the database that you plan to back up and afterwards wait around for a few seconds for the process to take place. Depending upon the size of the database, the generation of a back–up file will take somewhere between a couple of seconds and a minute.

You may make as many backups per database as you would like. We’ve not fixed any limits for the quantity of databases that you can back up as well.

Just about all of the hosting bundles present PgSQL support. While dropping behind MySQL with regard to global recognition and utilization, PgSQL databases are famous for offering up the maximum level of protection for your website content and articles. That’s the primary reason why brands like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.

In relation to database management, PgSQL is as straightforward as MySQL.

The MySQL databases on MnMwebs’s web servers employ the most current release of the InnoDB storage engine. InnoDB was developed to ensure the max efficiency for sites that operate with substantial volumes of data. It provides CPU effectiveness that can not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, meaning that you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Additionally, it uses row–level locking in lieu of MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Our company offers you a pretty simple route to observe the database usage of your busy sites. From the descriptive database statistics interface, which is included in the Online Control Panel, you can easily observe the load accumulated from your active sites in real time. The supplied info will help you to assess the database load changes every hour, each day or per month.

You can monitor the database load for your web sites in the Database Stats section of the Online Control Panel. The table onscreen features the database lookups generated during the present month. To check information and facts for a past month, click on the back arrows situated at the top.