Hello.
See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
>Hi,
>
> our logfile size is not set like:
>
> >Set the log file size to about 25% of the buffer pool size
>
> Could we remove the actual log file and set the new or is this
>
Hi,
our logfile size is not set like:
Set the log file size to about 25% of the buffer pool size
Could we remove the actual log file and set the new or is this important?
Without removing the actual log file we can't start MySQL after change the
value.
Regards,
Rafal
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
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
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
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
]
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
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
In 3.23.x versions of MySQL the actual binary log file sizes stayed
fairly consistent. An 'empty' log file for instance on 3.23.53a is 73
bytes. I have a situation where I'm doing a roll-your-own replication
from many sites to one central server where the remote sites are on
everything from dialup
a tremendous amount of data to its logs through rapid,
successive queries.
I was wondering if there was a way to have mySQL halt its logging
(similar to the way the kernel does) if the log device gets too full or
perhaps limit the total log file size. For example, Oracle will rotate a
fixed number of
Look into the Linux "logrotate" daemon. It allows you to configure what
happens with logs.
At 06:44 AM 6/6/01 -0400, Peter Billson wrote:
>I'm running mySQL on Linux and was wondering is there a way to limit the
>maximum log file size?
>
> From time to time I hav
I'm running mySQL on Linux and was wondering is there a way to limit the
maximum log file size?
From time to time I have written a bad script that will query mySQL in
a loop (BTW - mySQL can do *lots* of queries/second!) without me
realizing my mistake until I run out of room on m
12 matches
Mail list logo
