MySQL Server is being clogged !

Great , now my server host is having some issues with their MySQL Query. Even after tons of optimisations that I’ve done my side (okay Im bit exaggerating) , I’ve noticed that the server goes down frequently. I’ve submitted a support ticket and hopefully they will look into this matter. Currently , I am writing My QoS guild for tomato firmware !

RM 159 for Laptop + 3G Modem + 3G Access

While most of us are striving for WiMax , Celcom has come up with a good deal to lure more potential buyers to switch to Celcom (I am guessing that want to put up with Maxis – as most of the people choose maxis because they provide a modem with it rather , which is somewhat innovative as 3G Modem is expensive and not many people can afford it. If you think for the long run , you’ll certainly buy but then you must think of an average consumer. Would he/she buy a modem for RM 400-500 , the answer is certainly not and celcom failed to attract its customers because of this. Guess they have planned something to pull more customers in , thinking that they could save.
Well actually if you calculate , you wouldn’t be saving that much. The Laptop is just only a Dual Core Pentium Core Laptop , surely you can get one for a very cheap price from HP ,but then you wouldn’t be having any Broadband service. If we take a look at the plan , its RM 68 a month for the 384Kbps Unlimited Internet Package and it doesn’t come with modem. For the one that comes with modem , it costs roughly RM 100. So by adding extra RM 54 a month you’ll be getting a laptop also. I am not sure for how long is the contract but the good news is you get to have the laptop and the modem. After the contract , you’re free to switch providers (Who knows – DiGi might roll their 3G Service by end of this year or by end of the next year and it will be just nice for you to hop on into DiGi)
For students , especially if you are unable to get streamyx or if you are hunting for a laptop for your assignments , then I would highly recommend you to go for this package. Most likely you wouldn’t be needing a fancy laptop with dedicated graphics , Intel Core 2 Duo and other goodies if you are going to use it for assignments and online work. I mean this laptop is fine if you want to run basic games and productivity applications such as Microsoft Office. So if you are are student or if you know someone who is looking for a laptop and Internet access , then ask him/her to get this
P.S – This is just my thoughts. I am not advertising Celcom or anything else nor getting paid by them to post this blog entry !
If you’re a power user , this so-called package isn’t worth it as you know by now that you could save roughly RM 200-300 if you buy the items separately. Not to forget that you wouldn’t be tied with a contract !
I don’t have more information or URL , but you can call celcom (03-36308888 or 1111 from your Celcom Mobile) for more details or just go to one of their centres 

Celcom Latest Offering
Celcom Latest Offering

My Server – Part #2

Remember people , that I’ve posted on my blog saying that I’ve received my Server and here is a picture of it. Yeah , its a bit messy but there you have it. The quality isn’t that great as it was taken from a Camera Phone (my old hp hw6515e smartphone which is a 1.3MP Camera) . This is the picture of my Dell OptiPlex GX110 and it runs ubuntu linux. Here are the functions of my server :-

  1. File server – Usually I store my DVD ISOs or some large file there. Despite the 30GB HDD , I still try to make use of every single byte that I’ve. Of course my large files , videos , music all resides in my main PC. I need to find some time to transfer all my music from my pc to my server and then find a way to appear in my iTunes music sharing list. I am sure there is a way. For now let it be like this , once I’ve saved up enough , I’ll get a Hard Disk for my Server (a larger one)
  2. Torrent server – It runs Deluge with WebUI installed , so that I can add torrent , remove torrent by just any web browser. I don’t have to VNC to the server and control it from there , although I am forced to do it when I want to manage my bandwidth (i.e reduce the upload rate and download rate to make way for my online gaming or YouTube streaming)
  3. Web Server and some lame cheap Text-gaming server – A server isn’t complete without a Web Server. So I’ve installed Apache , PHP and MySql in it. Mainly , I wanted to learn more on web scripting and other things. It would be better for me to test it locally then uploading here. It will be a waste of bandwidth and resources and I don’t want to be held responsible if my script hogs bandwidth or contains flaws. The best way to do is test it in Localhost. My server is live by the way – meaning that it can be accessed by anyone on in the Internet but I am not going to post its URL. No , not yet. I’ve to secure it properly first before posting it
So far thats all that I can think of , of course it will be my primary Linux box as well and it will be used to compile programs and other things. I might even start some binary site (compile oss projects , optimise it and then release it) . Oh yeah , the specs you ask :-
*Drums Roll*Â
Dell OptiPlex GX110 - Pentium III (Coppermine) 800 Mhz || 256MB SDRAM 100Mhz || 3Com Corporation 3c905C-TX/TX-M || Realtek Semiconductor Co., Ltd. RTL-8139/8139C/8139C+ || Intel i810 series Board = Intel Corporation 82801AA || SCSI to ATA adapter - ATA Maxtor 2F030L0 || 52x Generic CDROM DriveÂ
There you have it , now stop bugging me and asking me to post my server specs. Oh , nobody asked for it anyway. Just adding spices to make my blog more interesting , thats all !Â
Its My beloved Server - That crunches all the task that I throw at it !
Its My beloved Server - That crunches all the task that I throw at it !

Must cut down usage

Just got an email from my provider and it seems that they aren’t happy with the MySQL Usage. According to them , I have been using a lot of server resources and running memory hogging and CPU hogging scripts. they have asked me to disable it or optimise the script.  After searching , I’ve managed to find the culprit – which is no other then WordPress. I’ve disabled couple of options for now. If this thing goes on, I might have to do a fresh installation of WordPress or reconfigure the whole thing again so that it doesn’t consume that much of bandwidth or CPU usage !

Avoid paying RM 200 penalty for Maxis Broadband


OMG No Contract - Oh wait there is a RM 200 Handling fees if you say goodbye within 12 months !
OMG No Contract - Oh wait there is a RM 200 Handling fees if you say goodbye within 12 months !

Ha , thought of sharing this with you guys. As most of you know , I was an ex-Maxis Wireless Broadband user. At first it seems to be pretty good and the speeds were great and I was even able to run peer to peer programs. Then it went all bad , they started to block most of the peer to peer application and even gaming ports (blocking p2p is fine but gaming ports – thats madness). Thankful , I made a wise decision – which is to ditch Maxis Broadband and to switch to Streamyx. Surely , you may say ‘Ah..why streamyx ?’.Before I answer that question you must understand that we have limited choices here in Malaysia. Streamyx is still the King of all lousy broadbands here. If you think Streamyx is the worst – think again.  I Thought of sharing this cool tip that worked for me and couple of friends of mine to avoid paying RM 200 early penalty termination fees. Shall we get started ?
Read More

WiMax for under RM 100 ?

Read in NST today. It seems that P1 wants to be competitive and they have said that they’ll be coming up with packages starting from under RM 100 which is great for most people as they are making wifi affordable by everyone. They have not mentioned on the package specifications nor its details. We will just have to wait and see !

WiMax by P1 Broadband – Insight Look !

Yeah , we have heard of them for the past year ago. At first they keep on insisting  that its going to be launched soon , but as usual , due to some unexplained reasons , it took them longer to launch the service. Nevertheless , they have started to test their WiMax Service by offering Free 2-Weeks Trial to customers who are within the coverage zone. Anyhow , this is a screenshot of a speedtest posted by a user by the name of freezbies , if you take a look the speed is far superior then your average Streamyx 1Mbps packageor your so-called 3.5G Wireless Broadband even the latency seems to be 10-15 times better then a 3G/3.5 Wireless Broadband but again it still can’t beat the latency of a wired connection. What does it mean for an average consumer. Well in plain English , it certainly means that  you can get to enjoy high-speed Wireless Internet with a low latency. This allows you to play most of the games out there such as DOTA as the latency is still bearable for local link ,but when it comes to FPS (First person shooter) you might face a bit of a problem. Now let us take a look at what P1 offers in terms of IP , Connectivity and other goodies !

speedtest - P1 WiMax
speedtest - P1 WiMax by freezbies

As most of us do know , Wireless Internet service provider such as Celcom does not provide an External IP and whereas for Maxis they block external connections despite providing customers with dynamic IP address. It causes a chaos when someone wants to host a game or a site from his own computer. Of course this is also another major drawback for p2p lovers as you are unable to open port which makes it harder for people to connect to your computer. This is the primary reason why I ditched Maxis Broadband (*who wants a limited broadband anyway*). Thankfully , it is not true for p1 WiMax , they do provide their users with an External IP Address without any sort of restriction. in other words you can run p2p applications , host your own game server or web server. For the geeks and nerds out there , their IP Range starts from till
secondly , another thing that I’ve noticed during the tryout over at my friends place and the comments/feedbacks that I’ve read in the message board is that , p1’s Modem comes along with QoS. Yeah that’s right , Free Built-in Intelligent Qos. It automatically throttles your p2p connection when you’re surfing the Internet , streaming youtube , or running VOIP data which is great for average consumers who have zero knowledge or little knowledge of networking. Its a smart move so that users would not complain that their speed is too slow when they are downloading. But there is one disadvantage of this Intelligent QoS , it means that P1 will always have the right to manage your bandwidth at all costs , they can throttle your p2p connection if they suspect that you’re hogging the bandwidth too much. It seems to be fair to me , as if they can manage their bandwidth wisely and provide a sustainable connection – Why Not ? 
This is all I’ve information on p1 WiMax Broadband. Of course , I am waiting for my 2 Weeks Free Trial as well. If you want to register for the Free Trial for yourself , I suggest you to head to p1’s Website and register your interest  there. who knows , just try your luck and see !. I’ll update more information on this matter once I’ve managed to get hold of the p1 WiMax Modem and the service or if i have any new news regarding their service !

w00t my new server

W00t , My good ol’ friend and my negihbour gave his old PC away (well I requested and he gave it to me). Anyhow , its a Dell OptiPlex GX110 Model (Pentium III 800Mhz , 256MB of RAM , 30GB of HDD). Well the HDD is mine but other then that its his parts all right. Anyhow I’m pretty happy right now as I’ve my own server at home. It will be ideal for me to bypass restricions and other things that I face along the way (i.e in college , some cheap library computers and in office envoriment). I will post the pics and more to come. Maybe I’ll come up with a page just to dedicate the rigs that I’ve. Oh yeah , its running ubuntu 8.04 LTS with XFCE. I just need a GUI a lightweight gui just to get some things done – sometimes CLI can be pain in the butt
More pics to come and my desktop screenie
Anyhow back to work !. Oh , I’ll try my best to update my blog as well !

QoS – Quality of service – Ep I

I have been getting this question slammed at me every single day over the message boards and even on my MSN.

Hi, I am sharing my streamyx/DSL/Broadband connection with 10 people and i am using 1Mbps connection. But then my room mate , partner , parents , kids are using it to download movies everyday and it causes the whole network to slow down. I am wondering that if there is any way for me to control/share my bandwidth or not

Fear not , I’ve the answer for you. It is called QoS – Quality of service – (its commonly used in computer science , especially computer engineering and other stuff). Of course there is a technicial term for it , but let us put in layman’s term shall we. It is used to prioritise which connection should get the bandwidth (as we know bandwidth is something scarce). For instance , you may want to ensure that VOIP packets/data/application gets the highest traffic priority as its important for you to maintain voice call and that goes same for online games as you want the packets/data to be sent as fast as possible. Now whereas for applications such as instant messaging , Browsing , you wouldn’t mind if its bit slow as its not a really demanding application. Therefore you’ll set the traffic to bulk.
QoS allows you to maximise on your current bandwidth enabling you to maximise the connection. if you learn how to manage your bandwidth properly you’ll notice that you’ll still have the bandwidth to do other things. In other words you can run BitTorrent and at the same time play World of Warcraft without any lags. How about that ?. Now you may ask , how do I activate this QoS. Basically there are two ways , one is via hardware (i.e router) and the other way is via software. Well for this blog entry , let us do something easy well. Let us take a look at the software part , I’ll talk about about this software – cFosSpeed. It is a traffic shaping software for Windows and its not free.

cFosSpeed Settings - Source : Softpedia

You can get it from here, of course it costs you 19.90 euros for it which might be expensive for most of us (no , i am not getting any commission from them , otherwise that link would be a referral link instead). It is straight forward and easy to configure. Pretty much its newbie-proof i would say. anyhow , I have a freeware alternative too. Of course this freeware alternative doesn’t quite do its job , but it is ideal if you use Windows Internet Connection sharing or (ICS). Now this freeware alternative shines , but if you are just using it on your own pc , it does quite as well but you wouldn’t be able to take the fullest advantage of what this software has to offer you. It is called Traffic Shaper XP (I don’t know if it works for Vista or not – Do let me know if it works). Anyhow the screenshot from softpedia
Traffic Shaper XP - Source : Softpedia
Traffic Shaper XP - Source : Softpedia

Of course in my next blog entry. I will be talking more about how this software functions and what other alternatives do we have besides software and what hardware routers are recommended for this purpose (i.e if you want to control the bandwidth from a router itself rather then per pc , as installing these application in each and every individual pc in your household can be troublesome)


Ack Streamyx Again !

Great just great. Yesterday it was a disaster for streamyx users nationwide (Malaysia) , lots of streamyx home/basic users couldn’t even surf any local links and international links at all. It just times out. So I called up TM to enquire if its any problem on my side or on their side. They said that there is no maintence and they suspect that I am not using the latest version of Windows. So they asked me to contact my PC Vendor to upgrade my OS. Thank god , I was being paitence yesterday (yeah – paitence is virtue – correctos 100%) , so I just kept quiet and let him explain. So finally he ( the streamyx call centre dude) himself deicded to file a report on this issue. Bam , I wonder if the technicial team are going to enterain such report. Nevertheless , they managed to fix the problem today (12 pm – I believe). Anyhow , the connection seems to be great and so far no issues.
But still TM doesn’t admit anything. If you go to the official streamyx site there isno mention on downtime or anything like that