Re: Mysql issue / crashing

2011-04-19 Thread Suresh Kuna
Install the latest version of mysql on top of the current version and start the database. On Tue, Apr 19, 2011 at 9:34 PM, Brent Clark wrote: > Thanks for replying > > 5.1.55 > > > On 19/04/2011 13:55, Suresh Kuna wrote: > > What is the version of MYSQL you are using currently ? > > On Tue, Apr

InnoDB and Memory Allocation

2011-04-19 Thread Johnny Withers
I hope someone can help me out here. I'm having trouble with some new servers and memory allocation. Some basic specs on the servers: 32GB total mem 2GB swap 64-bit RHEL 64-bit mysqld overcommit_memory=2 mysql fails to start with 14GB innodb_buffer_pool_size mysql will start with 12GB buffer pool

Re: Mysql issue / crashing

2011-04-19 Thread Brent Clark
Thanks for replying 5.1.55 On 19/04/2011 13:55, Suresh Kuna wrote: What is the version of MYSQL you are using currently ? On Tue, Apr 19, 2011 at 3:46 PM, Brent Clark mailto:brentgclarkl...@gmail.com>> wrote: Ive added innodb_force_recovery=4 Still no go. Origin

Re: Mysql issue / crashing

2011-04-19 Thread Suresh Kuna
What is the version of MYSQL you are using currently ? On Tue, Apr 19, 2011 at 3:46 PM, Brent Clark wrote: > Ive added > > innodb_force_recovery=4 > > Still no go. > > > Original Message > Subject:Mysql issue / crashing > Date: Tue, 19 Apr 2011 12:15:30 +0200 > From:

Fwd: Mysql issue / crashing

2011-04-19 Thread Brent Clark
Ive added innodb_force_recovery=4 Still no go. Original Message Subject:Mysql issue / crashing Date: Tue, 19 Apr 2011 12:15:30 +0200 From: Brent Clark To: mysql@lists.mysql.com Hiya Im getting the following I ran myisamchk --silent --force */*.MYI But st

Mysql issue / crashing

2011-04-19 Thread Brent Clark
Hiya Im getting the following I ran myisamchk --silent --force */*.MYI But still I get the following. I cant see how I can bring Mysql up. # mysqld 110419 12:13:22 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER''