This forum is no longer active. Please post your questions to our new community site

help plz! mysql stop automaticlly```

Subscribe to help plz! mysql stop automaticlly``` 2 post(s), 2 voice(s)

 
Avatar light123 16 post(s)

i really don’t know why mysql will stop after about one day.
here is mysqld.log
Killed
110406 16:07:45 mysqld_safe Number of processes running now: 0
110406 16:07:45 mysqld_safe mysqld restarted
110406 16:07:46 [Warning] ‘—skip-locking’ is deprecated and will be removed in a future release. Please$
[Warning] ‘—skip-locking’ is deprecated and will be removed in$
110407 2:10:54 [Note] Plugin ‘FEDERATED’ is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.9G 1.1G 8.3G 12% /
none 291M 108K 291M 1% /dev
none 316M 0 316M 0% /dev/shm
none 316M 48K 316M 1% /var/run
none 316M 0 316M 0% /var/lock
none 316M 0 316M 0% /lib/init/rw
below is bitnami stack stoped status:
total used free shared buffers cached
Mem: 646172 139944 506228 0 31996 51328
-/+ buffers/cache: 56620 589552

this is bitnami stack started status(after about 1h):
total used free shared buffers cached
Mem: 646172 498620 147552 0 35148 99864
-/+ buffers/cache: 363608 282564
Swap: 0 0 0
and this is my.cnf changed and restart status:
total used free shared buffers cached
Mem: 646172 347536 298636 0 32528 55024
-/+ buffers/cache: 259984 386188
Swap: 0 0 0

and from phpmyadmin(after mysql start 15 minutes):
Innodb_buffer_pool_reads 192
Handler_read_rnd 3499
Handler_read_rnd_next 12k
Created_tmp_disk_tables 194
Opened_tables 29

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

Replied at https://bitnami.com/forums/forums/bitnami-cloud/…