Re: MySql crashes
Posted by:
Wim Roffel
Date: March 16, 2016 11:06AM
Thank you for your reaction.
It is a VPS with 1 GB memory.
With "show engine innodb status \G" I get:
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 135987200; in additional pool allocated 0
Dictionary memory allocated 1811060
Buffer pool size 8192
Free buffers 3412
Database pages 4703
Old database pages 1756
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4697, created 6, written 3265
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4703, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
top gives:
KiB Mem: 1025980 total, 761268 used, 264712 free, 38788 buffers
KiB Swap: 0 total, 0 used, 0 free. 420380 cached Mem
My my.cnf is rather short (it is the default as installed by Virtualmin) and the only innodb entry that is contains is:
innodb_file_per_table = 1