Re: a question about "innodb log file"

2006-01-18 Thread Gleb Paharenko
out different logs in manual but innodb log file. > > Please tell me where can i find it? > > What's innodb log file different to binlog? > > Where can i find data about redo and undo? > > thanks -- For technical support contracts, goto https://order.mysql.com/?re

a question about "innodb log file"

2006-01-18 Thread wangxu
There are many information about different logs in manual but innodb log file. Please tell me where can i find it? What's innodb log file different to binlog? Where can i find data about redo and undo? thanks

RE: Increasing the InnoDB log file size

2004-12-10 Thread Anil Doppalapudi
InnoDB log file size Anil, > First shutdown the mysql cleanly. > > #mysqladmin shutdown > > then drop log files in data directory. > > restart mysql. it will create new log files. Do you know if is there a risk of loosing any data? Thanks, Ronan -- MySQL General Mailing L

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil and Oropeza, > if mysql shutdowns cleanly. then there is no chance of loosing data. for > safe side take compleate database backup. Ok, thank you very much for your help. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

RE: Increasing the InnoDB log file size

2004-12-10 Thread Oropeza Querejeta, Alejandro
original- De: Ronan Lucio [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 10 de Diciembre de 2004 11:38 a.m. Para: [EMAIL PROTECTED] Asunto: Increasing the InnoDB log file size Hi, I need to increase the innodeb_log_file_size parameter, but when I set it higher, mysql don´t starts and give the

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil, > First shutdown the mysql cleanly. > > #mysqladmin shutdown > > then drop log files in data directory. > > restart mysql. it will create new log files. Do you know if is there a risk of loosing any data? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql

RE: Increasing the InnoDB log file size

2004-12-10 Thread Anil Doppalapudi
] Subject: Increasing the InnoDB log file size Hi, I need to increase the innodeb_log_file_size parameter, but when I set it higher, mysql don´t starts and give the follow erro: 041210 13:27:40 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0

Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Hi, I need to increase the innodeb_log_file_size parameter, but when I set it higher, mysql don´t starts and give the follow erro: 041210 13:27:40 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0 100663296 bytes InnoDB: than specified in the .cnf f

RV: Innodb log file

2004-10-29 Thread Oropeza Querejeta, Alejandro
Hi, How can i increase the size of the log file and log buffer size? i tried to change it on my.cnf file but it return this error message: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 041028 0:10:49 C

Re: Innodb log file

2004-10-28 Thread Eric Bergen
Check out this section in the manual on innodb log files. http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html -Eric On Thu, 28 Oct 2004 15:47:27 -0500, Oropeza Querejeta, Alejandro <[EMAIL PROTECTED]> wrote: > Hi, > > How can i increase the size of the log file and log buffer size? > >

Innodb log file

2004-10-28 Thread Oropeza Querejeta, Alejandro
Hi, How can i increase the size of the log file and log buffer size? i tried to change it on my.cnf file but it return this error message: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 041028 0:10:49 Can'