Viewing 1 to 3 of 3 items
Tag Archives: database

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…


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…