Re: MySQL server has gone away

2011-05-26 Thread Claudio Nanni
'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: > I had experience with such type of error, It was due lack of resources > available to MySql, max connections exceeds on the server. > you can write a simple scr

Re: Changing the default database location

2011-05-26 Thread Reindl Harald
PLEASE do not reply to the list and some peopole on the list mailing-list is really enough Am 26.05.2011 23:49, schrieb Prabhat Kumar: >> >> The reason to move database onto the network is that multiple user can >> access it. Do you think there is a better alternative? >> > > shared storage devic

Re: Changing the default database location

2011-05-26 Thread Prabhat Kumar
> > The reason to move database onto the network is that multiple user can > access it. Do you think there is a better alternative? > shared storage device with MySQL does not work. Perheps it will corrupt datafile. Not sure what do mean by 'multiple user can access' ; Once mysql install you can c

Re: MySQL server has gone away

2011-05-26 Thread Prabhat Kumar
I had experience with such type of error, It was due lack of resources available to MySql, max connections exceeds on the server. you can write a simple script which will grab and store output of 'show processlist' every min. and later you cna investigate the issue. On Wed, May 25, 2011 at 3:34 A

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

2011-05-26 Thread Prabhat Kumar
Yes, InnoDB is the default storage engine for MySQL as of MySQL 5.5.MyISAM and InnoDB has its own features. InnoDB probably the best RDBMS out there. InnoDB is default engine might be due nowadays most of the application required fully ACID-compliant modes, self recovery from a crash, and many mo