Is there a MySQL 5.4 Speed advantage for MyISAM tables?

I see MySQL 5.4 is
out. http://www.mysql.com/news-and-events/generate-article.php?id =1602

Sun claims there are speed improvements for Innodb and ClusterDb
tables, but is there any reason to upgrade if I'm only using MyISAM tables?
Also I didn't see a Windows binary download. Does this mean I have to
compile the source from one of the Linux distros? What compiler do I use?
TIA

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Where the hell did 5.4 come from?

Have I been in a coma or something?

WTF happened to 5.2 and 5.3? Hell, we're still on 5.0.51 and 5.1 just came
out a month or two ago right?

> -----Original Message-----
> From: mos [mailto:mos99@fastmail.fm]
> Sent: Thursday, April 30, 2009 7:40 AM
> To: mysql@lists.mysql.com
> Subject: Is there a MySQL 5.4 Speed advantage for MyISAM tables?
>
> I see MySQL 5.4 is
> out.
> http://www.mysql.com/news-and-events/generate-article.php?id =1602
>
> Sun claims there are speed improvements for Innodb and ClusterDb
> tables, but is there any reason to upgrade if I'm only using
> MyISAM tables?
> Also I didn't see a Windows binary download. Does this mean I have to
> compile the source from one of the Linux distros? What
> compiler do I use?
> TIA
>
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

SELECT of records that have a matching record in a many to many table

Can someone please help me with this one?

I'm trying to SELECT from a table only those records that have a record,
matching a search term, in a table related by a many to many
relationship. The many to many relationship is in a mapping/junction table.

Here's an example of what I have so far:

-=-=-=-=-=-=-=-=-=-=-=-=-

SELECT
`Notes`.`note_id`
FROM
`Notes`

INNER JOIN
`Notes__Districts`
ON
`Notes__Districts`.`note_id` = `Notes`.`note_id`

LEFT JOIN
`Districts`
ON
`Districts`.`district_id` = `Notes__Districts`.`district_id`

WHERE
`Districts`.`name` REGEXP 'bradford';

-=-=-=-=-=-=-=-=-=-=-=-=-

Hopefully someone can see what I'm trying to do here and point me in the
right direction :)

Maybe I need to use a subquery? I've got a feeling I can do this without
that but can't get my head round how to set up the JOINs in this case
with having to use three tables in the one query, I'm only used to two
tables at once.

I couldn't find any tutorials that cover this.

Thanks in advance,
Nigel


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Where the hell did 5.4 come from?

My thoughts exactly!

This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html

It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown 5.4 straight out without anyone even being
aware that it existed!

Hell, 6.0 is on its tenth release and it's still in alpha.

Like you say, it'd be interesting to see which blackhole 5.2 and 5.3
fell into...!

Andy

Daevid Vincent wrote:
> Have I been in a coma or something?
>
> WTF happened to 5.2 and 5.3? Hell, we're still on 5.0.51 and 5.1 just came
> out a month or two ago right?
>
>
>> -----Original Message-----
>> From: mos [mailto:mos99@fastmail.fm]
>> Sent: Thursday, April 30, 2009 7:40 AM
>> To: mysql@lists.mysql.com
>> Subject: Is there a MySQL 5.4 Speed advantage for MyISAM tables?
>>
>> I see MySQL 5.4 is
>> out.
>> http://www.mysql.com/news-and-events/generate-article.php?id =1602
>>
>> Sun claims there are speed improvements for Innodb and ClusterDb
>> tables, but is there any reason to upgrade if I'm only using
>> MyISAM tables?
>> Also I didn't see a Windows binary download. Does this mean I have to
>> compile the source from one of the Linux distros? What
>> compiler do I use?
>> TIA
>>
>> Mike
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
>>
>>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Where the hell did 5.4 come from?

Oracle owns the mess now. I assume the next release will be 5.11, followed=
by 5.11i, and then finally dropping of the 5 to be in line with how they m=
anager their os, leave it to just be 11i. To ensure it is smooth they will=
change the license and add $5k in suport costs.

________________________________________
From: Andy Shellam [andy-lists@networkmail.eu]
Sent: Thursday, April 30, 2009 2:19 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Where the hell did 5.4 come from?

My thoughts exactly!

This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html

It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown 5.4 straight out without anyone even being
aware that it existed!

Hell, 6.0 is on its tenth release and it's still in alpha.

Like you say, it'd be interesting to see which blackhole 5.2 and 5.3
fell into...!

Andy

Daevid Vincent wrote:
> Have I been in a coma or something?
>
> WTF happened to 5.2 and 5.3? Hell, we're still on 5.0.51 and 5.1 just cam=
e
> out a month or two ago right?
>
>
>> -----Original Message-----
>> From: mos [mailto:mos99@fastmail.fm]
>> Sent: Thursday, April 30, 2009 7:40 AM
>> To: mysql@lists.mysql.com
>> Subject: Is there a MySQL 5.4 Speed advantage for MyISAM tables?
>>
>> I see MySQL 5.4 is
>> out.
>> http://www.mysql.com/news-and-events/generate-article.php?id =3D1602
>>
>> Sun claims there are speed improvements for Innodb and ClusterDb
>> tables, but is there any reason to upgrade if I'm only using
>> MyISAM tables?
>> Also I didn't see a Windows binary download. Does this mean I have to
>> compile the source from one of the Linux distros? What
>> compiler do I use?
>> TIA
>>
>> Mike
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=3Ddaevid@daevid.com
>>
>>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgary@primeexalia.co=
m=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Where the hell did 5.4 come from?

Andy Shellam wrote:
> My thoughts exactly!
>
> This article might help:
> http://dev.mysql.com/tech-resources/articles/mysql-54.html
>
> It worries me though that 5.1 went through a large number of alpha
> releases, then a set of beta releases before the GA release came out.
> It looks like they've thrown 5.4 straight out without anyone even being
> aware that it existed!
>
> Hell, 6.0 is on its tenth release and it's still in alpha.
>
> Like you say, it'd be interesting to see which blackhole 5.2 and 5.3
> fell into...!
>
> Andy
>
> Daevid Vincent wrote:
>> Have I been in a coma or something?
>>
>> WTF happened to 5.2 and 5.3? Hell, we're still on 5.0.51 and 5.1 just
>> came
>> out a month or two ago right?
>>

What you now know as 6.0 was originally called 5.2. 5.3 was a very
short-lived test of an idea. It never made it to Alpha.

So, 5.4 is the next version in the 5.x line. It's a hybrid of 5.1 and
6.0 and is putting a lot of recent performance improvement suggestions
into practical use. It is not yet GA.

Because 5.1 is already GA, many of these suggestions could not be added
to that code without changing how it operates. The next version, 6.0,
will have several new core features that are still under development.
While these performance tweaks will be appearing in 6.0 its release date
for is still a ways out. That means that the quickest way to get the
faster code into our users hands is to produce an intermediate release,
5.4 !

More details will be coming out as the 5.4 matures.

--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Is there a MySQL 5.4 Speed advantage for MyISAM tables?

At 09:40 AM 4/30/2009, you wrote:
>I see MySQL 5.4 is
>out. http://www.mysql.com/news-and-events/generate-article.php?id =1602
>
>Sun claims there are speed improvements for Innodb and ClusterDb
>tables, but is there any reason to upgrade if I'm only using MyISAM tables?
>Also I didn't see a Windows binary download. Does this mean I have to
>compile the source from one of the Linux distros? What compiler do I use?
>TIA
>
>Mike

So I guess no one has tried 5.4 yet with MyISAM tables? I am glad to see in
5.4 they have implemented the Google patches to Innodb which should speed
up locking. But for MyISAM users, is there any advantage to switching to 5.4?

TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: SELECT of records that have a matching record in a many to many

If I understand your question correctly (and I'm really not sure about
that), you're using a LEFT JOIN where you actually want to use a RIGHT
JOIN.
Or you need to rewrite your query and set the tables in another order.

On Thu, Apr 30, 2009 at 23:01, Nigel Peck wro=
te:
>
> Can someone please help me with this one?
>
> I'm trying to SELECT from a table only those records that have a record,
> matching a search term, in a table related by a many to many relationship=
..
> The many to many relationship is in a mapping/junction table.
>
> Here's an example of what I have so far:
>
> -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
>
> SELECT
> `Notes`.`note_id`
> FROM
> `Notes`
>
> INNER JOIN
> `Notes__Districts`
> ON
> `Notes__Districts`.`note_id` =3D `Notes`.`note_id`
>
> LEFT JOIN
> `Districts`
> ON
> `Districts`.`district_id` =3D `Notes__Districts`.`district_id`
>
> WHERE
> `Districts`.`name` REGEXP 'bradford';
>
> -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
>
> Hopefully someone can see what I'm trying to do here and point me in the
> right direction :)
>
> Maybe I need to use a subquery? I've got a feeling I can do this without
> that but can't get my head round how to set up the JOINs in this case wit=
h
> having to use three tables in the one query, I'm only used to two tables =
at
> once.
>
> I couldn't find any tutorials that cover this.
>
> Thanks in advance,
> Nigel
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> =A0http://lists.mysql.com/mysql?unsub=3Dmartijn@crystal-labs .nl
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg