Re: MySQL-Max database recovery crashed - Fixed!

2001-11-03 Thread Michael Widenius
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: I will have to include a warning in the comments section of the MySQL documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE! I have now added a warning about this to the manual. Regards, Monty

MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
I converted my myISAM tables to Innodb format and everything went fine. When I restarted MySQL-Max (2.23.43) I noticed that my query log file was not being accessed anymore so I included log=/var/lib/mysql/server1.log to /etc/my.cnf. Running MySQL-Max this time though caused a continuous

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved the stack dump based on the 3.23.43 symbols file. I do not understand what mysqld is trying to do here. Are you sure the stack dump is from 3.23.43? 0x807b90f init_signals__Fv + 71 0x8253c7a __tfx + 26 0x80cf21a index_prev__11ha_innobasePc + 74 0x8078693

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved now with the mysql-max-3.23.44...tar.gz distribution. I still do not understand what mysqld is trying to do here. What distribution do you use, or did you compile yourself? 0x807b90f handle_segfault__Fi + 383 0x8253c7a pthread_sighandler + 106 0x80cf21a

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: Stephen, At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the

Re: MySQL-Max database recovery crashed - Fixed!

2001-11-02 Thread Stephen Lee
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: Stephen, At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Jeremy Zawodny
On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: I looked now what MySQL does when it calls lock_external at startup: it initializes MySQL system tables like 'host' and 'user'. I assume you have not converted MySQL system tables to InnoDB format? That is not allowed. They must

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Jeremy, At 11:37 PM 11/2/01 -0800, you wrote: On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: I looked now what MySQL does when it calls lock_external at startup: it initializes MySQL system tables like 'host' and 'user'. I assume you have not converted MySQL system tables to

Re: Max Database

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 06:21, Manish Mehta wrote: Hello Everyone, We are using MySQL as backend. What is Maximum size of MySQL Database? There is not limit on database size. Meanwhile there is a lot of limits which come from operating system you use. You have to read more:

Max Database

2001-10-04 Thread Manish Mehta
Hello Everyone, We are using MySQL as backend. What is Maximum size of MySQL Database? Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)