Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Fri, Aug 13, 2010 at 11:54:02AM -0700, Rob Wultsch wrote: > # file /usr/local/mysql/bin/mysqld > /usr/local/mysql/bin/mysqld: ELF 64-bit LSB executable, AMD x86-64, > version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared > libs), for GNU/Linux 2.4.0, not stripped > it is 64bit

Re: mysql is crashing

2010-08-13 Thread Rob Wultsch
On Fri, Aug 13, 2010 at 11:47 AM, Krishna Chandra Prajapati wrote: > Hi Yectli, > > I am talking about mysql server. Is it 32bit or 64bit. > > Provide some additional information. mysql configuration file, show > variables, Error log file details etc. > > Kirshna > > On Fri, Aug 13, 2010 at 8:36 P

Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Sat, Aug 14, 2010 at 12:17:20AM +0530, Krishna Chandra Prajapati wrote: > Hi Yectli, > > I am talking about mysql server. Is it 32bit or 64bit. > > Provide some additional information. mysql configuration file, show > variables, Error log file details etc. > > Kirshna > i provided the trace

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
Hi Yectli, I am talking about mysql server. Is it 32bit or 64bit. Provide some additional information. mysql configuration file, show variables, Error log file details etc. Kirshna On Fri, Aug 13, 2010 at 8:36 PM, Yectli Huerta wrote: > On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandr

Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandra Prajapati wrote: > Hi Yectli, > > In mysql configuration file (my.cnf) you have given > > key_buffer_size = 5G > > For 32bit OS it should be less than or equal to 4GB and for 64bit it can be > greater than 4GB. > Reduce the key_buffer_siz

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
Hi Yectli, In mysql configuration file (my.cnf) you have given key_buffer_size = 5G For 32bit OS it should be less than or equal to 4GB and for 64bit it can be greater than 4GB. Reduce the key_buffer_size to 3GB and try. _Kirshna On Fri, Aug 13, 2010 at 3:02 AM, Yectli Huerta wrote: > Hello,

mysql is crashing

2010-08-12 Thread Yectli Huerta
Hello, I compiled a version of mysql 5.1.49 and it crashed a couple of times already. I recompiled it with debug enabled and this is the error I got. Do any of you guys/gals have any suggestions? thanks, this is from the trace file: do_select: info: select cond 0xb7e088 do_select: info: select

re: MySQL is Crashing

2002-09-18 Thread Egor Egorov
Rajesh, Wednesday, September 18, 2002, 9:32:29 AM, you wrote: RK> I have written 2 scripts the first one which will ceate the schema and RK> second one will insert some rows into it. RK> The table type is BDB. RK> Scripts are something like this [skip] RK> If I run these scripts together repea

MySQL is Crashing

2002-09-18 Thread Rajesh Kanade
Hi All I have written 2 scripts the first one which will ceate the schema and second one will insert some rows into it. The table type is BDB. Scripts are something like this SCRIPT 1 DROP TABLE IF EXISTS ROLE; DROP DATABASE IF EXISTS ERECRUITER; CREATE DATABASE ERECRUITER; #Start using eRe