There are many good low-end VPS provider over there with low cost, such as RamNode providing $2/month for their 128mb VPS, so the question is how can we do on a low-end CentOS server? Well, the answer is: you can run many websites on it with some tweak configurations. Let’s discover how to do this. On…
Sometimes the default mounted size in /tmp is too small and it might cause many unexpected crashes in Linux applications (such as mysql queries performing schema change, etc.) as well as your website application. In this case, although we can find and delete old files in /tmp directory, but it might also be full quickly…
Some rules we should remember when doing MySQL index query: Index uses B-TREE, so be sure we understand how B-Tree works. Index is left-most, so if there is (c1, c2, c3) index, then query WHERE c1 = 1 AND c2 = 2 does use index, but not WHERE c2 = 2 When considering indexing, remember the following…
Upgrading from MySQL 5.1 to MySQL 5.5 / 5.6 when there is existing data is quite head-cache and scary story. Some notes might also help you when do upgrading: After upgrading, we need to run mysql_upgrade. In order to do that, we must have the mysql service running[bash]mysqld –skip-grant-tables –user=mysql mysql_upgrade -u root -p’PASSWORD'[/bash] If mysql…
Every developers might also understand how important index is when performing query but not of all do really care about how MySQL Query Optimization works. In the most cases, developers will think that index will work as it is and do not check in detail how index really work for a specific cases. The fact…
This tutorial helps you install percona server in CentOS as a replacement for MySQL server. According to Percona, Their “MySQL service clients and open source software users achieve breakthrough results with MySQL: cost savings, faster time to market, higher system up-time, and long-term scalability. MySQL performance is a focus for all that we do”. If…
In your development work, there are sometimes you forgot the mysql root password so you cannot make any system-level change to the mysql server. This quick tutorial tells you how to reset mysql root password in CentOS. First, need to stop MySQL:[bash]root# service mysqld stop[/bash] Then, start MySQL in safe mode:[bash]root# mysqld_safe –skip-grant-tables &[/bash] Log…
Reflection is generally defined as a program’s ability to inspect itself and modify its logic at execution time. In less technical terms, reflection is asking an object to tell you about its properties and methods, and altering those members (even private ones). In this lesson, we’ll dig into how this is accomplished, and when it…
You might ask: What is Laravel (and Laravel 4)? In short, it is the PHP frameworks for web artisans. This contains notes for beginners. We can generate tables for application by utilizing the migration feature with artisan. For example, in order to setup a user table, we use parameters –table and –create:[bash]php artisan migrate:install php artisan migrate:make…
Backing up your information is very important to you, or at least it should be. One of my college professors once told me, “It is not a question of if your hard drive will crash; it is when your hard drive will crash.” Rsync is a tool that allows you to keep two distinct directories in sync, either locally (two…