This article discuss how to do full page cache with nginx and memcache. Since the cool kids at Google, Microsoft and Amazon researched how performance and scalability affect conversion rates, page load time has become the topic of every eCommerce store. Magento was once a resource hog that consumated everything available to it and you…
When you are using MySQL, you will (likely) have tables that can be fragmented. Fragmented tables in mysql needs to be optimized. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL will be locked (and results…
CSF (stands for ConfigServer Security & Firewall) is a Stateful Packet Inspection (SPI) firewall, Login/Intrusion Detection and Security application for Linux servers. This note mentions some snippets for configuring this software. To deny/allow incoming/outgoing ports, change the configuration file csf.conf To remove an IP from temporary ban list, remove it from csf.tempban To enable some crawler such as…
According to the book High Performance Web Sites: Essential Knowledge for Front-End Engineers by Steve Sonders, and at BEST PRACTICES FOR SPEEDING UP YOUR WEB SITE, there is a best practice for boosting front-end performance as follows: The problem caused by scripts is that they block parallel downloads. The HTTP/1.1 specification suggests that browsers download no more…
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM issimpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for inserting and updating while MyISAM implements table-level lock. InnoDB has transactions while…
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets. This article shows how to install Redis to work with Linux-based PHP development environment. Installation and Configuration Download and install Redis [root@signals phpredis-master]# wget…
This is a simple guide to installing CentOS via CentOS Network Install (netinstall). You can save yourself a lot of time by doing a network install and only installing the base packages rather than downloading a 3.6GB DVD ISO or the six CD-ROM images. 1. Start by downloading the small 14MB CentOS-5.8-x86_64-netinstall.iso image and burn it to a…
In order to create virtual machines based on ISO disks, you need a local ISO Storage Repository on Citrix XenServer. There are several options of ISO Storage repositories in Xen Server based on the location of the repository. You should check the location based on the available space and your space requirements. We recommend to…
This excellent article talks about database performance on very big system at Twitter and Paypal. The article is originated from iTnews.com.au Driving big performance using MySQL Engineers at Twitter, Paypal have joined Facebook in offering a look under the hood of the massive MySQL deployments that drive their web services. Database and application engineers at both…
This article mentions common problems when performing pagination on a big data set and solutions to overcome them. Scenario When querying with a large dataset, we often use SELCT …. ORDER BY a,b,c LIMIT M, N , but do we know how does this query perform? Let’s look at the explain query: mysql> EXPLAIN SELECT…