title: MySQL keeps crashing
body: <p>I Have a server in the cloud running Ubuntu 12.10, with 512Mb of RAM just to run a wordpress website (with approx 1000 visits/day).</p>
  
  <p>MySQL was always crashing then I enabled a 4Gb swap to see if can works... but still crashing... and I need to restart the service every time...</p>
  
  <p>Checking the error log from mysql I noticed that InnoDB appears to be in a loop trying to recover something but I think it can't... can anyone help me?</p>
  
  <pre><code>131009 17:56:57 InnoDB: 5.5.32 started; log sequence number 242183133
  131009 17:56:57 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  131009 17:56:57 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  131009 17:56:57 [Note] Server socket created on IP: '127.0.0.1'.
  131009 17:56:57 [Note] Event Scheduler: Loaded 0 events
  131009 17:56:57 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.5.32-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  131009 17:57:25 [Note] Plugin 'FEDERATED' is disabled.
  131009 17:57:25 InnoDB: The InnoDB memory heap is disabled
  131009 17:57:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  131009 17:57:25 InnoDB: Compressed tables use zlib 1.2.7
  131009 17:57:25 InnoDB: Using Linux native AIO
  131009 17:57:25 InnoDB: Initializing buffer pool, size = 128.0M
  131009 17:57:25 InnoDB: Completed initialization of buffer pool
  131009 17:57:25 InnoDB: highest supported file format is Barracuda.
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: the log sequence number in the ib_logfiles!
  131009 17:57:25  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  131009 17:57:26  InnoDB: Waiting for the background threads to start
  131009 17:57:27 InnoDB: 5.5.32 started; log sequence number 242183133
  131009 17:57:27 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  131009 17:57:27 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  131009 17:57:27 [Note] Server socket created on IP: '127.0.0.1'.
  131009 17:57:27 [Note] Event Scheduler: Loaded 0 events
  131009 17:57:27 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.5.32-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  131009 17:58:05 [Note] Plugin 'FEDERATED' is disabled.
  131009 17:58:05 InnoDB: The InnoDB memory heap is disabled
  131009 17:58:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  131009 17:58:05 InnoDB: Compressed tables use zlib 1.2.7
  131009 17:58:05 InnoDB: Using Linux native AIO
  131009 17:58:05 InnoDB: Initializing buffer pool, size = 128.0M
  131009 17:58:05 InnoDB: Completed initialization of buffer pool
  131009 17:58:06 InnoDB: highest supported file format is Barracuda.
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: The log sequence number in the ib_logfiles!
  131009 17:58:06  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  131009 17:58:06  InnoDB: Waiting for the background threads to start
  131009 17:58:07 InnoDB: 5.5.32 started; log sequence number 242183143
  131009 17:58:07 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  131009 17:58:07 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  131009 17:58:07 [Note] Server socket created on IP: '127.0.0.1'.
  131009 17:58:07 [Note] Event Scheduler: Loaded 0 events
  131009 17:58:07 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.5.32-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  131009 17:58:33 [Note] Plugin 'FEDERATED' is disabled.
  131009 17:58:33 InnoDB: The InnoDB memory heap is disabled
  131009 17:58:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  131009 17:58:33 InnoDB: Compressed tables use zlib 1.2.7
  131009 17:58:33 InnoDB: Using Linux native AIO
  131009 17:58:33 InnoDB: Initializing buffer pool, size = 128.0M
  131009 17:58:34 InnoDB: Completed initialization of buffer pool
  131009 17:58:34 InnoDB: highest supported file format is Barracuda.
  InnoDB: Log scan progressed past the checkpoint lsn 242183143
  131009 17:58:34  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  InnoDB: Doing recovery: scanned up to log sequence number 242183153
  131009 17:58:34  InnoDB: Waiting for the background threads to start
  131009 17:58:35 InnoDB: 5.5.32 started; log sequence number 242183153
  131009 17:58:35 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  131009 17:58:35 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  131009 17:58:35 [Note] Server socket created on IP: '127.0.0.1'.
  131009 17:58:35 [Note] Event Scheduler: Loaded 0 events
  131009 17:58:35 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.5.32-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  131009 17:58:44 [Note] Plugin 'FEDERATED' is disabled.
  131009 17:58:44 InnoDB: The InnoDB memory heap is disabled
  131009 17:58:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  131009 17:58:44 InnoDB: Compressed tables use zlib 1.2.7
  131009 17:58:44 InnoDB: Using Linux native AIO
  131009 17:58:45 InnoDB: Initializing buffer pool, size = 128.0M
  131009 17:58:45 InnoDB: Completed initialization of buffer pool
  131009 17:58:45 InnoDB: highest supported file format is Barracuda.
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: The log sequence number in the ib_logfiles!
  131009 17:58:45  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  131009 17:58:45  InnoDB: Waiting for the background threads to start
  131009 17:58:47 [Note] Plugin 'FEDERATED' is disabled.
  131009 17:58:47 InnoDB: The InnoDB memory heap is disabled
  131009 17:58:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  131009 17:58:47 InnoDB: Compressed tables use zlib 1.2.7
  131009 17:58:47 InnoDB: Using Linux native AIO
  131009 17:58:47 InnoDB: Initializing buffer pool, size = 128.0M
  131009 17:58:47 InnoDB: Completed initialization of buffer pool
  131009 17:58:47 InnoDB: highest supported file format is Barracuda.
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: The log sequence number in the ib_logfiles!
  131009 17:58:47  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  131009 17:58:47  InnoDB: Waiting for the background threads to start
  131009 17:58:48 InnoDB: 5.5.32 started; log sequence number 242183153
  131009 17:58:48 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  131009 17:58:48 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  131009 17:58:48 [Note] Server socket created on IP: '127.0.0.1'.
  131009 17:58:48 [Note] Event Scheduler: Loaded 0 events
  131009 17:58:48 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.5.32-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  </code></pre>