RE: SLAVE aware of binary log file switch?

2013-06-17 Thread Rick James
may indicate a brief delay. > -Original Message- > From: Mihamina Rakotomandimby [mailto:miham...@rktmb.org] > Sent: Monday, June 17, 2013 5:35 AM > To: mysql@lists.mysql.com > Subject: Re: SLAVE aware of binary log file switch? > > On 2013-06-17 14:43, Denis Jedig w

Re: SLAVE aware of binary log file switch?

2013-06-17 Thread Mihamina Rakotomandimby
On 2013-06-17 14:43, Denis Jedig wrote: Say the binary log file (on the master) has reached its maximum size, so that it has to switch to a "+1" binary log file: does he inform the SLAVE of that switch so that the SLAVE updates its information about the MASTER status? The master does n

SLAVE aware of binary log file switch?

2013-06-17 Thread Mihamina Rakotomandimby
Hi all, Given a MASTER and a SLAVE. When launching the SLAVE, it knows about the binary log file used by the MASTER and the position in that log file. Say the binary log file (on the master) has reached its maximum size, so that it has to switch to a "+1" binary log file: does he

Re: SLAVE aware of binary log file switch?

2013-06-17 Thread Denis Jedig
Am 17.06.2013 13:11, schrieb Mihamina Rakotomandimby: Say the binary log file (on the master) has reached its maximum size, so that it has to switch to a "+1" binary log file: does he inform the SLAVE of that switch so that the SLAVE updates its information about the MASTER status?

Re: logrotate script doesn't create a new log file

2012-02-23 Thread Honza Horak
files in the directory where the log files are? This seems to be the reason. MySQL is run under mysql user and the log file is located under /var/log in Fedora, so the daemon doesn't have enough privileges. It's clear now, we'd need to un-comment the line in such configuratio

Re: logrotate script doesn't create a new log file

2012-02-22 Thread Johan De Meersman
- Original Message - > From: "Honza Horak" > > particular reason why the line is not used by default? Can't be bothered to go look at the script, but it should be doing a "flush logs" somewhere. The line is commented by default because MySQL will recreate it's logfiles automatically, a

logrotate script doesn't create a new log file

2012-02-22 Thread Honza Horak
Hi all, I'm thinking of logrotate script, that is shipped in mysql tar ball (e.g. mysql-5.5.20/support-files/mysql-log-rotate.sh). There is a commented line "# create 600 mysql mysql", that should originally ensure logrotate utility creates a new log file after rotatin

Re: PID and LOG file

2011-11-15 Thread Michael Dykman
mysqld_safe might not know where your config file is located. You can specify it's location at the command line with --defaults-file=file_name alternatively, you could specify the location of your log file thus: --log-error=file_name other options found at http://dev.mysql.com/doc/r

PID and LOG file

2011-11-15 Thread javad bakhshi
Hi, I am trying to install Mysql on linux which I don't have a root access. I have done the folowing : 1. Download source files from http://dev.mysql.com/downloads/mysql/ and un-tar thwm 2. configure the instalation using ./configure as:     CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructo

Re: mysql-bin log file

2010-04-19 Thread Johan De Meersman
On Mon, Apr 19, 2010 at 12:16 PM, Rob Wultsch wrote: > One way or another this > should be a conscious decision, not a copy and paste from a mailing > list. > As is the case with most settings :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt,

Re: mysql-bin log file

2010-04-19 Thread Rob Wultsch
On Mon, Apr 19, 2010 at 1:07 AM, Johan De Meersman wrote: > On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote: >> >> And if your slave's IO lags badly enough this will hose you. Further > > True, but if you remove logs that haven't been transferred, yet, you lose > your slave. > > Transfer of lo

Re: mysql-bin log file

2010-04-19 Thread Johan De Meersman
On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote: > > And if your slave's IO lags badly enough this will hose you. Further > True, but if you remove logs that haven't been transferred, yet, you lose your slave. Transfer of logs shouldn't be lagging that much, really, unless you're replicating

Re: mysql-bin log file

2010-04-18 Thread Rob Wultsch
On Sun, Apr 18, 2010 at 9:40 PM, Prabhat Kumar wrote: > You can  add a expire_logs_days Variable in my.cnf during the configuration > of replication server. > > # expire_logs_days = 7 > > It will purged binary logs older than 7 days.The old logs will be purged > during the next bin-log swittch. >

Re: mysql-bin log file

2010-04-18 Thread Prabhat Kumar
Apr 18, 2010 at 8:58 PM, Angelina Paul > wrote: > > How can I remove old mysql-bin log file in log directory? A mysql full > > backup will clear the old mysql bin log file or not? > > > > Thanks, > > Arshu Paul > > > You probably want > http://mysql2.mirr

Re: mysql-bin log file

2010-04-18 Thread Rob Wultsch
On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul wrote: > How can I remove  old  mysql-bin log file in log directory? A mysql full > backup will clear the old mysql bin log file or not? > > Thanks, > Arshu Paul > You probably want http://mysql2.mirrors-r-us.net/doc/refman/5

mysql-bin log file

2010-04-18 Thread Angelina Paul
How can I remove old mysql-bin log file in log directory? A mysql full backup will clear the old mysql bin log file or not? Thanks, Arshu Paul

Re: Install problem: log file issue

2009-02-13 Thread Paul DuBois
On Feb 12, 2009, at 6:28 PM, csego...@gmail.com wrote: Andy, Michael, and Walter - thank you! Adding a [mysqld_safe] group to my.cnf gets me further but the start still fails. The good thing is that the failure is no longer due to the inability to write the log file. The [mysqld_safe

Re: Install problem: log file issue

2009-02-12 Thread csego...@gmail.com
Andy, Michael, and Walter - thank you! Adding a [mysqld_safe] group to my.cnf gets me further but the start still fails. The good thing is that the failure is no longer due to the inability to write the log file. The [mysqld_safe] section of my.cnf reads: [mysqld_safe] port= 3306

Re: Install problem: log file issue

2009-02-12 Thread Walter Heck
I haven't looked into it in detail an don't have time right nw, but it is also hardcoded in mysqld_safe. I have seen a case where it had to be changed there to make it work. try that and please report back :) Walter OlinData: Professional services for MySQL Support * Consulting * Administration h

Re: Install problem: log file issue

2009-02-12 Thread csego...@gmail.com
Andy, Thanks for the suggestion. my_print_defaults mysqld indicates that it is reading my my.cnf. Furthermore, I have tried both the log and log-output variables in my.cnf with no success. Any other ideas? Thanks! C Andy Smith wrote: > It could be that your my.cnf isn't being read (permiss

Re: Install problem: log file issue

2009-02-12 Thread Andy Smith
It could be that your my.cnf isn't being read (permissions or in the wrong directory), or that you have multiple my.cnf files. Quoting "csego...@gmail.com" : That is intentional. I want to write the log to a non-standard location. --

Re: Install problem: log file issue

2009-02-12 Thread csego...@gmail.com
buffer_size = 8M >> datadir = /app/mysql/data >> #data_file_path = /app/mysql/data >> general_log = 1 >> general_log_file = /app/mysql/log/ >> socket = /app/mysql/var/mysql.sock >> log-error = /app/mysql/log/error.log >> >> I thought the ge

Re: Install problem: log file issue

2009-02-12 Thread fire9
/mysql.sock log-error = /app/mysql/log/error.log I thought the general_log_file variable would define the location of the log file, yet mysqld is trying to write the log file to a different directory. Does anyone have any suggestions on how to fix this? Thanks! Colin -- MySQL General Mailin

Install problem: log file issue

2009-02-12 Thread csego...@gmail.com
dir = /app/mysql/data #data_file_path = /app/mysql/data general_log = 1 general_log_file = /app/mysql/log/ socket = /app/mysql/var/mysql.sock log-error = /app/mysql/log/error.log I thought the general_log_file variable would define the location of the log file, yet mysqld is trying to write the log

Re: Rotate regular log file only

2008-10-23 Thread Moon's Father
You're wrong.The new log file will be generated when you flush logs manually. On Fri, Oct 24, 2008 at 2:23 AM, Olaf Stein < [EMAIL PROTECTED]> wrote: > And I assume you backup script also archives or removes the old log file, > because flush-logs does not start a new log file

Re: Rotate regular log file only

2008-10-23 Thread Andy Shellam
ote: And I assume you backup script also archives or removes the old log file, because flush-logs does not start a new log file if there is still one present On 10/23/08 2:20 PM, "Andy Shellam" <[EMAIL PROTECTED]> wrote: Hi Olaf, We use our mysqldump script to rotate the bin

Re: Rotate regular log file only

2008-10-23 Thread Olaf Stein
And I assume you backup script also archives or removes the old log file, because flush-logs does not start a new log file if there is still one present On 10/23/08 2:20 PM, "Andy Shellam" <[EMAIL PROTECTED]> wrote: > Hi Olaf, > > We use our mysqldump script to rota

Re: Rotate regular log file only

2008-10-23 Thread Andy Shellam
PM, "Uwe Kiewel" <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Olaf Stein schrieb: Hi all Is it possible to rotate just the regular (--log) log file? I am not sure if it will be safe, but maybe with logrotate and for /var/log/mysqld.lo

Re: Rotate regular log file only

2008-10-23 Thread Olaf Stein
---BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Olaf Stein schrieb: >> Hi all >> >> Is it possible to rotate just the regular (--log) log file? > > I am not sure if it will be safe, but maybe with logrotate and for > /var/log/mysqld.log the "copytruncate"

Re: Rotate regular log file only

2008-10-23 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Olaf Stein schrieb: > Hi all > > Is it possible to rotate just the regular (--log) log file? I am not sure if it will be safe, but maybe with logrotate and for /var/log/mysqld.log the "copytruncate" option for logrotate. > If

Rotate regular log file only

2008-10-23 Thread Olaf Stein
Hi all Is it possible to rotate just the regular (--log) log file? If I do flush-logs I have to tell my slaves that (at least I have done so in the past, maybe I don't and the slves realizes by itself?) Thanks Olaf - Confidentiality Notice: The foll

error log file permissions

2008-09-09 Thread Steve Holmes
Background: Solaris 10, MySQL 5.0.45. I have changed something recently that is causing the error log file to be created with mode 660. I would like for it it be mode 664. I admit that I recently changed the my.cnf file and added a log-error line which did not have the fully qualified path and

Why can't output to error log file when INNODB happened ERROR1205?

2006-08-10 Thread nakai
Why can't output to error log file when INNODB happened ERROR1205? All server error message is output to error log file, isn't it? -- create table test (id int ,name text)engine=innodb; insert into test values ( 1, 'test'); -- Pattern 1 -- CLIE

Why can't output to error log file when INNODB happened ERROR1205?

2006-08-10 Thread nakai
Why can't output to error log file when INNODB happened ERROR1205? All server error message is output to error log file, isn't it? -- create table test (id int ,name text)engine=innodb; insert into test values ( 1, 'test'); -- Pattern 1 -- CLIE

Re: about log file

2006-05-17 Thread sheeri kritzer
The short answer is "in the config file." The long answer is to read: http://dev.mysql.com/doc/refman/4.1/en/log-files.html Or whatever manual version is appropriate to your MySQL version. -Sheeri On 5/17/06, Peng Yi-fan <[EMAIL PROTECTED]> wrote: Hi everyone, How to cha

about log file

2006-05-17 Thread Peng Yi-fan
Hi everyone, How to change the log file path of a database. I am using Window XP OS. Thanks. Peng

Replication: slaves don't change to new log file properly

2006-03-16 Thread Jon Drukman
Our mysql master machine crashed (hardware problem) and rebooted. When it came back up, it started a new master log file. The slaves, however, were all stuck on the last log file. They still showed both replication threads running, no errors, but they just did not advance. I had to

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: Log file full of Got an error reading communication packets

2005-10-06 Thread Ian Collins
Hi, I too have a server whose log file is full of these errors. This server is also running MySQL 4.0.20. It is on Red Hat Enterprise Linux AS release 3 (Taroon). The errors are: (many thousands of them)... 051004 15:39:34 Aborted connection 349 to db: 'sqllive' user: '

RE: Log file full of Got an error reading communication packets

2005-09-21 Thread Randy Paries
] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 8:19 AM To: Randy Paries Cc: mysql@lists.mysql.com Subject: Re: Log file full of Got an error reading communication packets "Randy Paries" <[EMAIL PROTECTED]> wrote on 09/21/2005 08:56:13 AM: > Hello, > My log file

Re: Log file full of Got an error reading communication packets

2005-09-21 Thread SGreen
"Randy Paries" <[EMAIL PROTECTED]> wrote on 09/21/2005 08:56:13 AM: > Hello, > My log file is getting filled with these. > Can someone tell me what these mean? > > Thanks > Randy > //-snip-// > 050122

Log file full of Got an error reading communication packets

2005-09-21 Thread Randy Paries
Hello, My log file is getting filled with these. Can someone tell me what these mean? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an er

Re: log file

2005-07-18 Thread Bruce Ferrell
enable the bin log in mysql. It doesn't log "transactions" i.e. what it was, what it became, but the update will be logged prathima rao wrote: hi, how to create a log file of the updates done on the data in visual basic or in mysql for a particular record for example i

log file

2005-07-18 Thread prathima rao
hi, how to create a log file of the updates done on the data in visual basic or in mysql for a particular record for example i have a purchase order record in which my junior changes say rate without my knowledge how will i know what has been changed p rao -- MySQL General Mailing List For

Re: InnoDB lchange log file size

2005-04-13 Thread Gleb Paharenko
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 >

InnoDB lchange log file size

2005-04-13 Thread Rafal Kedziorski
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

creating mysqldump log file

2004-12-14 Thread Anil Doppalapudi
Hi, Is there any way to create a log file for mysqldump just like oracle export log file i.e what tables exported no of rows exported like that Thanks in advance Anil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

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
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

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

Re: relay log file maintenance problem

2004-11-29 Thread Sasha Pachev
Bill Thomason wrote: I have a replication server that is running out of disk space because of old relay binary log files. Both it and the master server are version 4.0.20. I have a cron script that maintains a 3 day history of binary log files on the master server. Has someone figured out a way to

relay log file maintenance problem

2004-11-29 Thread Bill Thomason
I have a replication server that is running out of disk space because of old relay binary log files. Both it and the master server are version 4.0.20. I have a cron script that maintains a 3 day history of binary log files on the master server. Has someone figured out a way to manage the number

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

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

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

Re: General log file in v3.23.52

2004-06-10 Thread Egor Egorov
Don Dachner <[EMAIL PROTECTED]> wrote: > How do I turn on the General log file in version 3.23.52? Can I put an entry in the > my.cnf file and reboot? Yes, put the "log" entry in my.cnf and restart MySQL. If you are running Red Hat Linux, restart MySQL by running

General log file in v3.23.52

2004-06-09 Thread Don Dachner
How do I turn on the General log file in version 3.23.52? Can I put an entry in the my.cnf file and reboot? Thanks, Don

Re: Out-of-control log file

2003-12-04 Thread Chris Waskowich
Seriously, can anyone help me out here? I've searched the list and I've searched around the Internet. I've found other people reporting a similar entry into their log files, but no one answered them either. I've read up on a few things, and I have a feeling that this error is related to some

Out-of-control log file

2003-12-01 Thread Chris Waskowich
One of my server is a slave to another. The slave server's host.err file is getting filled with blocks like this: Status information: Current dir: /usr/local/mysql/var/ Running threads: 0 Stack size: 65536 Current locks: lock: 82268c: key_cache status: blocks used:15 not flushed:

Re: Log file format?

2003-10-29 Thread Hassan Schroeder
Egor Egorov wrote: It's a process id. You can see it in the output of SHOW PROCESSLIST. So, each Id represents a thread, and each thread represents a connection? So an entry like this in the query log: 031029 9:56:43 6 Quit :: would represent a connection returned to the pool through an ex

Re: Log file format?

2003-10-29 Thread Egor Egorov
Hassan Schroeder <[EMAIL PROTECTED]> wrote: > If this is documented anywhere, I sure can't find it, so -- > > The query log fields are headed: Time, Id, Command, Argument. > > What is 'Id'? It's a process id. You can see it in the output of SHOW PROCESSLIST. -- For technical support contract

Log file format?

2003-10-28 Thread Hassan Schroeder
If this is documented anywhere, I sure can't find it, so -- The query log fields are headed: Time, Id, Command, Argument. What is 'Id'? TIA! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

script archiving log file

2003-09-03 Thread mlhoo
To Walt, > > I came across the articles on archiving log file which posted on Wed, >07 Aug 2002. > can i have a copy of the shell script regarding on automatically > archive log file in MySql. I m currently writing a perl script on >archiving log file generated by

Re: Re-establishing nuked log file

2003-09-02 Thread Jesse Sheidlower
On Tue, Sep 02, 2003 at 07:59:07AM -0700, Bruce Ferrell wrote: > flush logs from the mysql command line works And so it does. Thank you. I misunderstood what the Manual said about this command, though I should have tried it first anyway. Jesse Sheidlower -- MySQL General Mailing List For list a

Re: Re-establishing nuked log file

2003-09-02 Thread Bruce Ferrell
flush logs from the mysql command line works Jesse Sheidlower wrote: I recently restarted my MySQL server (4.0.10 in this case) with the general query log enabled, to help out with some debugging and optimization issues. After looking at a batch of these, I then deleted the log file directly

RE: Re-establishing nuked log file

2003-09-02 Thread Dan Greene
y, September 02, 2003 10:27 AM > To: [EMAIL PROTECTED] > Subject: Re-establishing nuked log file > > > > I recently restarted my MySQL server (4.0.10 in this case) with > the general query log enabled, to help out with some debugging and > optimization issues. After lo

Re-establishing nuked log file

2003-09-02 Thread Jesse Sheidlower
I recently restarted my MySQL server (4.0.10 in this case) with the general query log enabled, to help out with some debugging and optimization issues. After looking at a batch of these, I then deleted the log file directly, with "rm foo.log", assuming that it would be re-generated

recovery from log file

2003-08-01 Thread john
Hi group, I have two mysql-Innodb server(4.0.13) with replication enabled in that. server A > Server B I have the database dump of server B. In server B, I have enabled the log- bin, log-slave-update in server B. In case of database crash, How can I restore the data from log file. I k

Re: where do I find the error log file?

2003-06-19 Thread Egor Egorov
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote: > I need to find out why the mysqld is not starting up ? Can someone > please throw some light to the location of this file on a Mac? By default in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensi

where do I find the error log file?

2003-06-18 Thread Pushpinder Singh Garcha
I need to find out why the mysqld is not starting up ? Can someone please throw some light to the location of this file on a Mac? Thanks in adavnce. --Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

log file question

2003-06-16 Thread Nils Valentin
Hello Mysql Fans ;-); 030613 16:05:54 3 Connect [EMAIL PROTECTED] on 3 Query SHOW VARIABLES 3 Query SET autocommit=1 3 Query SET autocommit=1 030613 16:05:55 3 Query USE `sam_group_by_db`

Re: resize InnoDB's log file

2003-01-22 Thread Heikki Tuuri
Ha-nyung, - Original Message - From: ""Chung Ha-nyung"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, January 22, 2003 6:48 AM Subject: resize InnoDB's log file > > Currently I have three InnoDB log files, whose size is 256

resize InnoDB's log file

2003-01-21 Thread Chung Ha-nyung
ndering if deleting log files after mysqld is stopped and starting mysqld is safe. I tried this and got some look-so-serious error(or warning?) messages like following: 030121 10:18:49 mysqld ended 030121 10:27:07 mysqld started 030121 10:27:11 InnoDB: Log file ./ib_logfile0 did not exist:

Replication Binary Log File Size

2002-11-27 Thread Wendell Dingus
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 everyth

re: log file...

2002-09-17 Thread Victoria Reznichenko
antispam, Monday, September 16, 2002, 11:25:31 PM, you wrote: aafdn> my log file (hostname.log) was soo large and i just deleted it(back up) and created a new file called hostname.log but mysql does not stores anything in the log file.. (i did mysqladmin aafdn> log-flush and server st

Re: Re: InnoDB: Looong pause when log file is full?

2002-08-04 Thread Pete Harlan
n the > buffer pool are flushed to disk in small batches. The time when a physical > log file becomes full does not affect this continuous background > checkpointing activity, since InnoDB sees all the log files as one catenated > log file. That's good to know---so that isn't it.

Re: InnoDB: Looong pause when log file is full?

2002-08-03 Thread Heikki Tuuri
Pete, - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, August 02, 2002 2:40 AM Subject: Re: InnoDB: Looong pause when log file is full? > On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: &

Re: Re: InnoDB: Looong pause when log file is full?

2002-08-01 Thread Pete Harlan
Thanks for your feedback (and your general untiring devotion to the cause...) On Thu, Aug 01, 2002 at 04:30:10PM -0700, Jeremy Zawodny wrote: > > about what we can do to alleviate this? Instead of having three 150mb > > log files, would we be better off with 30 15mb log files? > > It shouldn't

Re: InnoDB: Looong pause when log file is full?

2002-08-01 Thread Jeremy Zawodny
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: > Hi, > > I've read the performance tuning tips for InnoDB > (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit > when the log files are full and the buffer pool is checkpointed. > > By 'geting bit', I mean for severa

InnoDB: Looong pause when log file is full?

2002-08-01 Thread Pete Harlan
Hi, I've read the performance tuning tips for InnoDB (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit when the log files are full and the buffer pool is checkpointed. By 'geting bit', I mean for several minutes the db server basically stops, and our website stops serving page

Re: Restoring log file enteries.

2002-04-04 Thread Victoria Reznichenko
Charitha, Thursday, April 04, 2002, 1:35:57 PM, you wrote: C> I am having the mysql log file which is having all the queries which C> affects the data base. C> I have to restore those queries in the table in some remote server. C> Is that possible. Yes, you can update database from

Re: Restoring log file enteries.

2002-04-04 Thread Dicky Wahyu Purnomo
On Thu, 4 Apr 2002 16:05:57 +0530 (IST) Charitha <[EMAIL PROTECTED]> wrote: > > > Hello all, > > I am having the mysql log file which is having all the queries which > affects the data base. > I have to restore those queries in the table in some remote serve

Restoring log file enteries.

2002-04-04 Thread Charitha
Hello all, I am having the mysql log file which is having all the queries which affects the data base. I have to restore those queries in the table in some remote server. Is that possible. Any ideas are welcome. Thanks in advance -- Regards, Charitha

Re: where are my.cnf anf mysql log file.

2002-03-14 Thread ds
I don't know if this will help you but try this: # mysqld --help | grep "dir:" basedir: / datadir: /var/lib/mysql/ tmpdir: /tmp/ So, you'll find mysql log files in your datadir (is this case, /var/lib/mysql/). my.cnf is usually at /etc/my.cnf If you don't have it, find a configura

where are my.cnf anf mysql log file.

2002-03-14 Thread Jianping Zhu
I installed following two files MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm but I can not fild my.cnf and mysql log files. Why? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 --

where is my binary log file

2001-09-12 Thread Attila Soki
hi, i have a lamer question: where is my binary log file? i can't find it. i am sure it exists because grows crazy, when i restore a database from dumpfile. i found nothing about binary log in my.cnf. version: mysql 3.23.32-log install path: /usr/local (default) thanx,

Re: Log file size

2001-06-06 Thread Peter Billson
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

Re: Log file size

2001-06-06 Thread Kenneth Kopelson
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

Log file size

2001-06-06 Thread Peter Billson
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

Log File Reporting

2001-02-14 Thread Basil Hussain
Hi all, I'd like to be able to analyse the log files that my MySQL server produces. Basically, I want to find out how many logins every account is doing, how many queries are being performed against each database (although not necessarily per-table) and how many slow queries each account is doing