github.com/cheng762/platon-go@v1.8.17-0.20190529111256-7deff2d7be26/ethdb/database.go (about) 1 // Copyright 2014 The go-ethereum Authors 2 // This file is part of the go-ethereum library. 3 // 4 // The go-ethereum library is free software: you can redistribute it and/or modify 5 // it under the terms of the GNU Lesser General Public License as published by 6 // the Free Software Foundation, either version 3 of the License, or 7 // (at your option) any later version. 8 // 9 // The go-ethereum library is distributed in the hope that it will be useful, 10 // but WITHOUT ANY WARRANTY; without even the implied warranty of 11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12 // GNU Lesser General Public License for more details. 13 // 14 // You should have received a copy of the GNU Lesser General Public License 15 // along with the go-ethereum library. If not, see <http://www.gnu.org/licenses/>. 16 17 package ethdb 18 19 import ( 20 "fmt" 21 "strconv" 22 "strings" 23 "sync" 24 "time" 25 26 "github.com/PlatONnetwork/PlatON-Go/log" 27 "github.com/PlatONnetwork/PlatON-Go/metrics" 28 "github.com/syndtr/goleveldb/leveldb" 29 "github.com/syndtr/goleveldb/leveldb/errors" 30 "github.com/syndtr/goleveldb/leveldb/filter" 31 "github.com/syndtr/goleveldb/leveldb/iterator" 32 "github.com/syndtr/goleveldb/leveldb/opt" 33 "github.com/syndtr/goleveldb/leveldb/util" 34 ) 35 36 const ( 37 writePauseWarningThrottler = 1 * time.Minute 38 ) 39 40 var OpenFileLimit = 64 41 42 type LDBDatabase struct { 43 fn string // filename for reporting 44 db *leveldb.DB // LevelDB instance 45 46 compTimeMeter metrics.Meter // Meter for measuring the total time spent in database compaction 47 compReadMeter metrics.Meter // Meter for measuring the data read during compaction 48 compWriteMeter metrics.Meter // Meter for measuring the data written during compaction 49 writeDelayNMeter metrics.Meter // Meter for measuring the write delay number due to database compaction 50 writeDelayMeter metrics.Meter // Meter for measuring the write delay duration due to database compaction 51 diskReadMeter metrics.Meter // Meter for measuring the effective amount of data read 52 diskWriteMeter metrics.Meter // Meter for measuring the effective amount of data written 53 54 quitLock sync.Mutex // Mutex protecting the quit channel access 55 quitChan chan chan error // Quit channel to stop the metrics collection before closing the database 56 57 log log.Logger // Contextual logger tracking the database path 58 } 59 60 // NewLDBDatabase returns a LevelDB wrapped object. 61 func NewLDBDatabase(file string, cache int, handles int) (*LDBDatabase, error) { 62 logger := log.New("database", file) 63 64 // Ensure we have some minimal caching and file guarantees 65 if cache < 16 { 66 cache = 16 67 } 68 if handles < 16 { 69 handles = 16 70 } 71 logger.Info("Allocated cache and file handles", "cache", cache, "handles", handles) 72 73 // Open the db and recover any potential corruptions 74 db, err := leveldb.OpenFile(file, &opt.Options{ 75 OpenFilesCacheCapacity: handles, 76 BlockCacheCapacity: cache / 2 * opt.MiB, 77 WriteBuffer: cache / 4 * opt.MiB, // Two of these are used internally 78 Filter: filter.NewBloomFilter(10), 79 }) 80 if _, corrupted := err.(*errors.ErrCorrupted); corrupted { 81 db, err = leveldb.RecoverFile(file, nil) 82 } 83 // (Re)check for errors and abort if opening of the db failed 84 if err != nil { 85 return nil, err 86 } 87 return &LDBDatabase{ 88 fn: file, 89 db: db, 90 log: logger, 91 }, nil 92 } 93 94 // Path returns the path to the database directory. 95 func (db *LDBDatabase) Path() string { 96 return db.fn 97 } 98 99 // Put puts the given key / value to the queue 100 func (db *LDBDatabase) Put(key []byte, value []byte) error { 101 return db.db.Put(key, value, nil) 102 } 103 104 func (db *LDBDatabase) Has(key []byte) (bool, error) { 105 return db.db.Has(key, nil) 106 } 107 108 // Get returns the given key if it's present. 109 func (db *LDBDatabase) Get(key []byte) ([]byte, error) { 110 dat, err := db.db.Get(key, nil) 111 if err != nil { 112 return nil, err 113 } 114 return dat, nil 115 } 116 117 // Delete deletes the key from the queue and database 118 func (db *LDBDatabase) Delete(key []byte) error { 119 return db.db.Delete(key, nil) 120 } 121 122 func (db *LDBDatabase) NewIterator() iterator.Iterator { 123 return db.db.NewIterator(nil, nil) 124 } 125 126 // NewIteratorWithPrefix returns a iterator to iterate over subset of database content with a particular prefix. 127 func (db *LDBDatabase) NewIteratorWithPrefix(prefix []byte) iterator.Iterator { 128 return db.db.NewIterator(util.BytesPrefix(prefix), nil) 129 } 130 131 func (db *LDBDatabase) Close() { 132 // Stop the metrics collection to avoid internal database races 133 db.quitLock.Lock() 134 defer db.quitLock.Unlock() 135 136 if db.quitChan != nil { 137 errc := make(chan error) 138 db.quitChan <- errc 139 if err := <-errc; err != nil { 140 db.log.Error("Metrics collection failed", "err", err) 141 } 142 db.quitChan = nil 143 } 144 err := db.db.Close() 145 if err == nil { 146 db.log.Info("Database closed") 147 } else { 148 db.log.Error("Failed to close database", "err", err) 149 } 150 } 151 152 func (db *LDBDatabase) LDB() *leveldb.DB { 153 return db.db 154 } 155 156 // Meter configures the database metrics collectors and 157 func (db *LDBDatabase) Meter(prefix string) { 158 // Initialize all the metrics collector at the requested prefix 159 db.compTimeMeter = metrics.NewRegisteredMeter(prefix+"compact/time", nil) 160 db.compReadMeter = metrics.NewRegisteredMeter(prefix+"compact/input", nil) 161 db.compWriteMeter = metrics.NewRegisteredMeter(prefix+"compact/output", nil) 162 db.diskReadMeter = metrics.NewRegisteredMeter(prefix+"disk/read", nil) 163 db.diskWriteMeter = metrics.NewRegisteredMeter(prefix+"disk/write", nil) 164 db.writeDelayMeter = metrics.NewRegisteredMeter(prefix+"compact/writedelay/duration", nil) 165 db.writeDelayNMeter = metrics.NewRegisteredMeter(prefix+"compact/writedelay/counter", nil) 166 167 // Create a quit channel for the periodic collector and run it 168 db.quitLock.Lock() 169 db.quitChan = make(chan chan error) 170 db.quitLock.Unlock() 171 172 go db.meter(3 * time.Second) 173 } 174 175 // meter periodically retrieves internal leveldb counters and reports them to 176 // the metrics subsystem. 177 // 178 179 // This is how a stats table look like (currently): 180 // Compactions 181 // Level | Tables | Size(MB) | Time(sec) | Read(MB) | Write(MB) 182 // -------+------------+---------------+---------------+---------------+--------------- 183 // 0 | 0 | 0.00000 | 1.27969 | 0.00000 | 12.31098 184 // 1 | 85 | 109.27913 | 28.09293 | 213.92493 | 214.26294 185 // 2 | 523 | 1000.37159 | 7.26059 | 66.86342 | 66.77884 186 // 3 | 570 | 1113.18458 | 0.00000 | 0.00000 | 0.00000 187 // 188 // This is how the write delay look like (currently): 189 // DelayN:5 Delay:406.604657ms Paused: false 190 // 191 // This is how the iostats look like (currently): 192 // Read(MB):3895.04860 Write(MB):3654.64712 193 func (db *LDBDatabase) meter(refresh time.Duration) { 194 // Create the counters to store current and previous compaction values 195 // index 0 -> current , index 1 -> previous 196 compactions := make([][]float64, 2) 197 for i := 0; i < 2; i++ { 198 compactions[i] = make([]float64, 3) 199 } 200 // Create storage for iostats. 201 var iostats [2]float64 202 203 // Create storage and warning log tracer for write delay. 204 var ( 205 delaystats [2]int64 206 lastWritePaused time.Time 207 ) 208 209 var ( 210 errc chan error 211 merr error 212 ) 213 214 // Iterate ad infinitum and collect the stats 215 for i := 1; errc == nil && merr == nil; i++ { 216 // Retrieve the database stats 217 stats, err := db.db.GetProperty("leveldb.stats") 218 if err != nil { 219 db.log.Error("Failed to read database stats", "err", err) 220 merr = err 221 continue 222 } 223 // Find the compaction table, skip the header 224 lines := strings.Split(stats, "\n") 225 for len(lines) > 0 && strings.TrimSpace(lines[0]) != "Compactions" { 226 lines = lines[1:] 227 } 228 if len(lines) <= 3 { 229 db.log.Error("Compaction table not found") 230 merr = errors.New("compaction table not found") 231 continue 232 } 233 lines = lines[3:] 234 235 // Iterate over all the table rows, and accumulate the entries 236 for j := 0; j < len(compactions[i%2]); j++ { 237 compactions[i%2][j] = 0 238 } 239 for _, line := range lines { 240 parts := strings.Split(line, "|") 241 if len(parts) != 6 { 242 break 243 } 244 for idx, counter := range parts[3:] { 245 value, err := strconv.ParseFloat(strings.TrimSpace(counter), 64) 246 if err != nil { 247 db.log.Error("Compaction entry parsing failed", "err", err) 248 merr = err 249 continue 250 } 251 compactions[i%2][idx] += value 252 } 253 } 254 // Update all the requested meters 255 if db.compTimeMeter != nil { 256 db.compTimeMeter.Mark(int64((compactions[i%2][0] - compactions[(i-1)%2][0]) * 1000 * 1000 * 1000)) 257 } 258 if db.compReadMeter != nil { 259 db.compReadMeter.Mark(int64((compactions[i%2][1] - compactions[(i-1)%2][1]) * 1024 * 1024)) 260 } 261 if db.compWriteMeter != nil { 262 db.compWriteMeter.Mark(int64((compactions[i%2][2] - compactions[(i-1)%2][2]) * 1024 * 1024)) 263 } 264 265 // Retrieve the write delay statistic 266 writedelay, err := db.db.GetProperty("leveldb.writedelay") 267 if err != nil { 268 db.log.Error("Failed to read database write delay statistic", "err", err) 269 merr = err 270 continue 271 } 272 var ( 273 delayN int64 274 delayDuration string 275 duration time.Duration 276 paused bool 277 ) 278 if n, err := fmt.Sscanf(writedelay, "DelayN:%d Delay:%s Paused:%t", &delayN, &delayDuration, &paused); n != 3 || err != nil { 279 db.log.Error("Write delay statistic not found") 280 merr = err 281 continue 282 } 283 duration, err = time.ParseDuration(delayDuration) 284 if err != nil { 285 db.log.Error("Failed to parse delay duration", "err", err) 286 merr = err 287 continue 288 } 289 if db.writeDelayNMeter != nil { 290 db.writeDelayNMeter.Mark(delayN - delaystats[0]) 291 } 292 if db.writeDelayMeter != nil { 293 db.writeDelayMeter.Mark(duration.Nanoseconds() - delaystats[1]) 294 } 295 // If a warning that db is performing compaction has been displayed, any subsequent 296 // warnings will be withheld for one minute not to overwhelm the user. 297 if paused && delayN-delaystats[0] == 0 && duration.Nanoseconds()-delaystats[1] == 0 && 298 time.Now().After(lastWritePaused.Add(writePauseWarningThrottler)) { 299 db.log.Warn("Database compacting, degraded performance") 300 lastWritePaused = time.Now() 301 } 302 delaystats[0], delaystats[1] = delayN, duration.Nanoseconds() 303 304 // Retrieve the database iostats. 305 ioStats, err := db.db.GetProperty("leveldb.iostats") 306 if err != nil { 307 db.log.Error("Failed to read database iostats", "err", err) 308 merr = err 309 continue 310 } 311 var nRead, nWrite float64 312 parts := strings.Split(ioStats, " ") 313 if len(parts) < 2 { 314 db.log.Error("Bad syntax of ioStats", "ioStats", ioStats) 315 merr = fmt.Errorf("bad syntax of ioStats %s", ioStats) 316 continue 317 } 318 if n, err := fmt.Sscanf(parts[0], "Read(MB):%f", &nRead); n != 1 || err != nil { 319 db.log.Error("Bad syntax of read entry", "entry", parts[0]) 320 merr = err 321 continue 322 } 323 if n, err := fmt.Sscanf(parts[1], "Write(MB):%f", &nWrite); n != 1 || err != nil { 324 db.log.Error("Bad syntax of write entry", "entry", parts[1]) 325 merr = err 326 continue 327 } 328 if db.diskReadMeter != nil { 329 db.diskReadMeter.Mark(int64((nRead - iostats[0]) * 1024 * 1024)) 330 } 331 if db.diskWriteMeter != nil { 332 db.diskWriteMeter.Mark(int64((nWrite - iostats[1]) * 1024 * 1024)) 333 } 334 iostats[0], iostats[1] = nRead, nWrite 335 336 // Sleep a bit, then repeat the stats collection 337 select { 338 case errc = <-db.quitChan: 339 // Quit requesting, stop hammering the database 340 case <-time.After(refresh): 341 // Timeout, gather a new set of stats 342 } 343 } 344 345 if errc == nil { 346 errc = <-db.quitChan 347 } 348 errc <- merr 349 } 350 351 func (db *LDBDatabase) NewBatch() Batch { 352 return &ldbBatch{db: db.db, b: new(leveldb.Batch)} 353 } 354 355 type ldbBatch struct { 356 db *leveldb.DB 357 b *leveldb.Batch 358 size int 359 } 360 361 func (b *ldbBatch) Put(key, value []byte) error { 362 b.b.Put(key, value) 363 b.size += len(value) 364 return nil 365 } 366 367 func (b *ldbBatch) Delete(key []byte) error { 368 b.b.Delete(key) 369 b.size += 1 370 return nil 371 } 372 373 func (b *ldbBatch) Write() error { 374 return b.db.Write(b.b, nil) 375 } 376 377 func (b *ldbBatch) ValueSize() int { 378 return b.size 379 } 380 381 func (b *ldbBatch) Reset() { 382 b.b.Reset() 383 b.size = 0 384 } 385 386 type table struct { 387 db Database 388 prefix string 389 } 390 391 // NewTable returns a Database object that prefixes all keys with a given 392 // string. 393 func NewTable(db Database, prefix string) Database { 394 return &table{ 395 db: db, 396 prefix: prefix, 397 } 398 } 399 400 func (dt *table) Put(key []byte, value []byte) error { 401 return dt.db.Put(append([]byte(dt.prefix), key...), value) 402 } 403 404 func (dt *table) Has(key []byte) (bool, error) { 405 return dt.db.Has(append([]byte(dt.prefix), key...)) 406 } 407 408 func (dt *table) Get(key []byte) ([]byte, error) { 409 return dt.db.Get(append([]byte(dt.prefix), key...)) 410 } 411 412 func (dt *table) Delete(key []byte) error { 413 return dt.db.Delete(append([]byte(dt.prefix), key...)) 414 } 415 416 func (dt *table) Close() { 417 // Do nothing; don't close the underlying DB. 418 } 419 420 type tableBatch struct { 421 batch Batch 422 prefix string 423 } 424 425 // NewTableBatch returns a Batch object which prefixes all keys with a given string. 426 func NewTableBatch(db Database, prefix string) Batch { 427 return &tableBatch{db.NewBatch(), prefix} 428 } 429 430 func (dt *table) NewBatch() Batch { 431 return &tableBatch{dt.db.NewBatch(), dt.prefix} 432 } 433 434 func (tb *tableBatch) Put(key, value []byte) error { 435 return tb.batch.Put(append([]byte(tb.prefix), key...), value) 436 } 437 438 func (tb *tableBatch) Delete(key []byte) error { 439 return tb.batch.Delete(append([]byte(tb.prefix), key...)) 440 } 441 442 func (tb *tableBatch) Write() error { 443 return tb.batch.Write() 444 } 445 446 func (tb *tableBatch) ValueSize() int { 447 return tb.batch.ValueSize() 448 } 449 450 func (tb *tableBatch) Reset() { 451 tb.batch.Reset() 452 }