MySQL University session on December 3: Practical Full-Text Search in MySQL

2009-12-02 Thread Stefan Hinz
Practical Full-Text Search in MySQL http://forge.mysql.com/wiki/Practical_Full-Text_Search_in_MySQL This Thursday (December 3rd, 16:00 UTC – note the different time), Bill Karwin will talk about Practical Full-Text Search in MySQL. He'll introduce and compare five different approaches of full-text

Re: MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-12-02 Thread Steve Pincaud
Hi, As I did not get any reply, I started to install the mysql-5.4.3-beta osx10.5-x86_64 build on My Snow Leopard 10.6.2 64 bits , and I wanted to share my user experience with you :) the installation went well (logged as a normal user) though there were not any mysql user created on my OS, all f

Can't specify "--defaults-file" on Windows

2009-12-02 Thread mos
I'm trying to explicitly specify the location of the my.ini file on Windows XP I'm using: u:\mysql5.1\bin\mysqld --install --defaults-file="u:\\mysql5.1\\my.ini" and it complains "Failed to install the service (Couldn't create service)" I've tried "/" and "\" and "\\" but nothing seems to fix i

Re: How can I improve this query?

2009-12-02 Thread Tom Worster
On 12/2/09 11:13 AM, "David Shere" wrote: > Tom Worster wrote: >> how about using LEFT JOIN: >> >> SELECT ... >> FROM listings a >> LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber > > This gives me a result set of 456,567 lines. I'm looking for a result > set of 60-70 lines. (That's h

Re: How can I improve this query?

2009-12-02 Thread mos
At 10:13 AM 12/2/2009, you wrote: Tom Worster wrote: > how about using LEFT JOIN: > > SELECT ... > FROM listings a > LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber This gives me a result set of 456,567 lines. I'm looking for a result set of 60-70 lines. (That's how many part numbers w

Re: How can I improve this query?

2009-12-02 Thread David Shere
Tom Worster wrote: > how about using LEFT JOIN: > > SELECT ... > FROM listings a > LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber This gives me a result set of 456,567 lines. I'm looking for a result set of 60-70 lines. (That's how many part numbers we have.) > and for speed, does Tra