Friday, November 26, 2010

[Level 1] How to install acroread in Ubuntu 10.04

If you want to install acroread in Ubuntu 10.04,
please follow the steps below:
1. active package resource "lucid-partner".
2. reload it.
3. search key word "acroread" and install it.

Wish this helps.
regards,
Stanley Huang

[Level 1] A tip for MySQL option.

--defaults-file=/... must be the first option or will occur the following error.

unknown variable 'defaults-file=/...'

Wish this helps.
regards,
Stanley Huang

Wednesday, November 24, 2010

[Reference] What Is New in MySQL 5.5

What Is New in MySQL 5.5


Wish this helps.
regards,
Stanley Huang

[Reference] Performance-Guide-for-MySQL-Cluster-Presentation

http://assets.en.oreilly.com/1/event/2/Performance%20Guide%20for%20MySQL%20Cluster%20Presentation.pdf

Wish this helps.
regards,
Stanley Huang

[Level 2] How to get tables are in use or locked in MySQL?

How to get tables are in use or locked in MySQL?
mysql> show open tables where in_use <> 0 or name_locked <> 0;

Wish this helps.
regards,
Stanley Huang

Tuesday, November 16, 2010

[Level 2] Create loopback device file in Ubuntu.

Create loopback device file in Ubuntu as following steps:

1. Create  block file
# dd if=/dev/zero of=/file bs=1k count=500
2. Create loopback device
# losetup /dev/loop0 /file
# losetup -a

3. Create filesystem
# mkfs -t ext2 /dev/loop0
4. Mount loopback device
# mount -t ext2 /dev/loop0 /mnt 
5. Umount loopback device

# umount /dev/loop0
6. Delete loopback device
# losetup -d /dev/loop0

ref:
http://manpages.ubuntu.com/manpages/lucid/man8/losetup.8.html

Wish this helps.
regards,
Stanley Huang