mysql service script does not allow enough time for preallocation of a large gcache.size
Bug #1207500 reported by
Marc Castrovinci
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Raghavendra D Prabhu | |||
5.6 |
Fix Released
|
Undecided
|
Raghavendra D Prabhu |
Bug Description
When setting gcache.size to a larger value than the default 128M, the mysql service command does not allow enough time for the file to be preallocated.
To repeat:
Set wsrep_provider_
run: service mysql bootstrap-pxc ( or start )
The service will report failed while the file is still being written. This is very problematic in a chef recipe as it reports failed causing chef to stop.
To post a comment you must log in.
Marc,
The pre-allocation is done with posix_fallocate which is O(1) on
most filesystems - ie. the time to preallocate is independent of
size.
Now, when posix_fallocate fails, the fallback is to physically
write zeroes to the file which can be very time consuming.
What is the filesystem where the datadir is located and which
distro is this. Seems like posix_fallocate is not supported on
that platform.