Re: Create Table Partition By xx - causes hung client.

[Mikael Ronström]

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