Create Table Partition By xx - causes hung client.
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 --
Subject
Views
Written By
Posted
Create Table Partition By xx - causes hung client.
4165
February 22, 2006 02:58PM
3272
February 23, 2006 09:00AM
2640
February 23, 2006 07:07PM
2587
February 24, 2006 03:47PM
2747
February 23, 2006 12:22PM
2401
February 23, 2006 03:56PM
2340
April 17, 2006 01:43AM
2177
April 17, 2006 11:06AM
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.