Tag Archives: sysadmin

Handy tips for bash scripting: screen reminder and logging

Often I find myself writing simple wrapper scripts for long-running tasks, like migrating a database or performing some repair or optimization process. I mainly want to ensure proper logging is kept in order to determine how long each step takes … Continue reading

Posted in CLI | Tagged , , , | 7 Comments

Troubleshooting MySQL queries: a useful workflow

Configuring and optimizing MySQL servers, from the underlying hardware to the instance settings on up to the application queries, is a multi-faceted and complex process. Here I’d like to assume you’ve got a well-configured physical server (it’s at least functioning … Continue reading

Posted in MySQL | Tagged , , | Leave a comment

Improved random password generator script

[EDIT, 2010-11-10:] After being kindly corrected by Chris Jones, I recommend instead using a readily available utility that is more feature rich to boot: pwgen.[/EDIT]

Posted in CLI | Tagged , , | 2 Comments

Dealing with “could not create shared memory segment” from postgres on Ubuntu

After installing postgresql-8.4 from the Ubuntu repos on an Ubuntu 9.10 machine, I received the following when the daemon tried to start up: 1234567 * The PostgreSQL server failed to start. Please check the log output: FATAL:  could not create shared … Continue reading

Posted in CLI | Tagged , , , | 10 Comments

Viewing all users on a Linux system

There are a number of widely-used and stable utilities on Linux systems that allow you to view information related to users. You can see who’s logged in with who, get info on a particular user with finger, see who you … Continue reading

Posted in CLI | Tagged , , , | 7 Comments