RE: Mysql Hogging all system resources

2007-04-13 Thread Don O'Neil
:[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 that MySQL is allowed

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 [mailto:[EMAIL PROTECTED

RE: Mysql Hogging all system resources

2007-04-13 Thread Don O'Neil
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: Mysql Hogging all system resources

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

Problem with query on 5.11

2006-10-20 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:

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: Why does

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 Filename list that have 9640 in them? How

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

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: Re: MySQL

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