Just got a Google Voice Beta Invitation today. So happy at first since I want to test it for quite some time. Unfortunately the service only available in the US. Not for UK yet.
OMG, please speed up the process and let us try in the UK toooo!!!
This summer I found out that my working enviroment just got too many computers and generated too much heat too (of course the electricity bill is a bit too high). This is the time to talk about Green Power and Save the enviroment 
hah
I will be getting rid of my current server which is
The current server mainly is for NAS Storage, PHP/MySQL Development server and to practice more on SSH + UNIX
OK, let’s talk about new thing now.
I am going to build my new tiny Green Powered Server which I will name it as usual – CORE Server (maybe I should call it 2nd generations?)
The aim for this new CORE server is mainly because
Here are the specs of my CORE Server
Hardware
| Product | Specs | Price | Remarks |
| Mini-ITX Casing |
|
£60 | - |
| CPU + Motherboard |
|
£60 | 17cm x 17cm |
| Memory |
|
£18 | CL5 |
| Data Harddisk |
|
£140 | Low Power Consumption |
| OS Harddisk |
|
£0 | Used HDD from old laptop |
Software
| Operating System |
|
£0 | Running on ext3 |
| Virtualization |
|
£0 | - |
| LAMP |
|
£0 | - |
Now I am waiting for my Intel Little Falls 2 to come on Wednesday and will continue this post
12/June/2009
Finally the Intel Little Falls 2 arrived!!!
It really a headache when trying to put this motherboard into the tiny casing. I have to remove the HDD racks and power supply in order to fit the board in. I even have to take off the bottom part of the casing (No wonder this tiny casing so expensive, the design is really user friendly )
The second problem is the cables after fit in the board and every other parts. SInce the space will be super compact, I have to squeeze all the power and data cables into the sides. The CPU Fan only remains about 3cm height of space just under the 5.25″ HDD rack on top.
Just after completing the assembles, the first thjing I need to check will be the temperature of the CPU. It shows around 40 celsius in the BIOS with the CPU fan running at about 2800rpm and the casing big fan which draws out hot air running at around 4500rpm.
Since the server will not be fit with any optical drives, so I have to temporary plug in the DVD-RW drive to install the CentOS 5.3 Final. The installation went off smoothly and then after around 30 minutes I have the OS up and running!!! It takes long for installing because I want to customised all the installations. I only choose the Server-GUI version with customized packages to keep the overall system file size below 2GB.
If you are interested in the system process details, please leave me a comment so I can tell more. At the moment let me test the server first and moving all my data files into it.
updated: by using “smartctl” command, 3 HDDs detected running at around 30 to 36 celcius, not bad huh!!!
Recently I am working on a project where I will need to convert client’s database with millions of old Paradox/Foxpro records to MySQL and then I have to create a new Web App based on PHP/MySQL to deal with all this old records plus new way of database structuring.
When I am trying to update a customer ID from a table A to table B, I always need to wait for few hours for the server to process it. This is so annoying and waste of time.
Finally I found the answer today where actually I need to INDEX the customer ID before doing the updates. The difference is just so BIG.
With the same command issue at the following, without INDEX it will takes hours to complete BUT after INDEXING then it just need 1.45 sec for 19,638 records!!!
UPDATE tel AS t INNER JOIN contact AS c SET t.cid = c.cid WHERE t.addr_id = c.addr_id AND t.cid = 0;
Query OK, 19638 rows affected (1.45 sec)
Rows matched: 19638 Changed: 19638 Warnings: 0
So, now I just perform the update again for full data and let’s see the results
UPDATE tel AS t INNER JOIN contact AS c SET t.cid = c.cid WHERE t.addr_id = c.addr_id;
Query OK, 0 rows affected (3.55 sec)
Rows matched: 103484 Changed: 0 Warnings: 0
That’s why I say it’s fun to play with web programming now a days lol
Taiwan Semiconductor Manufacturing Company (TSMC) and United Microelectronics Corporation (UMC) will likely land chip orders for Apple’s low-cost entry-level iPhone nano, the Chinese-language Economic Daily News (EDN) reported today.
Let’s wait and see will this iPhone nano realy a surprise
Recent Comments