-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, July 17, 2009 2:02 PM
To: Gary Smith; Todd Lyons
Cc: mysql@lists.mysql.com
Subject: RE: Slave log files going nuts...
The binlogs are closed and reopened every time you do a FLUSH LOGS;
command, or when
, July 16, 2009 3:16 PM
To: Todd Lyons
Cc: mysql@lists.mysql.com
Subject: RE: Slave log files going nuts...
I'll have to look into that. We have a single cronjob that just does a
mysqldump daily but not during the time of the log file generation, but that's
all I can think of off the top of my
I have a new slave I setup against a new master server. The master server has
4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be blank. This
slave is set to slave the master and act as a master
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote:
I have a new slave I setup against a new master server. The master server
has 4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem
] On Behalf Of Todd Lyons
[tly...@ivenue.com]
Sent: Thursday, July 16, 2009 2:41 PM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Slave log files going nuts...
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote:
I have a new slave I setup against a new master server
or you may have copied the InnoDB
tablespace but not the InnoDB log files.
GOAL: Trying to restore mysql backup on different host
using InnoDB backup that copes the backed up files to a files sever where I
pulle them down to the new host
I place all the MySQL datafiles and InnoDB log files
WHY do I see this error when restoring my backup db :
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but not the InnoDB log files.
GOAL: Trying to restore mysql backup on different host
using InnoDB backup that copes the backed up files to a files sever where
I see the following log files
-rw-rw 1 mysql mysql 10485760 Sep 16 17:30 ibdata1
-rw-rw 1 mysql mysql5242880 Sep 16 17:30 ib_logfile0
-rw-rw 1 mysql mysql5242880 Jan 17 2006 ib_logfile1
I checked every table on all databases. All are using MYISAM.
innodb section
In the last episode (Sep 18), AM Corona said:
I see the following log files
-rw-rw 1 mysql mysql 10485760 Sep 16 17:30 ibdata1
-rw-rw 1 mysql mysql5242880 Sep 16 17:30 ib_logfile0
-rw-rw 1 mysql mysql5242880 Jan 17 2006 ib_logfile1
I checked every table on all
Marcos Vinícius Vieira dos Santos wrote:
I used --localstatedir in ./configure but both data files and log files
was stored together.
In your my.cnf file, put the lines (in [mysqld] section
datadir = /sgdb/data
log-bin = /var/log/mysql
--
raj shekhar
facts: http://rajshekhar.net
Hello everyone,
I am compiling mysql source and need stored MySQL data files and log files (log
bin) separated. For example:
/var/log/mysql /* log files
and
/sgdb/data /* data files
I used --localstatedir in ./configure but both data files and log files was
stored together.
How do
| rotatelogs access.%Y%m%d 86400 combined
Am I missing something? Is there a reason why longish-term archiving
of log files doesn't make sense?
-- David Lubkin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is it possible to log information to the general log file only for a specific
database?
We are currently running MySQL 4.0.15. We are planning on moving to a new
server so and will upgrade MySQL. What is the latest most stable version that
is recommended?
Thanks for any information.
--
I don't think there is any way to lock down the general log to a
single database.. perhaps if you tell us what you are trying to
accomplish, we might be able to propose something..
As of today, 5.0.45 is the recommended install version.
http://dev.mysql.com/downloads/mysql/5.0.html
-
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what you mean by the mysql log. if you mean the error
log than that would be
log-error=
if you mean the binary log that would be
log-bin=
if you don't enter
of course you'll need to restart the server after making the changes
to the options file..
On 7/30/07, Christian High [EMAIL PROTECTED] wrote:
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what
Hi All,
Please tell my how to activate the general log, mysql log and slow query
log.
Regards,
Krishna
Guys,
I would like to know if there is a way to have individual databases
under the same instance or server write to separate binary log
files. The idea is to have multiple binary log file for each
database on the same server. The problem that I experiencing is
sorting through the binary
engine.
[...]
The errors are due to InnoDB being disabled. As far as I can tell, this
has happened as the InnoDB log file ib_logfile0 is the wrong size. This
took me to the description for adding and removing log files at:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
being disabled. As far as I can tell, this
has happened as the InnoDB log file ib_logfile0 is the wrong size. This
took me to the description for adding and removing log files at:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
However, something has happened in this case to expand
is the wrong size. This
took me to the description for adding and removing log files at:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
However, something has happened in this case to expand the file
id_logfile0 and instructions are not given on how to clean it out and
start
Hello,
Is it possible to extract transactional data from InnoDB log files?
InnoDB kept crashing and trying to insert the same record (replayed
from the log after the crash I assume). I'd like to try and extract
the record from log to reconstruct the query and try to break it again
in case
Hi Guys,
Need some pointers. I've got a MySQL server (5.0.22) which is basically
pulling data from SQL Server into a file and then I'm using mysqlimport
to load the data into the DB.
The updates are being generated like every 2 to 5 seconds.
Due to this, my Binary Log files are huge! (and many
hi...
i changed the mysql my.cnf to provide log files. i restarted mysql, but i
don't see the log files...
any idea as to what i may have missed. i'm running FC4, mysql 4.1.
the my.cnf is:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=1000
set
bruce wrote:
hi...
i changed the mysql my.cnf to provide log files. i restarted mysql, but i
don't see the log files...
any idea as to what i may have missed. i'm running FC4, mysql 4.1.
the my.cnf is:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable
bruce wrote:
chris...
hate to tell you.. .but you can have the log files set as i described..
the real issue was due to permission issues on the dir/file for the mysql
lol.. i'm not having much luck answering questions lately ;)
Thanks for letting us know about the fix.
--
MySQL General
Hello.
Can I delete off the binary log files manually? I do not want to 'RESET
MASTER', as it will clear all the binary logs, and that's not what I want to
do. The database is backed up every midnight, and I wouldn't want to keep
any of the bin logs except the latest one.
We are on RHEL - MySQL
Yes, look at the PURGE LOGS command.
Rithish Saralaya wrote:
Hello.
Can I delete off the binary log files manually? I do not want
to 'RESET MASTER', as it will clear all the binary logs, and
that's not what I want to do. The database is backed up every
midnight, and I wouldn't want to keep
Does anyone know of a method or script that will automatically delete
bin-log files after x days? I've got a few customers, all utilizing a
master and slave server... my problem is that the harddrives often get
filled to capacity if they go unchecked over a few months. Most of this is
attributed
- Original Message -
From: Shaun Adams [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, February 28, 2006 5:19 PM
Subject: Cleaning Bin-Log Files
Does anyone know of a method or script that will automatically delete
bin-log files after x days? I've got a few customers
Hi Green,
Thanks for guiding me to the manul, i some how missed this section of the
manual.I was more keen on adding and removing log files url.
Thanks once again.
regards
anandkl
On 10/18/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Ananda Kumar [EMAIL PROTECTED] wrote on 10/17/2005 09
Hi Friends,
Any help on this would be of great help.
regards
anandkl
On 10/17/05, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am using version 5 of mysql on lunix. I have place my log files in the
same disk of datafiles, can you please let me know how i can move log files
Ananda Kumar [EMAIL PROTECTED] wrote on 10/17/2005 09:16:25 AM:
Hi Friends,
Any help on this would be of great help.
regards
anandkl
On 10/17/05, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am using version 5 of mysql on lunix. I have place my log files in
the
same disk
Hi All,
I am using version 5 of mysql on lunix. I have place my log files in the
same disk of datafiles, can you please let me know how i can move log files
into a different disk.
regards
anandkl
Hello.
I've wanted to say that you should check if, for example, the command
line options of mysqld program had been changed.
I am sure that there is no change in the 'my.cnf'.
Check if it uses exactly this my.cnf, not another my.cnf which is
situated in a different place.
Tedy
Hello.
Program options can be specified in different ways, check them
all. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
What name does the hostname program reports?
Tedy Aulia [EMAIL PROTECTED] wrote:
Hi All,
I have found that the binlogfiles have changed their
:[EMAIL PROTECTED]
Sent: Thursday, 1 September 2005 1:47 PM
To: mysql@lists.mysql.com
Subject: Re: Master Log Files
Hello.
Program options can be specified in different ways, check them
all. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
What name does the hostname program
:[EMAIL PROTECTED]
Sent: Thursday, 1 September 2005 1:47 PM
To: mysql@lists.mysql.com
Subject: Re: Master Log Files
Hello.
Program options can be specified in different ways, check them
all. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
What name does the hostname program
Hi All,
I have found that the binlogfiles have changed their name. Initially the
files were using the name of the server followed by the number i.e.
foo.###. Since two weeks ago the binlog files have changed to be
mysql.###. As far as I remember there is no change in my.cnf file so
far. I am
Hello.
About deleting the InnoDB log files see:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Now what about this my.cnf file? As I recall, this file lives in the top
Program options could be passed in different ways. You can add your
specific options (for example
If so, you could be filling up your disk quite easily
Regards
Thank you David and Sebastion,
I am not doing this in a transaction (at least, I did not do anything
special to start a transaction) and I have no need for a transaction.
How do I check the log files you two suggest?
Thanks
Hi Siegfried,
There is a section on each of the log files. I wouldn't go deleting the
log files without understanding exactly what you are trying to do. Have
a read of the section I mentioned. The logfiles that you are showing in
your directory are only 5Mb each and won't be taking anything
Subject
RE: How to delete log files?
Was: RE: Where did my
disk space go
I'm trying to move my binary log files onto a different drive than our main data drive
to get a little performance boost.
the drives are set up like so:
drive 1 (sda):
swap
/boot
/usr
drive 2 (sdb):
/
mysql is installed in /usr/local/mysql and its data directory is /usr/local/mysql/var
I
I found the solution to my own problem...
the log-bin option is a specific filename. so when you set:
log-bin=/logging
mysql must have ownership of the / folder, as it is trying to create /logging.001 and
/logging.index
easily fixed by adding the file-name to the path...
]
To: [EMAIL PROTECTED]
Subject: creating log files
I apologise for not lurking for longer before posting, but this is becoming
increasingly important. This is a FreeBSD system, but it's standard MySQL
(mysql Ver 12.22 Distrib 4.0.20, for portbld-freebsd5.0 (i386)). This
morning, a user of my network
), and if it has any modifications
they are only things like hostname and so on. I did turn off IP ports
for it, so it's only using /tmp/mysql.sock for connection. If any more
information is needed I can provide it. My current fix is walking up to
the machine every few hours and deleting the log files, which
Hello *,
goal: using merge tables for annual / monthly storage of syslog information
using php-syslog-ng and syslog-ng
problem:
-one actual table must be available for inserts
-the merge table needs to be the target for reports and queries
-static parts of the merge table should be
On Mon, May 31, 2004 at 02:03:09PM +0200, Michael Arndt wrote:
Problem for this variant: merge table has to be dropped and recreated
periodically.
during the short lag interval the log merge table
does not exist
Hi Michael,
Problem for this variant: merge table has to be dropped and recreated
periodically.
during the short lag interval the log merge table
does not exist
You don't have to drop and re-create the table. Please
Hi I am using replication to do online backups for my tables. Now my next
task is to automate cleaning up of binary log files from Master server.
Assuming I have more than one slave running, and may be at the time of
clean up one of the slave is down for backup, how can I be sure that my
clean up
to the list.
Can someone let me know which of the above is correct, and what I should do?
If you want to delete some of binary log files you can use PURGE MASTER LOGS command:
http://www.mysql.com/doc/en/PURGE_MASTER_LOGS.html
--
For technical support contracts, goto https://order.mysql.com
know which of the above is correct, and what I should
do?
If you want to delete some of binary log files you can use PURGE MASTER LOGS
command:
http://www.mysql.com/doc/en/PURGE_MASTER_LOGS.html
Excellent! Thanks Egor, this is exactly what I wanted.
Thanks
eric
smime.p7s
Description: S
I think I am confused. I have many bin index files, but I have not gotten rid of them.
I read somewhere that I should not remove them...or I should not remove the entries in
the index file.
Since I am unsure of which one above is correct, I am posting to the list.
Can someone let me know
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : Monday, December 29, 2003 8:12 PM
À : [EMAIL PROTECTED]
Objet : Log Files in MySQL
I think I am confused. I have many bin index files, but I
have not gotten rid of them.
I read somewhere that I
I think I am confused. I have many bin index files, but I have not
gotten rid of them.
I read somewhere that I should not remove them...or I should not
remove the entries in the index file.
Since I am unsure of which one above is correct, I am posting to the
list.
Can someone let
Admin-Stress [EMAIL PROTECTED] wrote:
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Depends on what exactly logging you want to turn on (binary, update, general
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me
/init.d
(line 148)
Hope that helps.
Admin-Stress wrote:
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand
There is seemingly conflicting advice in the mysql manual in regards to log file sizes
and buffer
pool sizes for inndob
I only mention this because tweaking Innodb values and getting the best performance
with inndob
isn't easy because the mysql daemon has to be stopped, the log files deleted
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
I had a problem whith those files and now all my InnoDB stopped working,
only the MyISAM tables are working, how can I recovery data from them
At 17:22 -0300 10/14/03, Daniel Franco wrote:
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
InnoDB uses them to record ongoing changes being made by transactions,
and for auto-recovery after a crash
curently using 3.23.xxx ??
Whats the XXX in your version ???
What do the change log files say at the
www.mysql.com homepage ?
Best regards
Nils Valentin
Tokyo/Japan
Prem Soman wrote:
Thanks neils!
i have gone thru what u referred long before, i
know
that this set
to do it
but it is not immediatly reflected since mysqld reads
from the my.cnf file only when it restarts i
thought there must be some sort of command line
utility or ... to enable and disabke log files
without restarting the server.
In 3.23.xx you must restart MySQL server, if you change
it
but it is not immediatly reflected since mysqld reads
from the my.cnf file only when it restarts i
thought there must be some sort of command line
utility or ... to enable and disabke log files
without restarting the server.
can u also tell me from what version onwards is this
type of dynamic setting for log
Hi Prem,
Which version are you curently using 3.23.xxx ??
Whats the XXX in your version ???
What do the change log files say at the www.mysql.com homepage ?
Best regards
Nils Valentin
Tokyo/Japan
Prem Soman wrote:
Thanks neils!
i have gone thru what u referred long before, i know
hi all!
can we enable and disable log files (update log, slow
query log) dynamically. Please let me know.
what should i do to enable it without restarting the
server. I am using MySQL 2.23.52
advance thanx!
Want to chat
Hi Prem,
That question was just here 2 days ago, so easy to answer. ;-)
Logs can be enabled/disabled for the session with SET SQL_LOG_OFF |
SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in
v3.23.52:
http://www.mysql.com/doc/en/SET_OPTION.html
Best regards
Note: forwarded message attached.
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/---BeginMessage---
hi all!
can we enable and disable log files (update log
Prem Soman [EMAIL PROTECTED] wrote:
can we enable and disable log files (update log, slow
query log) dynamically. Please let me know.
what should i do to enable it without restarting the
server. I am using MySQL 2.23.52
No.
Logs can be enabled/disabled for the session with SET SQL_LOG_OFF
Hi,
I tried using the mysqlbinlog from 3.23.52 MAX with no difference in the
output at all from 4.0.2
It seems that whatever happened truely caused the log files to become
corrupted
So my next question would be, is there a way to repair the log files? What
are the formating rules for the log
didn't mean to. I am using mysql 4.0.1 Alpha and some
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running
since the last backup with binlog enabled in my.cnf.
The problem is that mysqlbinlog shows some log files, but other log files
choke.
In VI
Hi,
I deleted a db I didn't mean to. I am using mysql 4.0.1 Alpha and some
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running
since the last backup with binlog enabled in my.cnf.
The problem is that mysqlbinlog shows some log files
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
every few seconds ... there are constant accesses to the DB,
and the bin-log is rotated mid-connection by a querying client.
I have an
At 11:43 +0200 6/26/02, Gary Colman wrote:
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
You may not see an explict FLUSH LOGS query. Do you seen any
lines that say Refresh after a
Hi
Every few seconds, my mysql server generates a new binary log file
with an incremented id number ${hostname}-bin.x
According to the logs, this should happen only when a reload or flush
type command is issued ...
mysql variables:
flush off
log_bin on
max_binlog_size
At 16:31 +0200 6/25/02, Gary Colman wrote:
Hi
Every few seconds, my mysql server generates a new binary log file
with an incremented id number ${hostname}-bin.x
According to the logs, this should happen only when a reload or flush
type command is issued ...
mysql variables:
flush
Hello,
i could not understand what is the content of log
files in InnoDB in MySQL...is it the log of the
database,i
mean, the data, or the transaction log??
Thanx in advance..
Ritu Singla
Everything you always
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: ritu singla [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
Ritu,
the ib log files contain records of every change to database pages in the
ibdata files
Hi all,
I recently upgraded to Perl 5.6.1 and ever since I keep getting these errors
in my log files on my Linux machine every time the pages that get the data
from mysql are accessed:
Argument O_RDONLY isn't numeric in subroutine entry at
/usr/local/lib/perl5/5.6.1/i686-linux/DB_File.pm line
Pål,
Wednesday, March 20, 2002, 5:52:58 PM, you wrote:
PW I have:
PW mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
PW and wonder about the log file /var/log/mysqld.log
PW shouldn't that include failed connections??
You can find mysqlds log in the file 'your_hostname.err' or
I have:
mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
and wonder about the log file /var/log/mysqld.log
shouldn't that include failed connections??
mvh: Pål Wester
høgskoleingenør/programmerer
never.no as, stortingsgt 30, 0161 Oslo
direkte: 22 01 66 34, 906 900 62
tlf: 22 01 66
Greetings:
http://www.mysql.com/doc/B/i/Binary_log.html
Is it possible to place this and the error log file generated by mySQLd on
the hard drive on another server?
If so, how?
Thank you.
Peter M. Perchansky, President/CEO
Dynamic Net, Inc.
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: Can mySQL log files be located on another server?
Greetings:
http
If the MySQL server is unable to create the mysql.log log file, then the
server hangs in an undeterminate state. No children are forked, and clients
can connect, however are not serviced at all.
I know there is an error in the log , or when mysqld is ran with STDERR
logging, however in my humble
I have created a mysql based intranet and it has occurred to me that I
need to find out how to manage the log files but I cannot find them.
I downloaded the binary
mysql-3.23.41-pc-linux-gnu-i686.tar.gz
and installed to /usr/local/mysql
where should I look? Are they turned off by default
log files. We have yet to determine what sort of actions
cause this process to start, but mysql becomes unresponsive and fills up
its 4GB partition with these binary log files
(log.01-log.000***).
The load on the mysql server is extremely low right now, we're the only
ones
Hi All,
Not sure if the last email got through to the list! But On our log
files we are get alot of Error number zero's does anyone have any
idea what this means? We are running a system that Uses MySQL
3.23.39 and PHP 4.0.5. Any input would be appreciated thanks in
advance.
Drew
Hello,
I have a Question,
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
regards,
\\|//
(@ @)
---oOO---(_)---OOo
)(
( Krishna
For Unix /etc/my.cnf
you then in the my.cnf say were you would like the logs!
Simon
-Original Message-
From: Krishna M [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 16:27
To: [EMAIL PROTECTED]
Subject: Log files
Hello,
I have a Question,
1. In which directory i can
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
The log file will be in the data directory. In my case:
/usr/local/mysql/var
It has ending .err
You can place my.cnf in this dir also and some other places.
My database log files are expanding very quickly - and when I look at them,
they are logging all of the select statements, not just the delete, insert,
update, etc. statements.
How do I specify for the logfiles to only log "update" statements and not
the selects?
Thanks,
92 matches
Mail list logo