| Bug #26399 | Creating tablespace files takes very long | ||
|---|---|---|---|
| Submitted: | 15 Feb 2007 10:42 | Modified: | 15 Mar 2007 10:51 |
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Cluster: Disk Data | Severity: | S5 (Performance) |
| Version: | 5.1.15 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[15 Feb 2007 10:51]
Stewart Smith
what is the result of doing the same thing but with dd e.g. dd if=/dev/zero of=datafile bs=1024 count=8388608 (i think :) how fast does that happen?
[16 Mar 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Creating a tablespace file of 8 GB takes nearly 30 minutes How to repeat: CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 8192M ENGINE NDB; avg-cpu: %user %nice %system %iowait %idle 0.26 0.00 0.26 24.62 74.87 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util sda 0.00 0.00 0.00 217.35 0.00 13518.37 0.00 6759.18 62.20 1.04 4.76 4.66 101.22 [root@datanode-3 ndb_2_fs]# vmstat 1 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 0 1 0 4725356 332240 1261376 0 0 0 6688 1309 723 0 0 75 25 0 0 1 0 4725356 332248 1261368 0 0 0 6256 1349 795 0 0 75 25 0 0 1 0 4725356 332252 1261376 0 0 0 6752 1296 709 0 0 75 25 0 The system seems fully I/O bound and it looks like the creation process is doing random I/O.