MySQL Forums
Forum List  »  Partitioning

Create Table Partition By xx - causes hung client.
Posted by: J Jorgenson
Date: February 22, 2006 02:58PM

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 --

Options: ReplyQuote


Subject
Views
Written By
Posted
Create Table Partition By xx - causes hung client.
3762
February 22, 2006 02:58PM


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.