InnoDB lchange log file size
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
Re: InnoDB lchange log file size
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 important? Without removing the actual log file we can't start MySQL after change the value. Rafal Kedziorski [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 100663296 bytes InnoDB: than specified in the .cnf file 0 134217728 bytes! 041210 13:27:40 [ERROR] Can't init databases 041210 13:27:40 [ERROR] Aborting 041210 13:27:40 [Note] /usr/local/libexec/mysqld: Shutdown complete 041210 13:27:40 mysqld ended Does anybody knows how can I do it? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Increasing the InnoDB log file size
Hi, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Thanks Anil NOC -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:08 PM To: [EMAIL PROTECTED] 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 100663296 bytes InnoDB: than specified in the .cnf file 0 134217728 bytes! 041210 13:27:40 [ERROR] Can't init databases 041210 13:27:40 [ERROR] Aborting 041210 13:27:40 [Note] /usr/local/libexec/mysqld: Shutdown complete 041210 13:27:40 mysqld ended Does anybody knows how can I do it? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing the 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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Increasing the InnoDB log file size
if mysql shutdowns cleanly. then there is no chance of loosing data. for safe side take compleate database backup. -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:39 PM To: Anil Doppalapudi; [EMAIL PROTECTED] Subject: Re: Increasing the 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 List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Increasing the InnoDB log file size
Hello, I had the same issue myself, i read the manual and there says that you have to stop mysql, then change the parameter in my.cnf, then i moved to another directory the log file just to be cautious, and then restarted mysql. Everything went right. Best regards Alejandro -Mensaje 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 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 file 0 134217728 bytes! 041210 13:27:40 [ERROR] Can't init databases 041210 13:27:40 [ERROR] Aborting 041210 13:27:40 [Note] /usr/local/libexec/mysqld: Shutdown complete 041210 13:27:40 mysqld ended Does anybody knows how can I do it? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing the InnoDB log file size
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.mysql.com/[EMAIL PROTECTED]
Replication Binary Log File Size
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 to dedicated T-1's. I can't easily use the 'real' replication and have written some PERL scripts to check every few minutes to see if there is data in a binary replication log file and 'mysqlbinlog' dump out that data, send it up to the web server, and flush that log file. Very consistent and reliable on 3.23.x but I've started using 4.0.4 at a few places and the binary log file sizes aren't consistent. I'm wondering if that is incidental to something or intentional or something I'll never again be able to count on or what? Example: -rw-rw1 mysqlmysql 46 Nov 27 06:00 srv-bin.036 -rw-rw1 mysqlmysql 46 Nov 27 06:30 srv-bin.037 -rw-rw1 mysqlmysql 46 Nov 27 07:00 srv-bin.038 -rw-rw1 mysqlmysql 46 Nov 27 07:30 srv-bin.039 -rw-rw1 mysqlmysql 46 Nov 27 08:00 srv-bin.040 -rw-rw1 mysqlmysql6233 Nov 27 08:30 srv-bin.041 -rw-rw1 mysqlmysql 46 Nov 27 09:00 srv-bin.042 -rw-rw1 mysqlmysql9502 Nov 27 09:30 srv-bin.043 -rw-rw1 mysqlmysql4939 Nov 27 09:35 srv-bin.044 -rw-rw1 mysqlmysql1426 Nov 27 09:30 srv-bin.index The srv-bin.index file contains a list of all the binary log files in sequence. I just 'tail' off the bottom line which points to srv-bin.044 which I then check the file size of. If in this case it's 46 bytes I'll assume it's empty and contains no new inserts, updates or deletes. On a different server this size though is 45 and after doing a flush master the file is 79 bytes and at other times it appears to be 4 bytes. Instead of checking file size, is there some other easy mechanism of checking a server to see if there is anything currently logged in the binary log waiting to be replicated? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Log file size
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 my log partition which causes all kinds of Bad things to happen. I don't want to reduce the log detail, because normally my logs are just fine, just would like to be able to suspend logging when there is only x% of disk space left. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Log file size
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 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 my log partition which causes all kinds of Bad things to happen. I don't want to reduce the log detail, because normally my logs are just fine, just would like to be able to suspend logging when there is only x% of disk space left. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Log file size
Kenneth Kopelson wrote: Look into the Linux logrotate daemon. It allows you to configure what happens with logs. That would work if the problem I'm looking to solve was predictable - i.e. I have a busy site and I run logrotate three times a day to make sure the logs haven't gotten too big. The problem I'm trying to solve is to avoid someone (either accidentally or intentionally) doing an unexpected DOS on any services that requires space on the log device to function correctly (i.e. kernel accounting, exim, mySQL, etc.) by making mySQL log 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 redo logs based upon their size so I know what the absolute maximum total size of the logs will ever be and can provide space for them. My main concern here (and maybe I should report this to the bugs list) is that someone could DOS a server running mySQL fairly easily by hammering away at a dynamic Web page. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php