Posts

Showing posts from November, 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

[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

[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