Archive for the tag 'size'

SBDavid
Aug 10th, 2010

How to fix MySQL DB size shows 0 Mb in cPanel

Sometimes we may see the mysql database size as zero in cPanel

This can be fixed as follows: SSH to the server as root and edit the cpanel.config file

vi /var/cpanel/cpanel.config

search for

disk_usage_include_sqldbs=0

and then make change to

disk_usage_include_sqldbs=1

If the parameter is not present, add it. Save the file and execute the following command:

/scripts/update_db_cache

This may take few minutes to get fixed if you have a large number of users with databases, but once done, we should be able see the database disk usage show up accurately in cPanel.

SBDavid
Dec 24th, 2009

Increasing PHP Allowed memory size

Some times we get the following errors Fatal error: Allowed memory size of 123456 bytes exhausted

Php is setup is to limit memory usage per process. If we require more, this limit can be increased.

Edit

/usr/local/lib/php.ini

and set:

memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)

to a higher value, like 20M. Save, exit, then restart apache.

Source: http://directadmin.com/