Category: MySQL
-
Reduce Mysql Service Memory Usage On A Centos Server
I tried below settings to bring down Mysqld service memory usage from 450 MB to less than 300 MB on a very low performance hosting server on cloud. Code to b added in /etc/my.conf is below: [mysqld] table_definition_cache = 400 More research will be needed for me to know what exactly was optimized by this…
-
MySQL Newbie 002: PhpMyAdmin Error: “Wrong permissions on configuration file, should not be world writable”
The titled error message is referring to wrong permissions of configuration file “config.inc.php” and a simple chmod command will suffice: shell> chmod 0755 config.inc.php In case you wonder where to find this config.inc.php file, it is located in the same folder where PhpMyAdmin is installed. And for a more detailed solution on both Linux and Windows systems, please click here.
-
MySQL Newbie 001: How to Check if MySQL Service is Running on CentOS
As I am new comer in the MySQL domain, I am going to write up a few trivial posts about administrating MySQL. Today this is the first one: The BASH command you are looking for to achieve the MySQL service status on CentOS system is: shell> /etc/init.d/mysql status And to connect to localhost’s MySQL service: shell>…