Bug #23737 | CREATE TABLESPACE without INITIAL_SIZE creates datafile with random size | ||
---|---|---|---|
Submitted: | 27 Oct 2006 21:09 | Modified: | 15 Mar 2007 0:31 |
Reporter: | Roland Bouman | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
Version: | 5.1.13 bk | OS: | Linux (ubuntu dapper drake) |
Assigned to: | Jon Stephens | CPU Architecture: | Any |
Tags: | CREATE TABLESPACE, Datafile, INITIAL_SIZE |
[27 Oct 2006 21:09]
Roland Bouman
[4 Dec 2006 9:52]
Jonas Oreland
Hi, I could not reproduce this to my big surprise. I run a 1-node cluster. Also from looking at code, there is a default value of 128M /Jonas
[9 Feb 2007 21:12]
Serge Kozlov
This is can be reproduced for mysql-5.1.16-bk (cluster has 2 data nodes, 2 replicas). the size of datafile isn't random but ~134MB. mysql> create logfile group lg1 add undofile 'undofile.dat' initial_size=20M un do_buffer_size=10M engine=ndb; Query OK, 0 rows affected (9.79 sec) mysql> create tablespace ts1 add datafile 'datafile.dat' use logfile group lg1 engine=ndb; Query OK, 0 rows affected (57.00 sec)
[9 Feb 2007 22:13]
Roland Bouman
Hi Serge, thank you! Did you use a debug build? The filesize you report corresponds with what I think is the default, 128M. If this can be reproduced over and over with the same file size, we need to make a documentation request out of it to document the default value. Also the syntax production rule will need to reflect that the size specification is optional. Thank you!
[15 Mar 2007 0:23]
Jon Stephens
Okay, it's a docs bug. :) Changed category/status/severity/priority to Docs/Open/S2/P2. Reassigned to myself with Stefan as lead.
[15 Mar 2007 0:31]
Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products. Updated CREATE TABLESPACE info in 5.1 Manual as suggested. Thanks for the heads-up.