MySQL Forums
Forum List  »  Partitioning

Re: Create Table Partition By xx - causes hung client.
Posted by: Mikael Ronström
Date: February 23, 2006 12:22PM

Hi,
I have no idea what the problem could be, seem to be a Windows-related problem. However if
you could start a debug version of the mysql server and create a trace file, then one could see
where it goes wrong. It is probably some error that happens and then for some
reason a response is not sent to the client. This is usually the case when the client hangs.

If you've done that you could create a bug report and upload the trace file to the bug reporting
system.

Rgrds Mikael

J Jorgenson wrote:
> Just installed 5.1.6 onto WinXP workstation to
> research partition tables for my employer.
> (mysqld-nt.exe == 5.1.6-alpha-nt-max)
>
> Problem: When trying to create a partitioned
> table, mysql client apps HANG (Browser & cmd
> line) waiting for a response from the (local)
> server.
>
> SHOW VARAIBLES like '%partition%';
> have_partitioning = YES
>
> CREATE TABLE t (
> id INT NOT NULL DEFAULT 0,
> seg INT NOT NULL DEFAULT 0,
> KEY(id))
> PARTITION BY HASH(seg)
> PARTITIONS 10;
>
>
> I've tried various other formats & types just
> to create 1 partitioned table.
> PARTITION BY LIST(seg) VALUES IN (1,2,etc...),
> PARTITION BY KEY(id),
> PARTITION BY....
> (I've got no issues when creating 'normal'
> tables).
>
> I've also tried creating a basic table.. no
> problem.
> Followed by an ALTER TABLE PARTITION BY xxxx....
> no response.
>
>
> Could it be a config issue?
> .EXE Build issue?
>
> Anyone have any ideas?
>
> -- j --

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Create Table Partition By xx - causes hung client.
2556
February 23, 2006 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.