MySQL bogging down

2003-12-20 Thread Chris Cameron
ithout issue for a good 3 months. Recently the load has increased, but only from .3 to .5 queries a second. Anyone have any ideas on where I should start looking? Thanks, Chris -- Chris Cameron UpNIX Internet Administrator ardvark.upnix.net bitbucket.upnix.net -- http://www.upnix.com

Innocent (looking) query pinning mysqld

2003-05-31 Thread Chris Cameron
n EXPLAIN on this query as it also hangs. Also, I've been fiddling with indexes, so they may be a little out of whack.. But I do think the right things are indexed. Any help would be appreciated. Thanks, Chris -- Chris Cameron UpNIX Internet Administrator ardvark.upnix.net

Alternate word finding with '%'

2001-09-03 Thread Chris Cameron
I'm sure this is disscused somewhere, but I'm not sure how I'd look for it. Is it possible to supply a thesaurus-like file for mysql so when you go "%oil%" it finds petrol gas and/or lubricant? Does anyone know of a database that will do this? Thanks, Chris ---

Re: Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-03 Thread Chris Cameron
Perhaps it's his platform of choice. On Sun, 2 Sep 2001, Sinisa Milivojevic wrote: > What you are trying to do can be done on NT / W2K only. > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__

RE: Thinking of switching from MyISAM to InnoDB

2001-08-04 Thread Chris Cameron
Is there a place that outlines the advantages/disadvantages of both MyISAM and InnoDB? Thanks, Chris -Original Message- From: Tonu Samuel [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 2:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Thinking of switching from My

Managing user db's (quotas)

2001-07-29 Thread Chris Cameron
I sent this before, but it never made it.. Does anyone here have any advice on controlling the size of user databases? I've heard talk of symlinks before, anyone had any luck with that? Thanks, Chris - Before posting, please

RE: MySQL or MS SQL?

2001-07-18 Thread Chris Cameron
I'm sure if done right, MySQL could do whatever you want satisfactorily. Same with MS SQL (ignoring cost). However, something few people seem to know, but I've realized from experience is that when you offer people services based off free software, you get a different kind of customer. And not th

Storing Credit Cards

2001-07-01 Thread Chris Cameron
A client has asked us to make him an application that requires us keeping Credit Card Numbers. I'm a bit concerned as it immediately remined me of egghead.com (having all their CC #'s stolen). One of the ideas was to have the users password encrypted as an md5 hash, and then to encrypt the users

Expected speed of MySQL on a 166

2001-06-15 Thread Chris Cameron
I'm currently using a 166 UNIX machine for a dedicated MySQL database, and I'm interested in knowing what kind of speed I should be expecting from it. I ask because right now it's at a point of being unusable even for development on some of the larger queries. I compiled MySQL 3.23.37 myself with

Flakey mysqld under OpenBSD

2001-06-02 Thread Chris Cameron
Hi, Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can finally get some help now that I've finally got around to recompiling it again. I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the configure options; "CXXFLAGS="-O6 -march=i586" CFLAGS="-O6 -march=i

Re: mysqldump hangs

2001-03-31 Thread Chris Cameron
I should start reading this list more.. I've had a similar problem, and good luck finding many people who'll help you with OBSD problems on this list (or any problems for that matter). Anywho, it's ports specific I think. I installed MySQL from source compiling with -O6 and the proper arch (like

Dying Server

2001-03-07 Thread Chris Cameron
Whenever my MySQL server (3.23.33) is under heavy load it restarts itself. Stopping whatever was connected to it at the time. In my .err log I've just got; 010307 00:12:32 mysqld started /usr/local/libexec/mysqld: ready for connections Killed 010307 00:16:56 mysqld restarted /usr/local/libexec/

Database reading problems

2001-01-24 Thread Chris Cameron
After noticing all my PHP scripts using MySQL had stopped working, I noticed that any attempt to look through databases mith mysql brought up; Can't read dir of '.' (Errcode: 9) Can't read dir of './mysql' (Errcode: 9) Database changed I can no longer get any information from MySQL, and I'm hopin