Solution: Maximum Cache size for Chrome is 300 MB, for Safari it is unlimited, For Opera 10+ it is 400 MB, for Firefox 17 the maximum cache size is 1024 MB, for Internet Explorer 6,7,8 it is 50 MB and for Internet Explorer maximum cache size is 250 MB.

Solution: A identity indicates no compression. Compress is a method that uses UNIX compress, it is based on LZW algorithm. Gzip is the most famous compression format, deflate is a kind of gzip without checksum header, it is little faster but less efficient. DNS stands for Domain Name System and is a naming system in computers.

Solution: Gzip or deflate is partially supported by Netscape 4.60+. Netscape 6+, IE 4+, Opera 5+, Safari, Chrome, Lynx 2.6+ and Firefox fully support Gzip compression, IE 4.5 and 5 does not support Gzip compression, IE 5.5 and 6.0, IE 6.0 SPI, IE 6,7,8 partially support Gzip compression.

Solution: There are more than 80 extensions of the PHP source code. Mysql.so takes the size 42 KB, apc.so takes 655 KB, ffmpeg.so takes 35 KB, imap.so takes 86 KB, sasl.so takes 15 KB, tidy.so takes 42 KB, mysqli.so takes 107 KB, gd.so takes 94 KB.

Solution: APC supports four locking methods named File locks, Spin locks, Pthread mutex, IPC semaphores. File locks are the most stable, Spin lock gives the best performance, Pthread mutex is only available in Linux version 2.6, IPC semaphores are faster than file locks.

Solution: The most basic class of NoSQL is key-value stores and commonly used in web infrastructure. Multidimension stores are more complex data relationships, here data is stored in rows and columns. MongoDB and CouchDB are the examples of Document stores.

Solution: There are various backups in MySQL. File backups, SQL backups, backing up from a slave, CSV backups, Incremental backups are some kind of backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.

Solution: Copy of data or else database is known as backup. The final method for creating MySQL backups is LVM snapshots. It uses a copy-on-write feature of storage systems in which LVM i.e. Logical Volume Management is the most popular in Linux. It is very quick as it creates the snapshots. CSV stands for Cluster Shared Volumes backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.

Solution: Forks are the drop-in replacement of MySQL. Some of the forks are MariaDB, Drizzle, Percona Server, OurDelta. MariaDB provides compatible general public license(GPL). Drizzle is better to fork than MariaDB, it is largely compatible with MySQL. OurDelta provides a combination of MySQL and MariaDB. Sphinx is a full text search engine of SQL.

Solution: The option for table cache is table_open_cache. It controls the maximum number of tables that the cache can hold, we set the variable equal to the total number of table, table_definition_cache is the lightweight partner to table cache.