RE: Performance - Jonathan Miller - com.mysql.lists.cluster

11 messages in com.mysql.lists.clusterRE: Performance

From	Sent On	Attachments
Manuel Jenne	29 Jun 2005 14:50
Simon Garner	29 Jun 2005 15:33
Jonathan Miller	29 Jun 2005 15:50
Simon Garner	29 Jun 2005 16:03
Jonathan Miller	29 Jun 2005 16:14
Stewart Smith	29 Jun 2005 20:09
Mikael Ronström	30 Jun 2005 00:48
Manuel Jenne	30 Jun 2005 01:12	.bench, .bench
Stewart Smith	30 Jun 2005 03:16
Manuel Jenne	30 Jun 2005 03:33
Mikael Ronström	30 Jun 2005 05:23

Subject:	RE: Performance
From:	Jonathan Miller (jmil...@mysql.com)
Date:	06/29/2005 04:14:23 PM
List:	com.mysql.lists.cluster

Simon,

Disk based is on the radar. I am thinking 5.1 time frame.

If you can pass me some examples of the joins that cause you grief, I will be happy to test them, bug them and follow them through to patch.

Have you tried 5.0 with the alter table?

If you have other examples or issues, please let me know.

And feel free to vent to me anytime ;-) JBM

-----Original Message----- From: Simon Garner [mailto:sgar...@expio.co.nz] Sent: Wednesday, June 29, 2005 6:04 PM To: Jonathan Miller Cc: clus...@lists.mysql.com Subject: Re: Performance

Hi Jonathan,

On 30/06/2005 10:50 a.m., Jonathan Miller wrote:

Simon,

Maybe you would like to give me examples of "basic MySQL functionality" that you feel is missing are not up to par?

We are away looking to improve.

Thanks JBM

I was mostly referring to the problems with it choosing the wrong indexes for JOINs and putting JOINs in the wrong order sometimes. This has just been causing me a lot of issues today so I felt like venting ;)

Also problematic is how it deals with ALTER TABLE by dropping and recreating the table, which requires all the SQL nodes (except one) to be shut down first to avoid table corruption.

Sorely missing as well, though not really "basic" functionality, are FULLTEXT indexes and foreign key support.

Disk-based tables will also be nice!

cheers -Simon