Viewing 11 to 16 of 16 items
Tag Archives: mysql

Enable Innodb in cPanel server

To Enable innodb in cpanel server♦ First check if Innodb is enabled or not. # mysqladmin variables | grep have_innodb ( To check Innodb enabled or not ) | have_innodb | No OR mysql> show engines; ♦ Edit the configuration file # vi /etc/my.cnf #skip-inndob ( comment the line to activate Innodb) ♦ Restart Mysql # /etc/init.d/mysql restart Set  Full Article…

0

MySQL optimization

  MySQL OPTIMIZATION MySQL is a popular choice of database for use in web applications. Fully optimizing MySQL takes both time and effort since every application has different requirements. The MySQL database server performance depends on the number of factors. The Optimized Query is one of the factors for the MySQL robust performance. The MySQL  Full Article…

0

Disable port 3306 listening to server

  Here goes the steps for disabling inbound MySQL connections to a linux server. ♦ Login to the server as root ♦ open the file /etc/my.cnf ♦ add the directive skip-networking ♦ save and quit from the file. Now you may need to disable the port 3306 in TCP_IN section in firewall(if firewall enabled). Make  Full Article…

0

MySQL doesnt start

  In some cases MySQL will not get restarted even if we run the init script to start/restart it. The issue is due to the basedir variable in /etc/my.cnf file. Inorder to fix this you may need to comment out or remove the basedir directive line from /etc/my.cnf file. [mysql.server ] server=mysql #basedir=/var/lib Now restart  Full Article…

0

How to setup MySQL temp directory on RAM disk?

Follow the below mentioned steps to setup MySQL temp directory on a RAM disk. Create a tmpfs directory : mkdir /var/tmpfs Now change the ownership of the newly created directory. chown mysql:mysql /var/tmpfs id mysql Make sure to get the uid and gid for mysql vi /etc/fstab tmpfs /var/tmpfs tmpfs rw,uid=498,gid=499,size=500M,nr_inodes=10k,mode=0700 0 0 Save and  Full Article…

0