January 17, 2014 0 Comments

I did some research about MySQL’s query cache. Some people said it will speed up page load times by 5-15%. Query cache is used to cache SELECT results and later return them without

January 16, 2014 0 Comments

beresp.ttl set beresp.ttl = 1d; cache the file 1 day req.grace set req.grace = 6h; after 1 day, if Apache Goes Down, still cache another 6 hours

January 16, 2014 0 Comments

Try to execute show processlist;, maybe there are some long lasting threads that were not killed for some reason. Similarly execute SHOW SESSION STATUS LIKE 'Created%'; to check if mysql hasn't created to

January 2, 2014 0 Comments

This is a short article that explains how you change the default MySQL data directory and adjust SELinux to account for the changes. The article assumes that you’re running either RHEL, CentOS, Scientific

December 18, 2013 0 Comments

Do not do this, since it might screw up encoding: mysqldump -uroot -p database > utf8.dump # this is bad Better do: mysqldump -uroot -p database -r utf8.dump Note that when your MySQL

November 14, 2013 0 Comments

sudo cp -rp folder1 folder2 help -p same as --preserve=mode,ownership,timestamps --preserve[=ATTR_LIST] preserve the specified attributes (default: mode,ownership,timestamps), if possible additional attributes: context, links, xattr, all

November 14, 2013 0 Comments

This class is very useful for small projects, it easy and fast to connect mysql with php script. Thank you Ciprian Mocanu to provide this document. The Class:

November 13, 2013 0 Comments

Basic Version In our basic version, we will have a single div containing a loading spinner and once our large image is loaded (in the background) we will remove the spinner and insert

November 5, 2013 4 Comments

Step 1: Enabling Google’s mod_pagespeed Repository Create a file called /etc/yum.repos.d/mod-pagespeed.repo with the help of your favourite editor and add the following lines of code to it based on your OS bit. RHEL/CentOS/Fedora

November 4, 2013 2 Comments

Here is link http://owlgraphic.com/owlcarousel/ Touch enabled jQuery plugin that lets you create beautiful responsive carousel slider. 1. Load jQuery and include Owl Carousel plugin files To use Owl Carousel, you’ll need to make