11 messages in com.mysql.lists.clusterRe: Performance
FromSent OnAttachments
Manuel Jenne29 Jun 2005 14:50 
Simon Garner29 Jun 2005 15:33 
Jonathan Miller29 Jun 2005 15:50 
Simon Garner29 Jun 2005 16:03 
Jonathan Miller29 Jun 2005 16:14 
Stewart Smith29 Jun 2005 20:09 
Mikael Ronström30 Jun 2005 00:48 
Manuel Jenne30 Jun 2005 01:12.bench, .bench
Stewart Smith30 Jun 2005 03:16 
Manuel Jenne30 Jun 2005 03:33 
Mikael Ronström30 Jun 2005 05:23 
Subject:Re: Performance
From:Simon Garner (sgar@expio.co.nz)
Date:06/29/2005 04:03:49 PM
List:com.mysql.lists.cluster

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