RE: Mysql Hogging all system resources

2007-04-13 Thread Don O';Neil
x27;top' still shows his processes (old and new) with a nice of 0. Is there something else I'm missing? -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:57 PM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mys

RE: Mysql Hogging all system resources

2007-04-13 Thread Don O';Neil
Nevermind on the "badly formatted number"... I specified the full path /usr/bin/nice and it worked ok this time :-) However, I still want to know if there is a way to specify a nice level for an entire users processes. Thanks! -Original Message----- From: Don O'Neil

RE: Mysql Hogging all system resources

2007-04-13 Thread Don O';Neil
er [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 11:38 AM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote: [ ... ] > Is there a way to prioritize or set the amount of resources t

Mysql Hogging all system resources

2007-04-12 Thread Don O';Neil
I have a customer that loaded up a HUGE table and was doing all sorts of fancy stuff in it, and not waiting for the process to finish before sending the same query, and eventually loading up the server to the point where the only thing I could do was unplug it. Is there a way to prioritize or set

RE: Problem with query on 5.11

2006-10-20 Thread Don O';Neil
, October 19, 2006 11:47 PM To: Don O'Neil Cc: mysql@lists.mysql.com Subject: Re: Problem with query on 5.11 Don O'Neil wrote: > Why does this query return no results: > > SELECT * FROM FileList WHERE MATCH Filename AGAINST ("9640") > > When there are entries in the F

RE: Problem with query on 5.11

2006-10-20 Thread Don O';Neil
Yes, there is a full text index, there are about 12,000 rows or so. Don -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, October 19, 2006 11:47 PM To: Don O'Neil Cc: mysql@lists.mysql.com Subject: Re: Problem with query on 5.11 Don O'Neil wrote:

Problem with query on 5.11

2006-10-19 Thread Don O';Neil
Why does this query return no results: SELECT * FROM FileList WHERE MATCH Filename AGAINST ("9640") When there are entries in the Filename list that have 9640 in them? I'm using MySQL 5.1.11. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Build Backwards Compatible MySQL Client Libs

2006-02-23 Thread Don O';Neil
Hi all... I have some OLD programs I don't have the source for that were built with the MySQL 3.23.55 client libraries. They still work great, even when using those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in the new lib dir) However, is there some way I can build a 3.

RE: MySQL 4.1.18 Client - FreeBSD Build

2006-02-23 Thread Don O';Neil
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only 4.0.7 or some such older version. Thanks! -Original Message- From: Julian C. Dunn [mailto:[EMAIL PROTECTED] Sent: Thursday, February 23, 2006 9:39 AM To: Don O'Neil Cc: mysql@lists.mysql.com Subject:

MySQL 4.1.18 Client - FreeBSD Build

2006-02-23 Thread Don O';Neil
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL 4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but none of the libmysqlclient files are present in the distribution. Do I need to download the sources and build it, or are the client files located