Fine software projects, news and thoughts from the Linux world.

sshfs - secure and transparent access to remote filesystems

sshfs is a very slick way to access your remote filesystems, securely and transparently. It is based on the great FUSE (Filesystem in Userspace) framework, which has been integrated in the linux kernel since version 2.6.14. While sshfs may not be as fast and featureful as other full-blown network filesystems such as NFS or Samba, it still has some great features:

Your favorite database?

MySQL
28% (1136 votes)
PostgreSQL
27% (1095 votes)
Firebird
29% (1165 votes)
SQLite
3% (137 votes)
MaxDB
0% (17 votes)
Ingres
0% (14 votes)
Oracle
6% (235 votes)
Berkeley DB
1% (36 votes)
Plain text
3% (130 votes)
Other
2% (94 votes)
Total votes: 4059

How to optimize PostgreSQL database size

[img_assist|nid=199|title=|desc=|link=none|align=left|width=90|height=105]PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

The /proc filesystem documentation

The /proc filesystem acts as an interface to internal data structures in the kernel. It can be used to obtain information about the system and to change certain kernel parameters at runtime (sysctl).

The effort of the /proc filesystem is to provide an easy way to view kernel and information about currently running processes. As a result, some commands (ps for example) read /proc directly to get information about the state of the system. The premise behind /proc is to provide such information in a readable manner instead of having to invoke difficult to understand system calls.

The adaptive readahead patch benchmark

One of the more interesting patches for the linux kernel lately has been Wu Fengguang's adaptive readahead patchset, currently at version 12. Talking about its performance benefits Wu says: "besides file servers and desktops, it is recently found to benefit postgresql databases a lot.".

The flash plugin and X.Org 7.0 (X11R7) font problems

If you are lucky to have fresh X11R7 on your desktop with all its new features and nice filesystem layout you might have noticed that some things have compatibility problems with it. Namely, if you have flash plugin installed you might not see text in flash content displayed properly, depending on how your Linux distribution handled the upgrade.

Oracle10g on Debian Linux HOWTO

[img_assist|nid=379|title=|desc=|link=none|align=left|width=164|height=29]Is running Oracle10g on Debian Linux possible? Oh yes, definitely! And it runs great, really. It's even easier to install than the older versions of Oracle as there are no problems with incompatible libc library & other bugs. You need to make just two simple preparations before you can enjoy your new development database.

iostat screenshots

Both runs have been done on a single 120GB 7200rpm IDE disk. Command used: iostat -x 5 (extended statistics, sample every 5 seconds).

[img_assist|nid=866|title=|desc=|link=none|align=none|width=510|height=202]

iostat - Linux I/O performance monitoring utility

iostat is a command line I/O performance monitoring utility. It is present in almost every major Unix flavor in use today, and here you can get the version for Linux.

It works on both 2.4 & 2.6. What makes it different from other Linux utilities, which mostly show only I/O transfer rates, is that you finally can get important information about disk utilization, number of requests, average queue size and disk & queue wait times. No serious sysadmin should be without it. Check the screenshots to learn more.

XMM screenshots

All screenshots were taken on my home workstation (Dual PIII 1GHz, 768MB RAM). Brown color represents kernel memory usage (miscellaneous caches), red is for active memory (page/buffer cache in use and mapped pages - applications), yellow is inactive page/buffer cache, green is free memory and finally orange color represents swap usage.

[img_assist|nid=6|title=|desc=|link=none|align=none|width=131|height=166]

Pages

Subscribe to LinuxInsight RSS