Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 68

Displaying posts with tag: Sysadmin (reset)

Need a new web host
+0 Vote Up -0Vote Down

Ok, this blog is currently hosted by, and I think that needs to change, which is sad, because up until recently, I’ve been pretty happy with the performance. However, I recently had an issue, and some things came to light about my package that I wasn’t aware of.

First of all, the maximum time a process can run is about 6 seconds. Second of all, the maximum number of processes you can have running at once is 12. When I asked if this was a limitation of my *package*, the answer I got was that it was a limitation of all shared hosting accounts.

This blog started throwing 500 errors some time yesterday. I called support late last night and …

  [Read more...]
Saying What You Mean
+0 Vote Up -0Vote Down

Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself.

However, there is a section in the .profile that is causing me issues:

if [ -f /usr/bin/ksh ]; then
        /usr/bin/ksh -o vi

So, “If ksh exists, run it with some options to edit history with vi-like commands”. Except what we really want is “If you’re using the ksh as a shell, . . . .”

So I added a modification, and now all is fine.

if [ -f /usr/bin/ksh ]; then
        if [ "$SHELL" …
  [Read more...]
How to advocate for good backups! Or, how NOT to advocate for good backups!
+0 Vote Up -0Vote Down

I try to do a decent job of advocating for caring about good backups and business continuity strategies in my 7 Deadly Habits article. But this one beats them all:

Just too funny and great not to share. Found via this reddit article, where there is a lively discussion underway.

How to find out the machine ID on various UNIXes
+0 Vote Up -0Vote Down

It recently came up that it would be helpful if we had a cheat sheet to find out the machine names for any given UNIX. I knew these off the top of my head but it would be great if people added more as comments.

HP/HP-UX: /bin/uname -i
IBM/AIX: /bin/uname -m
SGI/IRIX: /sbin/sysinfo -s
Sun/Solaris: /usr/ucb/hostid

Review: MySQL Database Design and Tuning
+0 Vote Up -0Vote Down

First time for me to review a book on Sensual, but I just finished MySQL Database Design and Tuning by Robert D. Schneider (MySQL Press, ISBN 0-672-32765-1), and considered it to be both a good read and am sure it will prove a good reference in the future. For the most part, the author is straight to the point providing realistic scenarios and solutions. He also covers a plethora of variables that affect database performance, and exactly how to monitor certain aspects to determine which settings to adjust.

His primary focus is on MyISAM and InnoDB, as they are the most popular, but he does have a brief chapter at the end of the book …

  [Read more...]
Sphinx Fulltext Search Engine Part III (continued)
+0 Vote Up -0Vote Down

I’m finally taking the time to continue this series =)

Lyrics Grep

For testing purposes, I went ahead and scraped about 60,000 song lyrics off of a number of sites and developed a simple search engine for them. The script that did the scraping is pretty nasty (to handle equally nasty HTML that I had to parse through), so …

  [Read more...]
Sphinx Fulltext Search Engine Part II (continued)
+0 Vote Up -0Vote Down

Note: Part I is located at the page that describes part one

Just a minor clarification to anyone that was confused: I am currently experiencing Sphinx for the first time. Everything I’m writing about is new to me as well, for the most part. So far, I’m drooling over some of it’s capabilities; I may come back in a month and rip it a new ass hole.

Back to Configuration… (not really, this is the bitching section)

In preparation for my …

  [Read more...]
Sphinx Fulltext Search Engine
+0 Vote Up -0Vote Down

I’ve been looking for a good solution to manage full text search for large data chunks (2GB - 100GB). I’ve written a couple of solutions using Xapian with limited success, but unfortunately I haven’t been satisfied with it overall. Performance was good, but there were a number of issues with flexibility that have me ultimately looking for another solution.

At my usual day job, the topic was brought up and I mentioned Xapian and Lucene as solutions, however we’re looking to stay away from Java as it’s not currently in our architecture, and as I stated before: Xapian doesn’t quite have the …

  [Read more...]
10 Newer Entries Showing entries 61 to 68

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.