RE: Table crashes

2007-10-23 Thread amarnath.shivashankar
Can someone help me out on this..I need a detailed document Regards, Amarnath Shivashankar SQL Database Management | GSMC | Wipro Infotech | Mysore | Toll free: 1800-345-5656 | Spirit of Wipro : Intensity to Win | Act with Sensitivity | Unyielding Integrity F

Table crashes

2007-10-22 Thread amarnath.shivashankar
Hi Friends, I need a document on why tables crash in MYSQL and what are the repair methods? I would also like to know if there are any preventive measures to avoid table crashes? Regards, Amarnath Shivashankar SQL Database Management The information contained in this electronic me

Re: Re: "Out of memory; check if mysqld or some other process uses all available memory;" error

2007-10-02 Thread amarnath.shivashankar
Hi Mathieu, I found that innodb_buffer pool value isn't set..The whole innodb settings are commented. I found the below values from the my.cnf file: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:10M:auto