Enable the query cache in MySQL to improve performance

If you want to get optimized and speedy response from your MySQL server then you need to add following two configurations directive to your MySQL server:

query_cache_size=SIZE
The amount of memory (SIZE) allocated for caching query results. The default value is 0, which disables the query cache.

query_cache_type=OPTION
Set the query cache type. Possible options are as follows:
0 : Don’t cache results in or retrieve results from the query cache.
1 : Cache all query results except for those that begin with SELECT S_NO_CACHE.
2 : Cache results only for queries that begin with SELECT SQL_CACHE

Howto enable caching in MySQL

You can setup caching as follows:
$ mysql -u root –p
Output:

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Now setup cache size 16Mb:

mysql> SET GLOBAL query_cache_size = 16777216;

Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'query_cache_size';

Output:

 +------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| query_cache_size | 16777216 |
+------------------+----------+

You can setup them in /etc/my.cnf (Red Hat) or /etc/mysql/my.cnf (Debian) file:
# vi /etc/my.cnf
Append config directives as follows:

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

In above example the maximum size of individual query results that can be cached set to 1048576 using query_cache_limit system variable. Memory size in Kb.


How to Export Local Group Policy Settings Made In gpedit.msc.

To export group policy you made in on a machine with the Local Group Policy Editor (gpedit.msc) to other machines follow following steps.

1.) Open %systemroot%\system32\grouppolicy\

Within this folder, there are two folders – “machine” and “user”. Copy these to folders to the “%systemroot%\system32\grouppolicy – folder on the target machine. All it needs now is a reboot or a “gpupdate /force”.

Note: If you cannot see the “grouppolicy” folder on either the source or the target machine, be sure to have your explorer folder options set to “Show hidden files and folders”…

For security settings:

1.) Open MMC and add the Snapin “Security Templates”.

2.) Create your own customized template and save it as an “*inf” file.

3.) Copy the file to the target machine and import it via command line tool “secedit”:

secedit /configure /db %temp%\temp.sdb /cfg yourcreated.inf


How to to Increase PHP Memory Limit

When you saw an error reads “Fatal Error: Allowed memory size of xxxxxx bytes exhausted” either in browser or server logs , that means PHP had exhausted the max memory limit. Mostly, this’s due to the insufficient memory allocated for the script. This article will teach how to increase the momory limit.

Check The Memory Limit

To see how much memory allocated for you php, you need create a file on your server (like view-php-info.php), and put following code in it:

< ?php phpinfo(); ?>

Visit it in your browser, you’ll see a table list all the config about current php environment. Search for “memory_limit”.

Also, you can also use this way to variety the memory limit change.
Continue reading…


Graph Search At Face Book

graAs Facebook have too many connections of people and information as well.Now it has launched Graph Search to make the procedure of searching more efficient.which will allow all of us to pillage our friend’s status updates, interests, photos and general activities on  Facebook.

Continue reading…


How to set a fav icon for a WordPress blog

1. Create FAVICON as *.ico file.

2. Upload your FAVICON to */wordpress/wp-content/themes/inove/img/ directory.

3. Remember no upper case letters, no spaces and only *.ico files.

4. Copy your FAVICON file name (from step No.2).

5. Replace XXX with your FAVICON file name in the following code. <link rel=”shortcut icon” href=”<?php bloginfo(‘template_directory’); ?>/img/XXX.ico” type=”image/x-icon” />

6. Open your theme editor and select Header (header.php)
– wp-admin/theme-editor.php?file=/themes/inove/templates/header.php&theme=iNove&a=te

7. Go to the end of the code. You will see <!– navigation END –>

9. Now drop this line of code – before the <!– navigation END –>

10. Save changes. You will see the FAVICON.


Hidden Cameras

Cameras are playing a very important role in our society in various ways.Mostly people use it to remember their old memories.But in now a days all the super stores and shopping malls are too much crowded and it is not possible to keep an eye on each moment of the people.So the usage of hidden cameras  has been increased.There are various types of hidden cameras,they are available almost in all sizes they can be easily adjust in any position.You can easily monitor your home,shops and other areas which you want to be protect.It is easy and better way to protect your earnings.