Databases

Riz Khan on February 27th, 2011

MySQL database server has tbe capability to use different database storage engines. The database storage engine is what actually do the work of storing and retrieving data from the underlying database tables. The storage engines work like a modular code which can be plugged into MySQL. Among the stroage enginers MyISAM is the one, used […]

Continue reading about How to check if innodb is enabled in Mysql server

If you are facing a problem where databases in the Cpanel account are showing 0Mb disk usage, then usually its caused by the related Cpanel configuration being set to 0 (zero). You can check this by finding the value of parameter ‘disk_usage_include_sqldbs‘ in the cpanel.config file using below : root@CpanelServer [~]# grep disk_usage_include_sqldbs /var/cpanel/cpanel.config disk_usage_include_sqldbs=0 […]

Continue reading about Error : ” Mysql databases showing 0MB disk usage in cPanel ” Resolution

In many situations your resource usage may increase our the time and in this situation one simple way is to upgrade to a bigger and more powerful server. The other possible way is to setup a separate MySQL server just for databases and keep a main server running as Web and Mail server. CPanel has […]

Continue reading about How To : Setup remote and separate MySQL server for cPanel servers