(Have been running mysql and dbchecks last couple of days...)
On Tue, 14 Aug 2007, Drew Bentley wrote:
I've just encountered this message on my system. I can understand it on MyISAM, but I thought InnoDB had no upper limits. Does anyone have experience and recovery pointers?Perhaps InnoDB was or is specified in your my.cnf file.
It is, although MyISAM is default. All the bacula tables are Inno.
What does "show innodb status" give you? Find out what tables or databases are using it to dig a little deeper.
I've attached the output, but don't really know enough about Inno internals to make much comment....
Status \n=====================================\n070816 14:35:00 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 35 seconds\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 201367, signal count 201363\nMutex spin waits 4963249, rounds 5871077, OS waits 40562\nRW-shared spins 173736, OS waits 83550; RW-excl spins 131546, OS waits 69710\n------------\nTRANSACTIONS\n------------\nTrx id counter 0 502848895\nPurge done for trx's n:o < 0 502848895 undo n:o < 0 0\nHistory list length 2\nTotal number of lock structs in row lock hash table 0\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 0 0, not started, process no 8092, OS thread id 1147570528\nMySQL thread id 6, query id 593072 localhost root\nshow innodb status\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for i/o request (insert buffer thread)\nI/O thread 1 state: waiting for i/o request (log thread)\nI/O thread 2 state: waiting for i/o request (read thread)\nI/O thread 3 state: waiting for i/o request (write thread)\nPending normal aio reads: 0, aio writes: 0,\n ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\nPending flushes (fsync) log: 0; buffer pool: 0\n1638489 OS file reads, 599527 OS file writes, 957 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf for space 0: size 1, free list len 15230, seg size 15232, is empty\nIbuf for space 0: size 1, free list len 15230, seg size 15232,\n0 inserts, 0 merged recs, 0 merges\nHash table size 4425293, used cells 3918006, node heap has 14127 buffer(s)\n0.00 hash searches/s, 0.00 non-hash searches/s\n---\nLOG\n---\nLog sequence number 39 3867858362\nLog flushed up to 39 3867858362\nLast checkpoint at 39 3867858362\n0 pending log writes, 0 pending chkp writes\n593279 log i/o's done, 0.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal memory allocated 2358002660; in additional pool allocated 11091712\nBuffer pool size 131072\nFree buffers 1\nDatabase pages 116944\nModified db pages 0\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages read 8093129, created 4896, written 20771\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\nMain thread process no. 8092, id 1147169120, state: waiting for server activity\nNumber of rows inserted 0, updated 0, deleted 592918, read 1333829373\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
