Mysql

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

MySQL is one of most known and popular open source database engine. It helps application owners to run their applications or sites on a reliable platform in a cost affective way. I have been thinking from some time to do some write up on Mysql Optimization as I have found that many people keep running […]

Continue reading about Mysql Optimization to improve server performance and reduce server load

Riz Khan on November 28th, 2010

When its comes to optimizing and tuning Mysql the most important aspect is to identify the inefficient/slow queries. So the question arises how we can find the queries which are taking long time to execute so we can optimize/improve them to improve the overall performance. Mysql helps us with its built in support for logging […]

Continue reading about How To : Enable slow query log in mysql

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