Installing Ubuntu 13.10 alongside Windows 7 on Samsung Netbook N150

I want to install Ubuntu 13.10 alongside Windows 7.

Firstly, download the Ubuntu 13.10 ISO (I chose the 32 bit version because my netbook has 1GB memory). Then, create a bootable USB stick using Pen Drive Linux (http://www.ubuntu.com/download/desktop/create-a-usb-stick-on-windows).

Insert the USB to the netbook, then turn the netbook on. It will automatically load the Ubuntu. I chose the install ubuntu alongside windows option. Then I had to setup the wireless network. However, the installation suddenly quit and it restart the netbook.

The cause of the problem was the primary partition in the netbook harddisk. The harddisk already had 4 primary partition. I tried to delete one of the partition which I didn't need anymore.

Then I tried the installation process again, and this time it was successful.

Improve MySQL performance

I've got a problem with with my MySQL database (running on Ubuntu). I tried to run a query on a table (InnoDB) containing 250 thousand rows. The result of the query is only 3 rows. However, it took 4 minutes to get the result.

How to improve the performance?
Open the /etc/my.cnf in the text editor
sudo gedit /etc/my.cnf

Then go to [myslqd] section and add the buffer size.
The default size is 8M. In my case, I increased it to 256M
innodb_buffer_pool_size = 256M

Then restart mysql
sudo /etc/init.d/mysqld restart

To check the change, go to mysql command line and run SHOW VARIABLES.

DONE.

Source:
http://www.cowboycoded.com/2009/08/26/a-quick-performance-tune-for-mysql-innodb_buffer_pool_size/

Setup TPG's IPTV on D-Link DSL-2740B-F1

This is how I setup TPG's IPTV on D-Link DSL-2740B-F1.
The firmware version is AU_2.01

Go to Setup > Internet Setup > ATM, then click 'Add' button.

Just use the default setting, then click 'Apply/Save' button.

Go to Setup > Internet Setup > WAN Service, then click 'Add' button.

Click 'Next' button.

Select 'Bridging' type, then click 'Next'.

Click 'Apply'.

DONE.

Can't eject DVD

I have a Dell laptop running Windows XP. Sometimes I can't eject the DVD.
The easiest way to solve this problem is by disabling and enabling the DVD-ROM drive from the device manager.

Just right click on My Computer, select Hardware, find the DVD-ROM drive, select disable, then enable. That's all.

No video on TPG's IPTV

I could hear the audio, but no video on TPG's IPTV. It was working properly a few weeks ago.

How did I fix it?
I uninstalled the existing VLC media player(0.8.6), then installed the newer version (1.1.5). Don't forget to check the 'Firefox' option during the installation.

Windows XP VPN were missing

All of the XP's VPN connections were missing. Options 'Dial Up' and 'VPN' in the connection wizard were disabled. So, I couldn't make a new VPN connection.

It turn out that I accidentally disable some of the services.
These are the necessary services:

• Telephony
• Remote Access Connection Manager
• Remote Access Auto Connection Manager

After enabling those services, the previous connections are appeared.

http://www.computing.net/answers/networking/new-network-connection-disabled/36178.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;330163

Double thumbnail in Virtuemart

The components/com_virtuemart/shop_image/product folder is taking up so much space. Then I realised that virtuemart always creates 2 thumbnails: one in product folder, and one in resized folder.

Here's a link on how to fix this problem:
http://forum.virtuemart.net/index.php?topic=51644.0