> -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
, 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
lp.org] 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 Smith wrote:
> I have a new slave I setup against a new master server. The master se
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smith 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 to be blank.
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 for
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 dat
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 f
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
>
>
&g
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
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://rajshekh
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
r software, e.g., Apache's
CustomLog "| 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
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
- micha
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.
--
Mal
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 sur
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 anyt
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
ckup,
> > but all tables are now using the MyISAM 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 removi
d 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 the file
> id_logfile0 and instructio
rs 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
However, something has happened in
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 ca
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!
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 Ge
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
se
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_connection
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
&
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
- Original Message -
From: "Shaun Adams" <[EMAIL PROTECTED]>
To:
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 custo
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
attri
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 PROTE
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 m
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
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
eb Paharenko [mailto:[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
eb Paharenko [mailto:[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
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
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 exam
mysql@lists.mysql.com
Subject
RE: How to delete log files?
Was: RE: Where did my
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 a
on
log_bin
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
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...
log-bin=/logging/h
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/
gt;
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
strange about its setup. I am using the default my_small.cnf that
installed with it (from FreeBSD ports), 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
i
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 don'
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 exis
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 c
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
> 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
Excellent! Thanks Egor, this is exactly what I wanted.
Th
is correct, I am posting 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
>> 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.
>>
> -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
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 wh
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
/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
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
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 de
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 aft
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
> 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:
>
when i make changes to my.cnf file i am able 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 t
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
that
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 setti
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
Note: forwarded message attached.
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/--- Begin Message ---
hi all!
can we enable and disable log files (update log
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
Nil
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,
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 rul
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.
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
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" afte
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 in
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
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 107
- 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 r
> 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
>
>
__
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/
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
mount.
-
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:
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.
He
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
10MB 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
o
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.
> 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.
C
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
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 Ma
On Fri, May 04, 2001 at 01:38:53AM -0400, Mike Farley wrote:
>
> Can anyone shed some light on how we should be rotating the binary
> log files?
The FLUSH LOGS command works for me.
> Try this. Enable a binary log file, then rename it to some other
> name. Then execute a flu
Subject: rotating binary log files...
Can anyone shed some light on how we should be rotating the binary log
files?
I am running version 3.23.37.
In the manual it states to flush the logs, or execute a refresh command and
that would close the existing log file and rename it to .1 extension
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,
94 matches
Mail list logo
