GNU-Linux

See also http://agaricdesign.com/note/web-site-uptime-monitoring-tools

Best resource I've found yet on how to monitor mysql (not a surprise)

http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000301.html

To uninstall something with aptitude:

aptitude remove something

Darn it, we need a new aptitude.
This aptitude does not have Super Cow Powers.

Dan Hak
2:25
huh?

Benjamin Melançon
2:26
I tried to uninstall ftp on stedile to make dkg happy, and there is no uninstall command so I got the help text
which concluded with, "This aptitude does not have Super Cow Powers."
aptitude remove proftpd
is the syntax for uninstalling. That might change with super cow powers though.

mysqldump -u root -p internetbar_live > internetbar_backup.sql

(should gzip here)

This command compresses the file database.sql and replaces it -- deletes it -- with the compressed .gz file database.sql.gz

gzip database.sql

scp ben@66.135.41.18:~/internetbar_backup.sql internetbar_backup.sql

On the other end if you compressed, uncompress:

gunzip database.sql.gz

Note: tar is for making an archive of multiple files.

Applying a patch.

You can just use the link to the patch from the issue queue (in this example, in a post by galapas to my usability request) to fetch the patch directly with wget:

ben@server:/var/www/drupal6$ sudo wget http://drupal.org/files/issues/system-admin-inc.193034.patch

Then apply the patch:

ben@server:/var/www/drupal6$ sudo patch -p0 < system-admin-inc.193034.patch

Didn't like it much, so reversed it:

These notes more refer to monitoring servers themselves:

Debian uptime measurement tools
Debian uptime measurment tools
site uptime monitoring tools

http://www.debian-administration.org/articles/103

iptraf

Posted to Drush issue queue:

Here's Agaric's workflow (ignore the lack of a link to Drush's path, we have too many Drupal installations to make that practical at the moment):

cd /var/www/drupal-5_3-live/sites/all/modules/
sudo php drush/drush.php -l http://example.com pm install fasttoggle
sudo svn add fasttoggle
sudo svn commit -m "Installed fasttoggle via Drush"

High performance Drupal:

Yelvington says:

Drupal will run as many modules as you ask, but your php config may need tinkering. If you get the white screen of death, inadequate RAM is often the cause.

We run APC as well, which of course requires extra RAM as well.

And for best performance you can have mysql store the sessions table in RAM.

Agent Rickard says:

my.conf mysql max connections

grep -h oom-killer /var/log/kern.log{.0,} | cut -f1, -d: | sed 's/$/:xx UTC/' | uniq -c

aptitude install mytop

mytop -u wsf2008 -d wsf2008 -p pASsWoRd

This is just too funny.

http://weblog.mediatemple.net/weblog/2007/01/19/anatomy-of-mysql-on-the-grid

Linux - General Command Lines

Note: You MUST be at the ROOT user to make/save any changes. Linux users, your distribution will determine the location of your network config file which will need to be updated and saved in order for the changes to remain in effect after rebooting. Network cards are referred to as eth0, eth1, eth2, etc based on their position on the PCI bus.

Many of our sites link to an Agaric Design Collective logo by the inestimable Dan Hakimzadeh (I literally don't know what that word means– he made a great logo, but then didn't fix the links to the image, so we're giving him the benefit of a toss-up).

From the directory on my computer with the image, we upload it to my home directory on Agaric's server:

scp LOGOSMALL.png ben@agaricserver:~

Now up on Agaric's server, me make a directory for it, move it into position, and rename it– in two steps!