On OS X

2008-09-30 Thread J. Todd Slack
Hi All, On OS X, I have some Obj-C that creates NSTasks to execute some sql statements. What do I deploy on the client to make this work for them? I want to make it park of my package installer, but I dont know what pieces. Thoughts? -Jason -- MySQL General Mailing List For list archiv

Re: Consulting

2008-09-30 Thread Simon J Mudd
[EMAIL PROTECTED] (Database System) writes: > There were no any error message on console or in error log. > > The symptoms are > 1) the binary log file goes to /data/mysql/data/ dir, not as defined in > /data/mysql/log/ > 2) the binary log files name start with "mysql-bin", not as I defined in

Re: Many to many to too many relation.

2008-09-30 Thread Rob Wultsch
Responses inline... On Tue, Sep 30, 2008 at 9:21 AM, Weston, Craig (OFT) <[EMAIL PROTECTED]> wrote: > > Rob, > I tried this on the small test data, a larger data set and it appears to > make my day. I sincerely appreciate your willingness to help me out. > > I do have some questions, mostly so I c

RE: Many to many to too many relation.

2008-09-30 Thread Weston, Craig (OFT)
Rob, I tried this on the small test data, a larger data set and it appears to make my day. I sincerely appreciate your willingness to help me out. I do have some questions, mostly so I can understand how this works better: I was wondering what the lines: set odone = done; set done = odone; d

Re[5]: SELECT DISTINCT with ORDER BY implementation

2008-09-30 Thread Andrew Aksyonoff
Hello Michael, Tuesday, September 30, 2008, 8:00:36 PM, you wrote: Andrew>> However if the specific sorting algorithm is not stable it *might* MW> It's not stable; MySQL is using several different technics to MW> calculate GROUP BY and may thus return the rows in any order within MW> the group by.

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-30 Thread Ken Menzel
from http://dev.mysql.com/doc/refman/5.1/en/connecting.html On Unix, MySQL programs treat the hostname |localhost| specially, in a way that is likely different from what you expect compared to other network-based programs. For connections to |localhost|, MySQL programs attempt to connect to th

Re[4]: SELECT DISTINCT with ORDER BY implementation

2008-09-30 Thread Michael Widenius
Hi! > "Andrew" == Andrew Aksyonoff <[EMAIL PROTECTED]> writes: Andrew> Hello Sergey, Andrew> Monday, September 15, 2008, 10:41:31 PM, you wrote: >>> in MySQL but in general case it can't assume any order and will have >>> to re-sort the sub-select result by outer GROUP BY instead of inner >>

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-30 Thread Rene Fournier
Presently, I'm only using localhost for MySQL database user privileges, e.g., : [EMAIL PROTECTED] -- for all privileges on all databases Do I need to change the above if I add skip-name-resolve to my.cnf? (Since localhost is, I thought, not really part of DNS but just an alias for

RE: Many to many to too many relation.

2008-09-30 Thread Weston, Craig (OFT)
Wow, I do feel very lucky. I am only at the "this is a cursor" part. I sincerely appreciate your help. -Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 10:11 AM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: Many to ma

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-30 Thread Rene Fournier
So with skip-name-resolve in my.cnf (and MySQL restarted), it should be okay to have [EMAIL PROTECTED] in the GRANT table since localhost resolves without DNS lookup? Or do I need to specify [EMAIL PROTECTED] Sorry, just need to clarify this bit before changing a few things. Thanks again.

Re: Many to many to too many relation.

2008-09-30 Thread Rob Wultsch
Luck for you my vpn appears to be screwed up. Here is a stored proc I whipped up: Stored procedure: DROP PROCEDURE IF EXISTS s; delimiter // CREATE PROCEDURE s () BEGIN DECLARE done INT DEFAULT 0; DECLARE odone INT DEFAULT 0; DECLARE f1,f2 VA

Re: Many to many to too many relation.

2008-09-30 Thread Rob Wultsch
Peter. I did not ask the question. Go back to jail, do not pass go, do not collect $200. Craig, This problem sucks is kinda fun. Take a look at windowing functions. MySQL does not have them, but that would probable be the right way to deal with this. For MySQL I think something like the following

Re: Many to many to too many relation.

2008-09-30 Thread Peter Brawley
Rob, >I need the distinct, lowest values that relate to each other, >not necessarily in the same row. First, the data representation does not appear to represent the problem adequately. Second, I do not understand what "relate to each other, nor necessarily in the same row" means. Third, I do

RE: Many to many to too many relation.

2008-09-30 Thread Weston, Craig (OFT)
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, d

Re: Many to many to too many relation.

2008-09-30 Thread Rob Wultsch
I tried reading this and it took much brain power to do for free. I suggest breaking this down into the simplest possible example you can. Ideally have an create table statement, and insert with a small amount of data (as simple as possible), a simple psuedo code query and example output of what yo