RE: Slave log files going nuts...
> -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 the server restarts. Is your server crashing > continuously? Take a look at your error log as well. > > Regards, > Gavin Towey Gavin/Todd, Tracking it down, the timestamp correlates with a mysqldump that I have a crontab for which of course, has flush-logs. /usr/bin/mysqldump --opt --flush-logs --all-databases --result-file=$FILENAME I'm not sure if we want to flush the log files on this machine at this point. It's a tossup since there are multiple slaves hitting this guy replicating only specific tables in some cases. I would guess that we could always restore the entire backup and dump what we want across to a new server before starting the incremental replication, but I'm still working that plan up right now. Anyway, thanks for the pointers to indentify the problem. Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Slave log files going nuts...
The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or when the server restarts. Is your server crashing continuously? Take a look at your error log as well. Regards, Gavin Towey -Original Message- From: Gary Smith [mailto:g...@primeexalia.com] Sent: Thursday, 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 head. Gary From: tly...@sitehelp.org [tly...@sitehelp.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 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 downstream > slaves. Note, there is no master/master on this configuration, even though > the master itself could do it. > > Any ideas? Something is doing several 'mysqladmin refresh' or a related command, all sequentially in a row in short order. Look at your cron jobs that start or end around the time that all those "empty" binlogs are being created. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 head. Gary From: tly...@sitehelp.org [tly...@sitehelp.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 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 downstream > slaves. Note, there is no master/master on this configuration, even though > the master itself could do it. > > Any ideas? Something is doing several 'mysqladmin refresh' or a related command, all sequentially in a row in short order. Look at your cron jobs that start or end around the time that all those "empty" binlogs are being created. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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 downstream > slaves. Note, there is no master/master on this configuration, even though > the master itself could do it. > > Any ideas? Something is doing several 'mysqladmin refresh' or a related command, all sequentially in a row in short order. Look at your cron jobs that start or end around the time that all those "empty" binlogs are being created. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Slave log files going nuts...
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 downstream slaves. Note, there is no master/master on this configuration, even though the master itself could do it. Below is the my.cnf file and a listing of the files generated on the slave. This portion of the file is unique on both machines. Only differences in the file are the server-id and report-host. Both servers are running 5.1.35 Any ideas? #INNO DB settings innodb_file_per_table innodb_flush_log_at_trx_commit = 1 innodb_autoextend_increment = 2M innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 48M innodb_log_file_size= 10M innodb_log_buffer_size = 64M innodb_log_files_in_group = 1 log-slave-updates sync_binlog = 1 replicate-same-server-id= 0 log_bin_trust_function_creators = 1 log-bin = /exports/mysql-log/log-repl binlog-ignore-db= mysql binlog-ignore-db= information_schema replicate-ignore-db = mysql replicate-ignore-db = information_schema relay-log = hs-relay-bin relay-log-index = hs-relay-index relay-log-info-file = hs-relay-info relay-log-purge = 1 -rw-rw 1 mysql mysql 125 Jul 11 23:43 log-repl.01 -rw-rw 1 mysql mysql 125 Jul 11 23:43 log-repl.02 -rw-rw 1 mysql mysql 125 Jul 11 23:43 log-repl.03 -rw-rw 1 mysql mysql 2350918 Jul 14 08:33 log-repl.04 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.05 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.06 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.07 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.08 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.09 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.10 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.11 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.12 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.13 -rw-rw 1 mysql mysql 148 Jul 14 08:33 log-repl.14 -rw-rw 1 mysql mysql 117655 Jul 14 11:24 log-repl.15 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.16 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.17 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.18 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.19 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.20 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.21 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.22 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.23 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.24 -rw-rw 1 mysql mysql 148 Jul 14 11:24 log-repl.25 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.26 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.27 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.28 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.29 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.30 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.31 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.32 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.33 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.34 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.35 -rw-rw 1 mysql mysql 148 Jul 14 11:25 log-repl.36 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.37 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.38 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.39 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.40 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.41 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.42 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.43 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.44 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.45 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.46 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.47 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.48 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.49 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.50 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.51 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.52 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.53 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.54 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.55 -rw-rw 1 mysql mysql 148 Jul 14 11:26 log-repl.56 -rw-rw
Re: 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.
This is because you didn't copy innodb ibdata and ib_log files togeter. Or you forgot to stop mysqld when you remove its ib_log files. On Sat, Feb 7, 2009 at 7:21 AM, my sql wrote: > 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 > pulle them down to the new host > I place all the MySQL datafiles and InnoDB log files in the same directory > and all paths in the my.cnf files are pointing here > > upon the startup of the mysqld and the following crach recover that the > Innodb do I get tons of this errors [see below] why? > I do have the two InnoDB log files - so why does it complain that my DB > 'may' be corrupt - I don't like this message. > > Event tried with seting innodb_force_recovery = 4 but I still get the > error upon startup - why? > It doesn't look like a clean startup to me > > > 090206 14:56:34 InnoDB: Error: page 27060 log sequence number 4 1755884236 > InnoDB: is in the future! Current system log sequence number 4 1682795020. > InnoDB: Your database may be corrupt or you may have copied the InnoDB > InnoDB: tablespace but not the InnoDB log files. > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
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.
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 pulle them down to the new host I place all the MySQL datafiles and InnoDB log files in the same directory and all paths in the my.cnf files are pointing here upon the startup of the mysqld and the following crach recover that the Innodb do I get tons of this errors [see below] why? I do have the two InnoDB log files - so why does it complain that my DB 'may' be corrupt - I don't like this message. Event tried with seting innodb_force_recovery = 4 but I still get the error upon startup - why? It doesn't look like a clean startup to me 090206 14:56:34 InnoDB: Error: page 27060 log sequence number 4 1755884236 InnoDB: is in the future! Current system log sequence number 4 1682795020. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files.
Re: innodb log files but we only use MYISAM
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 databases. All are using MYISAM. > > innodb section in my.cnf is commented out. The innodb engine defaults to being enabled, so unless you have "skip-innodb" in your my.cnf, the engine itself will start and generate those three files, even if you don't have any InnoDB tables. Another set of files starting with "falcon_*" and "maria_*" will appear when you start mysql 6.0, since those engines create tablespace/log files too. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
innodb log files but we only use MYISAM
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 my.cnf is commented out. Why does this log file exist when we're not using innodb tables or dbs? -- Regards, Martin Corona
Re: Store MySQL data files and log files (log bin) separated!!!
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 | opinions: http://rajshekhar.net/blog Yoda of Borg are we: Futile is resistance. Assimilate you, we will 'Borg? Sounds Swedish.' - Lily, Star Trek First Contact -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Store MySQL data files and log files (log bin) separated!!!
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 this Thanks Marcos Santos Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
Archiving log files
While I've used MySQL casually for quite a while (my license dates to early 2000), I've never used it for a heavy, mission-critical load where IT policies hadn't already been set for me. Which I'm about to. My natural inclination, from three decades of db work and general wizardry, is to packrat. Keep each day's general log in a dated file, e.g., archive foo.log to foo.20071226. Hang onto at least a few months' worth, if it turns out to be untenable to keep them forever. This is easy enough to do, but I wonder why it doesn't come up in discussion as a reasonable or best practice. Checking my archives here, the MySQL forums, the manual, Dubois, and Kruckenberg/Pipes, there's some talk of mysql-log-rotate but nothing about dated files or retaining them beyond a ten-day window. Yet it's a well-known and useful practice with other 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.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: log files and upgrading
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 - michael dykman On 9/20/07, Malka Cymbalista <[EMAIL PROTECTED]> wrote: > 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. > -- > > Malka Cymbalista > Webmaster, Weizmann Institute of Science > [EMAIL PROTECTED] > 08-934-3036 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
log files and upgrading
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. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log Files
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 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 anything after the = sign then the server will use > the default name and location for the logs which is generally > "hostname-logtype".log in the data directory. the exception would be > the binary log which is still in the data directory but is named > "hostname-bin".xx with xx being ascending numbers beginning > with 01 > > On 7/30/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > Please tell my how to activate the general log, mysql log and slow query > > log. > > > > Regards, > > Krishna > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log Files
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 anything after the = sign then the server will use the default name and location for the logs which is generally "hostname-logtype".log in the data directory. the exception would be the binary log which is still in the data directory but is named "hostname-bin".xx with xx being ascending numbers beginning with 01 On 7/30/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > Hi All, > > Please tell my how to activate the general log, mysql log and slow query > log. > > Regards, > Krishna > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Log Files
Hi All, Please tell my how to activate the general log, mysql log and slow query log. Regards, Krishna
Multiple binary log files question
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 log file and not knowing which database the changes are associated with while attempting to reapply the changes. Thanks in advance ~ Clyde Lewis Database Administrator
Re: InnoDB data log files
Hi Dan, Thanks for this, fixed the problem perfectly when we applied it. Andrew On Thu, 2007-04-12 at 10:45 -0500, Dan Nelson wrote: > In the last episode (Apr 12), Andrew Simpson said: > > One server had a problem while creating a backup last week. The routine > > normally takes about 30 seconds, but in this case went on for over 30 > > minutes. During this, the application was responding correctly to other > > users. After a reboot, InnoDB has been disabled, which left the data > > inaccessible. The database was restored using the most recent backup, > > 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 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 again. > [...] > > > > 070403 16:33:55 InnoDB: Starting shutdown... > > 070403 16:33:57 InnoDB: Shutdown completed; log sequence number 0 81792952 > > 070403 16:33:57 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Shutdown > > complete > > > > InnoDB: Error: log file C:\www\xampp\mysql\data\ib_logfile0 is of different > > size 0 134217728 bytes > > InnoDB: than specified in the .cnf file 0 67108864 bytes! > > Looks like someone edited the my.cnf file and changed the > innodb_log_file_size variable without restarting the server or deleting > the old logfiles. Assuming the server had shut down cleanly, you > should just have to delete the current logfiles and restart mysql. If > the server had crashed, you would probably want to set > innodb_log_file_size back to 128M, start*stop mysqld to flush any > pending transactions, then lower it down to 64M, delete the logfiles, > and start mysql. > > -- > Dan Nelson > [EMAIL PROTECTED] > - This message has been scanned for viruses and dangerous content by the http://www.orbital.net MailScanner, and is believed to be clean. - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB data log files
In the last episode (Apr 12), Andrew Simpson said: > One server had a problem while creating a backup last week. The routine > normally takes about 30 seconds, but in this case went on for over 30 > minutes. During this, the application was responding correctly to other > users. After a reboot, InnoDB has been disabled, which left the data > inaccessible. The database was restored using the most recent backup, > 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 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 again. [...] > > 070403 16:33:55 InnoDB: Starting shutdown... > 070403 16:33:57 InnoDB: Shutdown completed; log sequence number 0 81792952 > 070403 16:33:57 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Shutdown > complete > > InnoDB: Error: log file C:\www\xampp\mysql\data\ib_logfile0 is of different > size 0 134217728 bytes > InnoDB: than specified in the .cnf file 0 67108864 bytes! Looks like someone edited the my.cnf file and changed the innodb_log_file_size variable without restarting the server or deleting the old logfiles. Assuming the server had shut down cleanly, you should just have to delete the current logfiles and restart mysql. If the server had crashed, you would probably want to set innodb_log_file_size back to 128M, start*stop mysqld to flush any pending transactions, then lower it down to 64M, delete the logfiles, and start mysql. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB data log files
Hello all, I am looking after the installation of web-based software built using MySQL with mostly InnoDB tables. The software is currently installed in over 10 locations and has been running continually for several months in some of these. These installations vary from several thousand to several hundred thousand lines in the database, with 100 tables. Backups are made roughly daily from within the application, which uses the php 'exec' function to directly call mysqldump. One server had a problem while creating a backup last week. The routine normally takes about 30 seconds, but in this case went on for over 30 minutes. During this, the application was responding correctly to other users. After a reboot, InnoDB has been disabled, which left the data inaccessible. The database was restored using the most recent backup, but all tables are now using the MyISAM engine. The server is running Windows Server 2003 and MySQL version 5.0.24a-community-nt installed using the xampp package. The relevant sections of the MySQL log file are below, after which it went into a near endless cycle of 'Incorrect information in file:' errors. 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 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 again. Any help on how to sort this out without a reinstall or, more importantly, to understand why this may have happened, would be greatly appreciated. Best regards, Andrew Simpson 070403 16:33:53 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Normal shutdown 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6135 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6134 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6133 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6131 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6130 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6129 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6128 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6127 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6099 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 6015 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 5929 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 5928 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 5865 user: 'wasp' 070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing close of thread 5861 user: 'wasp' 070403 16:33:55 InnoDB: Starting shutdown... 070403 16:33:57 InnoDB: Shutdown completed; log sequence number 0 81792952 070403 16:33:57 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Shutdown complete InnoDB: Error: log file C:\www\xampp\mysql\data\ib_logfile0 is of different size 0 134217728 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 070403 16:35:01 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '5.0.24a-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect information in file: '.\wasp_ke\wasp_settings.frm' 070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect information in file: '.\wasp_ke\wasp_settings.frm' 070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect information in file: '.\wasp_ke\bugs.frm' - This message has been scanned for viruses and dangerous content by the http://www.orbital.net MailScanner, and is believed to be clean. - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Extracting transactional data from InnoDB log files
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 it caused the corruption in the ibdata file. Any help is greatly appreciated. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binary Log Files and Load Data In-File
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) I took a look at the binary logs using mysqlbinlog and it returns everyhing as just load data infile statements. There isn't any actual data inside of it. So, my question is, Do I really need these binary logs since I read from the Book/site that binary logs are useful for rolling back transactions / master-slave replication etc. Since these logs does not contain any actual data and I don't have a slave DB. BTW, I've already set the logs to expire every 5 days for the time being. Just wanted to check with the people here for information and advise. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log files
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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log files
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 = max_connections=1000 set-variable = log-error=/var/log/mysql_err.log set-variable = log=/var/log/mysql_query.log Logs aren't defined that way, they are simply: log = /path/to/log (ie without the 'set-variable' at the start). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Log files
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-variable = log-error=/var/log/mysql_err.log set-variable = log=/var/log/mysql_query.log #set-variable = log-bin=/var/log/mysql_bin.log set-variable = log-slow-queries=/var/log/mysql_slow.log # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: manual deletion of binary log files
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 any of the bin logs except the > latest one. > > We are on RHEL - MySQL 4.1.11 - INNoDB storage engine. > > Regards, > Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
manual deletion of binary log files
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 4.1.11 - INNoDB storage engine. Regards, Rithish.
Re: Cleaning Bin-Log Files
- 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 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 to the binlogs which fill to about 1GB and then starts a new
log.
We're using MySQL 4.026.
Any thoughts?
This may be excessive for what you are trying to do but it's a starting
point.
The following bash script is one that I run every day via a cron job. (You
didn't say what OS your server is; mine is Linux Mandrake so I use cron for
scheduling.) The script is fairly heavily commented so you'll probably
understand it if you know bash but feel free to ask followup questions if
things aren't clear. Basically, the script gets the names of each of the
databases on the system, does a backup via mysqldump, then lists all backups
older than a given number of days, then deletes those older backups. It
writes a short report and emails it to me and the system administrator for
the server. It's run without problems for several years now.
You're not worried about database backups so you can probably remove the
do/done and simply list all the bin-logs that meet your criteria, then
delete them. You may not want to bother sending that email but you could use
cron to schedule this script to run as often as you like.
#!/bin/bash
#This script makes a separate database-level backup of each of the current
MySQL databases and
#deletes backups older than a certain number of days.
#This script is normally invoked via a cron job so that it runs once per day
in the middle of the night.
#The crontab entry looks like this:
#0 3 * * * sh /home/rhino/MySQL/backup2.bash > /home/rhino/MySQL/backup2.out
2>&1; cat /home/rhino/MySQL/backup2.out | sendEmail -f [EMAIL PROTECTED] -t
[EMAIL PROTECTED] [EMAIL PROTECTED]
-u "MySQL Backup Report"
USERID="myuserid"; #The userid to use for creating the backup
PASSWORD="mypasswd"; #The password to use for creating the backup
BACKUP_TIMESTAMP=`/bin/date +%Y%m%d"-"%H%M%S`; #The timestamp
(MMDD-HHMMSS) of the backup
BACKUP_PATH="/home/rhino/MySQL/backup"; #The directory into which the backup
will be written
NUMBER_OF_DAILY_BACKUPS_TO_KEEP=7; #The number of generations of backups to
keep
echo "** REPORT BEGINS **";
echo
echo "Program Name:" $0
report_date=`/bin/date`
echo "Report Date:" $report_date;
echo
#Display the non-secret values used in this run.
echo "Backup Values:";
echo " Backup timestamp is" $BACKUP_TIMESTAMP;
echo " Backup path is" $BACKUP_PATH;
echo " Number of daily backups to keep =" $NUMBER_OF_DAILY_BACKUPS_TO_KEEP;
#For each database currently in MySQL, take a database-level backup, then
list any backups older than a certain number of days, then delete those old
backups.
for ONE_DBNAME in `echo show databases | mysql -s -u $USERID -p$PASSWORD`
do
echo
echo "Backing up database" $ONE_DBNAME;
/usr/bin/mysqldump --opt --verbose -u${USERID} -p${PASSWORD}
${ONE_DBNAME} -r "${BACKUP_PATH}/${ONE_DBNAME}.${BACKUP_TIMESTAMP}.sql"
echo ">> Deleting these old backups for this database..."
/usr/bin/find ${BACKUP_PATH} -mtime
+$NUMBER_OF_DAILY_BACKUPS_TO_KEEP -name $ONE_DBNAME'*' -print; #display old
backups (if any)
/usr/bin/find ${BACKUP_PATH} -mtime
+$NUMBER_OF_DAILY_BACKUPS_TO_KEEP -name $ONE_DBNAME'*' -exec rm '{}' ';';
#delete old backups (if any)
done
echo
echo "** REPORT ENDS **";
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/271 - Release Date: 28/02/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 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 to the binlogs which fill to about 1GB and then starts a new log. We're using MySQL 4.026. Any thoughts?
Re: move log files to a different disk.
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: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 of datafiles, can you please let me know how i can move log > files > > > into a different disk. > > > regards > > > anandkl > > > > > > > > Did you RTFM? > > http://dev.mysql.com/doc/refman/5.0/en/server-options.html > http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html > http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html > http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html > > These all have options to control where different log files wind up. You > didn't say which log files you wanted to move so I had to give you all of > them... > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > >
Re: move log files to a different disk.
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 of datafiles, can you please let me know how i can move log files > > into a different disk. > > regards > > anandkl > > > > Did you RTFM? http://dev.mysql.com/doc/refman/5.0/en/server-options.html http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html These all have options to control where different log files wind up. You didn't say which log files you wanted to move so I had to give you all of them... Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: move log files to a different disk.
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 > into a different disk. > regards > anandkl > >
move log files to a different 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
Re: Master Log Files
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 Aulia" <[EMAIL PROTECTED]> wrote: > Thanks for your reply Gleb, > > I understand that we can setup the binlogfile name in 'my.cnf' file, but > I am sure that there is no change in the 'my.cnf'. > > > The hostname program reports the machine name correctly i.e. foo. > > > Cheers, > Tedy > > > -- 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]
Re: Master Log Files
Thanks for your reply Gleb, I understand that we can setup the binlogfile name in 'my.cnf' file, but I am sure that there is no change in the 'my.cnf'. The hostname program reports the machine name correctly i.e. foo. Cheers, Tedy -Original Message- From: Gleb 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 the hostname program reports? "Tedy Aulia" <[EMAIL PROTECTED]> wrote: >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 using MySQL version 3.23.33 > >Could someone explain why the case I mentioned above has happened? Your >help would be appreciated. > >Cheers, >Tedy Aulia > -- 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]
RE: Master Log Files
Thanks for your reply Gleb, I understand that we can setup the binlogfile name in 'my.cnf' file, but I am sure that there is no change in the 'my.cnf'. The hostname program reports the machine name correctly i.e. foo. Cheers, Tedy -Original Message- From: Gleb 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 the hostname program reports? "Tedy Aulia" <[EMAIL PROTECTED]> wrote: >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 using MySQL version 3.23.33 > >Could someone explain why the case I mentioned above has happened? Your >help would be appreciated. > >Cheers, >Tedy Aulia > -- 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]
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 reports? "Tedy Aulia" <[EMAIL PROTECTED]> wrote: >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 using MySQL version 3.23.33 > >Could someone explain why the case I mentioned above has happened? Your >help would be appreciated. > >Cheers, >Tedy Aulia > -- 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]
Master Log Files
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 using MySQL version 3.23.33 Could someone explain why the case I mentioned above has happened? Your help would be appreciated. Cheers, Tedy Aulia
Re: How to delete log files? Was: RE: Where did my disk space go?
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 InnoDB parameters) in configuration file. Create it from one of the templates if it doesn't exist. See: http://dev.mysql.com/doc/mysql/en/program-options.html http://dev.mysql.com/doc/mysql/en/option-files.html "Siegfried Heintze" <[EMAIL PROTECTED]> wrote: > David (and anyone else): > Here is the directory of my data directory. I don't see hundreds of mega > bytes here, but deleting ib_logfile* and ibdata1 would sure help. > > Which of these files I can delete without loosing any data from my database? > > drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs > -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 > ib_arch_log_00 > -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Aug 3 17:52 ib_logfile0 > -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Mar 4 18:05 ib_logfile1 > -rw-r--r-- 1 Administrator mkpasswd 10,485,760 May 3 15:47 ibdata1 > drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 mysql > -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err > drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 test > > Now what about this my.cnf file? As I recall, this file lives in the top > level directory. I have no such file. I found these files in the mysql > directory: > > my-huge.cnf > my-innodb-heavy-4G.cnf > my-large.cnf > my-medium.cnf > my-small.cnf > > I don't recall editing any of these. Should I be editing them? > > > Thanks, > > Siegfried > > -Original Message- > From: David Logan [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 04, 2005 3:33 PM > To: Siegfried Heintze > Cc: mysql@lists.mysql.com > Subject: RE: Where did my disk space go? > > Hi Siegfried, > > In the mysql data directory, > > -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log > -rw-rw1 mysqlmysql 25088 Feb 15 08:08 > ib_arch_log_00 > -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 > -rw-rw1 mysqlmysql 5242880 Feb 15 08:08 ib_logfile1 > > The above files maybe in slightly different places, it depends on whether > you are using the InnoDB engine or the MyISAM one. The InnoDB logging > files are the ib_logfiles. You could also check the my.cnf for any form of > logging being switched on, in particular binary logging. > > You could check for this as well. This will be in your my.cnf file as > > # Replication Master Server (default) > # binary logging is required for replication > 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 log files you two suggest? >> >> Thanks, >> Siegfried >> >> -Original Message- >> From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, August 03, 2005 8:10 PM >> To: Siegfried Heintze; mysql@lists.mysql.com >> Subject: RE: Where did my disk space go? >> >> Hi Siegfried, >> >> I would check your transaction logs. Are you doing this as one giant >> transaction? The system may be filling up the logs just in case you need >> to rollback. >> >> Regards >> >> David Logan >> Database Administrator >> HP Managed Services >> 148 Frome Street, >> Adelaide 5000 >> Australia >> >> +61 8 8408 4273 - Work >> +61 417 268 665 - Mobile >> +61 8 8408 4259 - Fax >> >> >> -Original Message- >> From: Siegfried Heintze [mailto:[EMAIL PROTECTED] >> Sent: Thursday, 4 August 2005 10:00 AM >> To: mysql@lists.mysql.com >> Subject: Where did my disk space go? >> >> I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for >> many >> (> 20) hours issuing SQL UPDATE and DELETE commands. The update commands >> should not be increasing the storage requirements, I'm just updating >> integer >> values. >> >> I've noticed several times now that I run out of disk space. I started >> with
RE: How to delete log files? Was: RE: Where did my disk space go?
One thing to remember about *nix, is that disk space is not released until all
processes that had a
file open have closed it. For example, if a process has a 2Gb file open, and
another process rm's
the file, an ls will show that file as gone but the disk space is not released
until the first
process has closed the file. Been bit by this a few times. Could this be the
case here?
Thanks,
Ron.
"The software said to install Windows 98 or better... So I installed linux."
"Friends don't let friends use IE"
[EMAIL PROTECTED]
08/04/05 04:29 PM
To
[EMAIL PROTECTED], [EMAIL
PROTECTED]
cc
mysql@lists.mysql.com
Subject
RE: How to delete log files?
Was: RE: Where did my
disk space go?
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 if you
have > 1Gb free. The files you are showing are for the InnoDB engine and
I can't tell if you are using it. The only databases I can see are
mysql, test and hotjobs. All the other files are well within the usual
sizes that I would expect.
The my.cnf file enables you to customise your installation to ensure
best performance for your application. We use replication a lot here at
work and have custom requirements for the servers so end up doing many
mods from the defaults. I don't use replication at home and so don't
have to modify much at all.
The .cnf files you mentioned are example files. Mysql does not require a
my.cnf file as it makes a number of default assumptions if it is not
there.
The documentation at http://dev.mysql.com/doc/mysql/en/index.html goes
over all the different options that are available within the option
files. There are versions of the manual in other languages at
http://dev.mysql.com/doc/ HTH
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Siegfried Heintze [mailto:[EMAIL PROTECTED]
Sent: Friday, 5 August 2005 8:46 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: How to delete log files? Was: RE: Where did my disk space go?
David (and anyone else):
Here is the directory of my data directory. I don't see hundreds of mega
bytes here, but deleting ib_logfile* and ibdata1 would sure help.
Which of these files I can delete without loosing any data from my
database?
drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs
-rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05
ib_arch_log_00
-rw-r--r-- 1 Administrator mkpasswd 5,242,880 Aug 3 17:52 ib_logfile0
-rw-r--r-- 1 Administrator mkpasswd 5,242,880 Mar 4 18:05 ib_logfile1
-rw-r--r-- 1 Administrator mkpasswd 10,485,760 May 3 15:47 ibdata1
drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 mysql
-rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err
drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 test
Now what about this my.cnf file? As I recall, this file lives in the top
level directory. I have no such file. I found these files in the mysql
directory:
my-huge.cnf
my-innodb-heavy-4G.cnf
my-large.cnf
my-medium.cnf
my-small.cnf
I don't recall editing any of these. Should I be editing them?
Thanks,
Siegfried
-Or
RE: How to delete log files? Was: RE: Where did my disk space go?
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 if you have > 1Gb free. The files you are showing are for the InnoDB engine and I can't tell if you are using it. The only databases I can see are mysql, test and hotjobs. All the other files are well within the usual sizes that I would expect. The my.cnf file enables you to customise your installation to ensure best performance for your application. We use replication a lot here at work and have custom requirements for the servers so end up doing many mods from the defaults. I don't use replication at home and so don't have to modify much at all. The .cnf files you mentioned are example files. Mysql does not require a my.cnf file as it makes a number of default assumptions if it is not there. The documentation at http://dev.mysql.com/doc/mysql/en/index.html goes over all the different options that are available within the option files. There are versions of the manual in other languages at http://dev.mysql.com/doc/ HTH Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Siegfried Heintze [mailto:[EMAIL PROTECTED] Sent: Friday, 5 August 2005 8:46 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: How to delete log files? Was: RE: Where did my disk space go? David (and anyone else): Here is the directory of my data directory. I don't see hundreds of mega bytes here, but deleting ib_logfile* and ibdata1 would sure help. Which of these files I can delete without loosing any data from my database? drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Aug 3 17:52 ib_logfile0 -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Mar 4 18:05 ib_logfile1 -rw-r--r-- 1 Administrator mkpasswd 10,485,760 May 3 15:47 ibdata1 drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 test Now what about this my.cnf file? As I recall, this file lives in the top level directory. I have no such file. I found these files in the mysql directory: my-huge.cnf my-innodb-heavy-4G.cnf my-large.cnf my-medium.cnf my-small.cnf I don't recall editing any of these. Should I be editing them? Thanks, Siegfried -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 3:33 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Feb 15 08:08 ib_logfile1 The above files maybe in slightly different places, it depends on whether you are using the InnoDB engine or the MyISAM one. The InnoDB logging files are the ib_logfiles. You could also check the my.cnf for any form of logging being switched on, in particular binary logging. You could check for this as well. This will be in your my.cnf file as # Replication Master Server (default) # binary logging is required for replication 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 log files you two suggest? > > Thanks, > Siegfried > > -Original Message- > From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 03, 2005 8:10 PM > To: Siegfried Heintze; mysql@lists.mysql.com > Subject: RE: Where did my disk space go? > > Hi Siegfried, > > I would check your transaction logs. Are you doing this as one giant > transaction? The system may be filling up the logs just in case you need > to rollback. > > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Siegfried Heintze [mailto:[EMAIL PROTECTED] > Sent: Thursday, 4 August 2005 10:00 AM > To: mysql@lists.mysql.com > Subject: Wher
How to delete log files? Was: RE: Where did my disk space go?
David (and anyone else): Here is the directory of my data directory. I don't see hundreds of mega bytes here, but deleting ib_logfile* and ibdata1 would sure help. Which of these files I can delete without loosing any data from my database? drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Aug 3 17:52 ib_logfile0 -rw-r--r-- 1 Administrator mkpasswd 5,242,880 Mar 4 18:05 ib_logfile1 -rw-r--r-- 1 Administrator mkpasswd 10,485,760 May 3 15:47 ibdata1 drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 Mar 4 18:02 test Now what about this my.cnf file? As I recall, this file lives in the top level directory. I have no such file. I found these files in the mysql directory: my-huge.cnf my-innodb-heavy-4G.cnf my-large.cnf my-medium.cnf my-small.cnf I don't recall editing any of these. Should I be editing them? Thanks, Siegfried -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 3:33 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Feb 15 08:08 ib_logfile1 The above files maybe in slightly different places, it depends on whether you are using the InnoDB engine or the MyISAM one. The InnoDB logging files are the ib_logfiles. You could also check the my.cnf for any form of logging being switched on, in particular binary logging. You could check for this as well. This will be in your my.cnf file as # Replication Master Server (default) # binary logging is required for replication 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 log files you two suggest? > > Thanks, > Siegfried > > -Original Message- > From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 03, 2005 8:10 PM > To: Siegfried Heintze; mysql@lists.mysql.com > Subject: RE: Where did my disk space go? > > Hi Siegfried, > > I would check your transaction logs. Are you doing this as one giant > transaction? The system may be filling up the logs just in case you need > to rollback. > > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Siegfried Heintze [mailto:[EMAIL PROTECTED] > Sent: Thursday, 4 August 2005 10:00 AM > To: mysql@lists.mysql.com > Subject: Where did my disk space go? > > I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for > many > (> 20) hours issuing SQL UPDATE and DELETE commands. The update commands > should not be increasing the storage requirements, I'm just updating > integer > values. > > I've noticed several times now that I run out of disk space. I started > with > a gigabyte free. Last time, I aborted the program, compressed my disk, > retrieved much lost disk space and started again. > > Now I tried that again: no luck. I rebooted and recompressed again. I'm > still out of disk space. > > It seems that MySQL just keeps using more and more disk space. > > How can I retrieve my lost disks pace? > > Thanks, > Siegfried > > > -- > 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] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- 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: replication binary log files location
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/host-name which will now create /logging/host-name-bin.001 and /logging/host-name-bin.index and since mysql has ownership of the logging directory, this is okay... -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]
replication binary log files location
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 want to set the binary logs to go to the 2nd drive, sdb, so I made a new directory, /logging I went into logging and changed its ownership and group to mysql... chown -R mysql . chgrp -R mysql . [EMAIL PROTECTED] logging]# pwd /logging [EMAIL PROTECTED] logging]# ls -al total 8 drwxr-xr-x2 mysqlmysql4096 Aug 24 04:26 . drwxr-xr-x 23 root root 4096 Aug 24 04:53 .. then went into my.cnf and put: log-bin=/logging but when I try to start mysql this way: [EMAIL PROTECTED] mysql]# bin/mysqld_safe --user=mysql & no logging, and I get this in the .err file 040824 5:46:53 Could not use /logging for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. error 13 is typically a unix permissions error, right? but I changed the /logging directory to be owned by mysql (and am running mysqld_safe --user=mysql) any ideas? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]
Re: creating log files
I figured it out, I had compiled one of its dependencies and not compiled mysql itself afterwards, so it was seg faulting and leaving behind those logs as part of bail-out On Tue, 29 Jun 2004, David King wrote: Date: Tue, 29 Jun 2004 17:53:57 -0700 (PDT) From: David King <[EMAIL PROTECTED]> 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 told me that "the Internet is down." Quick inspection of the machine revealed that the WinXP box had failed to receive an IP address from the DHCP server, the machine in question. I plugged a monitor into it (since I now couldn't boot another Unix machine that required NFS and couldn't talk to it from a windows box) to reveal a screen full of errors, most of them saying "no room left on device" or "not enough inodes." A quick df -i revealed that indeed, /var had no inodes left, which is weird since it usually sits at about 6% inodes used (obviously dhcpd couldn't write out the new lease file because it had no inodes left, explaining the internet "being down"). du -d2|sort -n revealed that 95% of the inodes used were in /var/db/mysql, and a directory listing revealed several thousand files named innodb.status. where ? is a number from 0-9. (They look suspiciously like PIDs.) I've noticed that past few days that mysql, while sitting idle, has been taking up as much as 30% CPU, and I can't track down why it would be doing that. It does it in spurts, taking 6%, and then 30% right around the time it creates the files. It seemed to be created about one every twenty seconds, without even querying the database! Here's an example: [EMAIL PROTECTED]:/var/db/mysql# while true; do sleep 60; ls inno*|wc -l; done 5 8 12 16 19 23 26 30 34 37 ^C Obviously, this is a bad thing. A typical innodb.status. looks like this: [EMAIL PROTECTED]:/var/db/mysql# cat innodb.status.1959 = 040614 20:55:02 INNODB MONITOR OUTPUT = Per second averages calculated from the last 16 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 4, signal count 4 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 6, OS waits 3; RW-excl spins 1, OS waits 1 Does anyone know what could cause this? It looks to be, for whatever reason writing out status information. But why it would do that, and why it would take 30% CPU idling is beyong me. Any ideas? (I wrote that email a few days ago, here is an update:) It seems that now another set of files is being created in the same directory, with names like ib_arch_log_050412, those numbers change as more files are created. I can't time how many are being created per minute exactly, but here's an example like above: [EMAIL PROTECTED]:/var/db$ while true; do sudo ls mysql | grep 'inno\|ib_arch_log' | wc -l; sleep 60; done 0 8 14 22 28 36 42 49 56 64 70 76 84 90 ^C The ib_arch_log_050444 files are not printable, and are all 2560 bytes long, owned by mysql:mysql. My server houses one small database with two tables, and then the mysql internal databse and an empty "test" database, and to my knowledge nothing is 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 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 definately isn't acceptable. I apologise if I am in the wrong group for this, I would like if I could be directed to the correct one. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 told me that "the Internet is down." Quick inspection of the machine revealed that the WinXP box had failed to receive an IP address from the DHCP server, the machine in question. I plugged a monitor into it (since I now couldn't boot another Unix machine that required NFS and couldn't talk to it from a windows box) to reveal a screen full of errors, most of them saying "no room left on device" or "not enough inodes." A quick df -i revealed that indeed, /var had no inodes left, which is weird since it usually sits at about 6% inodes used (obviously dhcpd couldn't write out the new lease file because it had no inodes left, explaining the internet "being down"). du -d2|sort -n revealed that 95% of the inodes used were in /var/db/mysql, and a directory listing revealed several thousand files named innodb.status. where ? is a number from 0-9. (They look suspiciously like PIDs.) I've noticed that past few days that mysql, while sitting idle, has been taking up as much as 30% CPU, and I can't track down why it would be doing that. It does it in spurts, taking 6%, and then 30% right around the time it creates the files. It seemed to be created about one every twenty seconds, without even querying the database! Here's an example: [EMAIL PROTECTED]:/var/db/mysql# while true; do sleep 60; ls inno*|wc -l; done 5 8 12 16 19 23 26 30 34 37 ^C Obviously, this is a bad thing. A typical innodb.status. looks like this: [EMAIL PROTECTED]:/var/db/mysql# cat innodb.status.1959 = 040614 20:55:02 INNODB MONITOR OUTPUT = Per second averages calculated from the last 16 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 4, signal count 4 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 6, OS waits 3; RW-excl spins 1, OS waits 1 Does anyone know what could cause this? It looks to be, for whatever reason writing out status information. But why it would do that, and why it would take 30% CPU idling is beyong me. Any ideas? (I wrote that email a few days ago, here is an update:) It seems that now another set of files is being created in the same directory, with names like ib_arch_log_050412, those numbers change as more files are created. I can't time how many are being created per minute exactly, but here's an example like above: [EMAIL PROTECTED]:/var/db$ while true; do sudo ls mysql | grep 'inno\|ib_arch_log' | wc -l; sleep 60; done 0 8 14 22 28 36 42 49 56 64 70 76 84 90 ^C The ib_arch_log_050444 files are not printable, and are all 2560 bytes long, owned by mysql:mysql. My server houses one small database with two tables, and then the mysql internal databse and an empty "test" database, and to my knowledge nothing is 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 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 definately isn't acceptable. I apologise if I am in the wrong group for this, I would like if I could be directed to the correct one. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: "merge tables for big log files ?"
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't edit the MRG file directly either. You can accomplish this easily by using the ALTER TABLE statement: CREATE TABLE t1 (id INT NOT NULL, c CHAR(10) NOT NULL, PRIMARY KEY(id)); CREATE TABLE t2 (id INT NOT NULL, c CHAR(10) NOT NULL, PRIMARY KEY(id)); CREATE TABLE t_merge (id INT NOT NULL, c CHAR(10) NOT NULL, KEY(id)) TYPE=MERGE UNION=(t1, t2); So now you have a MERGE table containing both tables. If you want to add a third one later: CREATE TABLE t3 (id INT NOT NULL, c CHAR(10) NOT NULL, PRIMARY KEY(id)); ALTER TABLE t_merge UNION=(t1, t2, t3); Using ALTER TABLE with a MERGE table is an atomic operation and can be done while the server is up and running full-speed without any problems. Regards, Jeremy -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jeremy Cole <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Training and Consulting Manager /_/ /_/\_, /___/\___\_\___/ Streetsboro, Ohio USA <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: "merge tables for big log files ?"
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 You don't have to drop and recreate it in MySQL. You can do it under MySQL's feet without it noticing. The .MRG definition file is simply a list of tables that make up the merge, with a couple of optional configuration likes; the only one I use is #INSERT_METHOD. You can create a new .MRG file very easily in Perl, consisting of the new range of tables, then move it over the old .MRG, so in one atomic operation the merge table now has a new subtable; in order to get MySQL to notice however you have to do a flush tables. You can use mysqladmin flush-tables to do that. For insertion, this is where #INSERT_METHOD comes in handy. MySQL can either insert to the first or last table: $ tail -3 MessageIDs.MRG MessageIDs_20040529 MessageIDs_20040530 #INSERT_METHOD=LAST Now INSERT INTO merge_table will be inserting into MessageIDs_20040530, which is today. Just after midnight, my Perl runs and makes a new .MRG, and after the flush MySQL is inserting into the next table without even realising. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"merge tables for big log files ?"
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 compressed
question:
what is the best strategy for grouping / using a merge table ?
a) have one separate table for continous syslog data
and synchronise this table regularily to e.g. a monthly table log_2004_06
("log_2004_06" is Part of a merge table "log_global" to enable global access
to all monthly logs with php-syslog-ng)
syslog-ng -> log
log --(INSERT INTO) -> log_2004_06
log_global ( log_2004_12,log2004_11,log_2004_10,...)
b) let the "insert table" for syslog-ng already be part of the merge table
and reordering the merge table on a regularly schema, to be
able to compress all old,static tables.
log ( log_2004_12,log2004_11,log_2004_10,...)
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
anyone has done something like this already ?
TIA
Micha
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cleaning up binary log files during replication
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 procedure is not deleting a binary log file that may be needed by the slave that is currently down? In the documentation it says to check the log files currently being used by all the slaves and then delete logs in master by using PURGE cmd and specify the earliest among all the ones being used by all slaves. But this is lot of work if I am running many instances, as i am using mysqld_multi to run numerous instances. Also in the documentation it says "If you are using replication, you should not delete old binary log files until you are sure that no slave will ever need to use them. One way to do this is to do mysqladmin flush-logs once a day and then remove any logs that are more than 3 days old" But I don't feel comfortable about 3 day old thing, that seems to be an estimate but I would prefer a way so that I can go ahead and delete the logs from Master and it will only delete the ones not being used by the slave servers including the ones currently down for backups. If anyone has any tips or suggestions on this matter, please let me know I would appreciate help... Thanks Desktop Support School of Computer Science Florida International Univeristy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: 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 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 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/MIME cryptographic signature
Re: Log Files in MySQL
[EMAIL PROTECTED] wrote: > > 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 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/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
RE: 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 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 which of the above is correct, and what I >> should do? > First, please let us know what you are trying to achieve (save space, optimize...). I am trying to save space. I currently have about 70 files in the range of 10-30MB. I have a cron job that does a flush tables every morning at 0600. Thanks Eric
RE: Log Files in MySQL
> -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 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 which of the above is correct, and > what I should do? First, please let us know what you are trying to achieve (save space, optimize...). Ugo > > Thanks > Eric > > > eric wagar > glxvr623 on AIM > [EMAIL PROTECTED] on MSN > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 which of the above is correct, and what I should do? Thanks Eric eric wagar glxvr623 on AIM [EMAIL PROTECTED] on MSN
Re: MySQL log files
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 query log, slow query log) you should put to the my.cnf appropriate entry. For example, to enable binary log put to the my.cnf: [mysqld] log-bin -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
Re: MySQL log files
How are you starting mysql? as a service? I dont think it keeps a log file by default. If you are not starting mysql as a service, start it with the --log-error=/var/log/mysqld --log-warnings flags. If you are starting it as a service, add those flags to your mysql file inside /etc/rc.d/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 clearly reading MySQL manual. Thanks for helping me :) __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL log files
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 :) __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
conflict in mysql manual for log files. buffer pool in innodb
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, new startup values set in my.cnf, then the daemon has to be restarted. When giving sample values for inndob, the manual suggests this: 7.5.3 InnoDB Startup Options #Set the log file size to about #25 % of the buffer pool size then in the same section, this: # Set the log file size to about # 15 % of the buffer pool size It gets worse: 7.5.10 "Make your log files big, even as big as the buffer pool. When InnoDB has written the log files full, it has to write the modified contents of the buffer pool to disk in a checkpoint. Small log files will cause many unnecessary disk writes. The drawback in big log files is that recovery time will be longer." Which is it? 15%, 25% or 100%? The other thing that is not mentioned in the manual but should be, is the potential problems of running a big key_buffer with big innodb_buffer_pool_size. I know several different formulas for calculating memory usage are given, but its important to note that even though the key_buffer is shared across all connections, its easy to see swapping if you aren't careful when using big key_buffer and using bing innodb_buffer_pool_size. Throw in a moderately sized query_cache_size and 3 gigs of memory can be eaten up quickly. Any info on thoughts or ideas on innodb_log_file_size vis a vis innodb_buffer_pool_size is welcome. Thanks! __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log files used by InnoDB.
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. 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 ? I hope you didn't remove them. What do you mean by "InnoDB stopped working? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Log files used by InnoDB.
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 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
hi Nils! can u show me how to change the long_query_time using sql statement or by using mysqladmin. the set long_query_time=xyz; does not work or is this a valid command. i am using mysql 3.23.52 --- Nils Valentin <[EMAIL PROTECTED]> wrote: > 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 this "set" method is not fully supported in > 3.23 > > version, thats why i posed this question, i wanted > to > > know whether there is any other way to do it. > > > > 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 the server. > > > > can u also tell me from what version onwards is > this > > type of dynamic setting for log files allowed. > > > > Regards, > > Prem S > > > > --- Nils Valentin <[EMAIL PROTECTED]> wrote: > > > > >>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 > >> > >>Nils Valenin > >>Tokyo/Japan > >> > >>2003年 8月 13日 水曜日 13:30、Prem Soman > >>さんは書きました: > >> > >>> Note: forwarded message attached. > >>> > >>> > >> > > > > > > >>>Want to chat instantly with your online friends? > >> > >>Get the FREE Yahoo! > >> > >>>Messenger http://uk.messenger.yahoo.com/ > >> > >>-- > >>--- > >>Valentin Nils > >>Internet Technology > >> > >> E-Mail: [EMAIL PROTECTED] > >> URL: http://www.knowd.co.jp > >> Personal URL: http://www.knowd.co.jp/staff/nils > >> > > > > > > > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > > Messenger http://uk.messenger.yahoo.com/ > > Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Prem Soman <[EMAIL PROTECTED]> wrote: > > i have gone thru what u referred long before, i know > that this "set" method is not fully supported in 3.23 > version, thats why i posed this question, i wanted to > know whether there is any other way to do it. > > 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 the server. In 3.23.xx you must restart MySQL server, if you change server options in my.cnf. > > can u also tell me from what version onwards is this > type of dynamic setting for log files allowed. Since 4.0.3 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Fwd: Dynamic enabling of log files
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 this "set" method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. 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 the server. can u also tell me from what version onwards is this type of dynamic setting for log files allowed. Regards, Prem S --- Nils Valentin <[EMAIL PROTECTED]> wrote: > 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 Nils Valenin Tokyo/Japan 2003å¹´ 8月 13æ—¥ 水曜日 13:30ã€?Prem Soman ã?•ã‚“ã?¯æ›¸ã??ã?¾ã?—ã?Ÿ: Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Thanks neils! i have gone thru what u referred long before, i know that this "set" method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. 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 the server. can u also tell me from what version onwards is this type of dynamic setting for log files allowed. Regards, Prem S --- Nils Valentin <[EMAIL PROTECTED]> wrote: > > 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 > > Nils Valenin > Tokyo/Japan > > 2003年 8月 13日 水曜日 13:30、Prem Soman > さんは書きました: > > Note: forwarded message attached. > > > > > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > > Messenger http://uk.messenger.yahoo.com/ > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dynamic enabling of log files
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 | 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
Fwd: Dynamic enabling of log files
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, 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 instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ --- End Message --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
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 Nils Valenin Tokyo/Japan 2003年 8月 13日 水曜日 13:30、Prem Soman さんは書きました: > Note: forwarded message attached. > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dynamic enabling of log files
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 instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbinlog - doesn't work on some log files
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 files? It is frustrating to be able to look at my data in an editor, but not be able to restore it. Also it sounds like from Heikki Tuuri's response that he thought this could have been somehow caused by a replication related bug. Thanks, Eric - 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: mysqlbinlog - doesn't work on some log files
Eric, try using the mysqlbinlog program from some other version, maybe 4.0.0, or 3.23.xx. I noticed a similar bug a while ago. mysqlbinlog seg faulted on a binlog file. I am forwarding this bug report to our replication expert. Best regards, Heikki ... 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, but other log files choke. In VI I can see this at the top of one of one log file: þbin¢>.=.K.. 0010 00 01 00 00 00 00 00 02 00 34 2e 30 2e 31 2d 61 .4.0.1-a 0020 6c 70 68 61 2d 6c 6f 67 00 00 00 00 00 00 00 00 lpha-log 0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0040 00 00 00 00 00 00 00 00 00 00 00 a2 3e 06 3d 77 ...¢>.=w 0050 40 06 3d 02 01 00 00 00 f2 00 00 00 02 00 00 00 @.=.ò... 0060 00 00 c1 1b 00 00 00 00 00 00 0a 00 00 73 65 6e ..Á..sen 0070 73 69 74 69 6c 6c 65 00 55 50 44 41 54 45 20 75 sitille.UPDATE u 0080 61 5f 70 72 69 6d 61 72 79 5f 68 69 74 73 20 53 a_primary_hits S 0090 45 54 20 31 31 64 61 79 20 3d 20 28 31 31 64 61 ET 11day = (11da 00a0 79 20 2b 20 31 29 2c 20 31 31 75 5f 64 61 79 20 y + 1), 11u_day 00b0 3d 20 28 31 31 75 5f 64 61 79 20 2b 20 31 29 2c = (11u_day + 1), 00c0 20 4d 6f 6e 74 68 5f 54 6f 74 61 6c 20 3d 20 28 Month_Total = ( 00d0 4d 6f 6e 74 68 5f 54 6f 74 61 6c 20 2b 20 31 29 Month_Total + 1) 00e0 2c 20 4d 6f 6e 74 68 5f 55 6e 69 71 75 65 20 3d , Month_Unique = 00f0 20 28 4d 6f 6e 74 68 5f 55 6e 69 71 75 65 20 2b (Month_Unique + but mysqlbinlog only shows this for this 4.8M file: root@www194:/home/back# mysqlbinlog www194-bin.001 # at 4 #020611 11:17:06 server id 1 Start: binlog v 1, server v created 691231 16:00:00 # at 73 #030419 19:03:44 server id 104888125 Query thread_id=15859712 exec_time=131072 use ; LOAD DATA INFILE '' REPLACE INTO TABLE nsitille OPTIONALLY ENCLOSED BY '\0' ESCAPED BY '\0' LINES STARTING BY '\0'; I had been running this machine as a Master to a remote slave. And some of the logs are large because I ran LOAD DATA FROM MASTER a few times from the slave machine. So I have the data I need but I can't access it. I have a total of 8 log files, only two work with mysqlbinlog. The rest return very shortly like above. This is really freaking me out, if this doesn't work, then I will have to start not trusting the log at all, which would suck. I have been able to restore data before, in the same way, from this same database and config. Thanks, Eric - 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
mysqlbinlog - doesn't work on some log files
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, but other log files choke. In VI I can see this at the top of one of one log file: þbin¢>.=.K.. 0010 00 01 00 00 00 00 00 02 00 34 2e 30 2e 31 2d 61 .4.0.1-a 0020 6c 70 68 61 2d 6c 6f 67 00 00 00 00 00 00 00 00 lpha-log 0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0040 00 00 00 00 00 00 00 00 00 00 00 a2 3e 06 3d 77 ...¢>.=w 0050 40 06 3d 02 01 00 00 00 f2 00 00 00 02 00 00 00 @.=.ò... 0060 00 00 c1 1b 00 00 00 00 00 00 0a 00 00 73 65 6e ..Á..sen 0070 73 69 74 69 6c 6c 65 00 55 50 44 41 54 45 20 75 sitille.UPDATE u 0080 61 5f 70 72 69 6d 61 72 79 5f 68 69 74 73 20 53 a_primary_hits S 0090 45 54 20 31 31 64 61 79 20 3d 20 28 31 31 64 61 ET 11day = (11da 00a0 79 20 2b 20 31 29 2c 20 31 31 75 5f 64 61 79 20 y + 1), 11u_day 00b0 3d 20 28 31 31 75 5f 64 61 79 20 2b 20 31 29 2c = (11u_day + 1), 00c0 20 4d 6f 6e 74 68 5f 54 6f 74 61 6c 20 3d 20 28 Month_Total = ( 00d0 4d 6f 6e 74 68 5f 54 6f 74 61 6c 20 2b 20 31 29 Month_Total + 1) 00e0 2c 20 4d 6f 6e 74 68 5f 55 6e 69 71 75 65 20 3d , Month_Unique = 00f0 20 28 4d 6f 6e 74 68 5f 55 6e 69 71 75 65 20 2b (Month_Unique + but mysqlbinlog only shows this for this 4.8M file: root@www194:/home/back# mysqlbinlog www194-bin.001 # at 4 #020611 11:17:06 server id 1 Start: binlog v 1, server v created 691231 16:00:00 # at 73 #030419 19:03:44 server id 104888125 Query thread_id=15859712 exec_time=131072 use ; LOAD DATA INFILE '' REPLACE INTO TABLE nsitille OPTIONALLY ENCLOSED BY '\0' ESCAPED BY '\0' LINES STARTING BY '\0'; I had been running this machine as a Master to a remote slave. And some of the logs are large because I ran LOAD DATA FROM MASTER a few times from the slave machine. So I have the data I need but I can't access it. I have a total of 8 log files, only two work with mysqlbinlog. The rest return very shortly like above. This is really freaking me out, if this doesn't work, then I will have to start not trusting the log at all, which would suck. I have been able to restore data before, in the same way, from this same database and config. Thanks, Eric - 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: thousands of binary 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" after a connect event? That's what
appears in the log if someone executes "mysqladmin reload",
which causes a reload without an explicit query. Something like
this:
Time Id CommandArgument
020626 9:31:26 1 Connect root@localhost on
1 Refresh
1 Quit
>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 inkling perhaps updating the mysqld may make a difference,
>even though I cannot find anything mentioned in the TODO's or fixes.
>
>Almost every file is only 65 bytes long, and shows:
>[root@mysql mysql]# mysqlbinlog mysql-bin.61676
># at 4
>#020626 9:54:19 server id 12 Rotate to mysql-bin.61677pos=4
># at 46
>#020626 9:57:48 server id 2 Stop
>[root@mysql mysql]# mysqlbinlog mysql-bin.61677
># at 4
>#020626 9:54:19 server id 12 Rotate to mysql-bin.61678pos=4
># at 46
>#020626 9:57:56 server id 2 Stop
>[root@mysql mysql]# mysqlbinlog mysql-bin.61678
># at 4
>#020626 9:54:39 server id 12 Rotate to mysql-bin.61679pos=4
># at 46
>#020626 9:58:04 server id 2 Stop
>
>
>
>See - it's REALLY frequent..
>
>
>*shrug* who knows ... Anyone?? ;)
>
>G
>
>
>
>On Tue, 25 Jun 2002, Paul DuBois wrote:
>
>> 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 off
>> >log_binon
>> >max_binlog_size1073741824
>> >version4.0.1-alpha-Max-log
>> >
>> >It is running on an i386 running RedHat Linux 6.2
>> >
>> >
>> >Any ideas, anyone ??
>>
>> If you turn on general query logging, the query log may tell you
>> if and when reload or flush commands are issued and where they're
>> coming.
>>
>> Maybe there's an out-of-control cron job running.
>>
>> >
>> >Many thanks
>> > Gary
>>
>
>
>
>-
>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: thousands of binary 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 inkling perhaps updating the mysqld may make a difference,
even though I cannot find anything mentioned in the TODO's or fixes.
Almost every file is only 65 bytes long, and shows:
[root@mysql mysql]# mysqlbinlog mysql-bin.61676
# at 4
#020626 9:54:19 server id 12 Rotate to mysql-bin.61677pos=4
# at 46
#020626 9:57:48 server id 2 Stop
[root@mysql mysql]# mysqlbinlog mysql-bin.61677
# at 4
#020626 9:54:19 server id 12 Rotate to mysql-bin.61678pos=4
# at 46
#020626 9:57:56 server id 2 Stop
[root@mysql mysql]# mysqlbinlog mysql-bin.61678
# at 4
#020626 9:54:39 server id 12 Rotate to mysql-bin.61679pos=4
# at 46
#020626 9:58:04 server id 2 Stop
See - it's REALLY frequent..
*shrug* who knows ... Anyone?? ;)
G
On Tue, 25 Jun 2002, Paul DuBois wrote:
> 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:
> >flushoff
> >log_bin on
> >max_binlog_size 1073741824
> >version 4.0.1-alpha-Max-log
> >
> >It is running on an i386 running RedHat Linux 6.2
> >
> >
> >Any ideas, anyone ??
>
> If you turn on general query logging, the query log may tell you
> if and when reload or flush commands are issued and where they're
> coming.
>
> Maybe there's an out-of-control cron job running.
>
> >
> >Many thanks
> > Gary
>
-
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: thousands of binary log files
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 off
>log_binon
>max_binlog_size1073741824
>version4.0.1-alpha-Max-log
>
>It is running on an i386 running RedHat Linux 6.2
>
>
>Any ideas, anyone ??
If you turn on general query logging, the query log may tell you
if and when reload or flush commands are issued and where they're
coming.
Maybe there's an out-of-control cron job running.
>
>Many thanks
> Gary
-
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
thousands of binary log files
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 1073741824
version 4.0.1-alpha-Max-log
It is running on an i386 running RedHat Linux 6.2
Any ideas, anyone ??
Many thanks
Gary
-
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 Files in InnoDB (MySQL)
- 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. Thus all changes to data, and also all changes to disk-based > transaction structures like undo logs in the ibdata files. > > Regards, > > Heikki > Innobase Oy > > - Original Message - > From: "ritu singla" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, May 29, 2002 1:49 PM > Subject: Log Files in InnoDB (MySQL) > > > > Hello, > > i could not understand what is the content of log > > files in InnoDB...is it the log of the database,i > > mean, the data, or the transaction log?? > > > > Thanx in advance.. > > Ritu Singla > > > > > > Everything you always wanted to know about cars and bikes,now > > at: http://in.autos.yahoo.com/cricket/tracker.html > - 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 Files in InnoDB
> 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 wanted to know about cars and > bikes,now > at: http://in.autos.yahoo.com/cricket/tracker.html > Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - 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
Error in the log 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 252. can anyone please tell me what they are and how I can fix them? Thanks so much, Soheil - 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 files
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 'mysql.err' (on Windows) that located in mysql datadir. Info about error logging is situated in the manual: http://www.mysql.com/doc/E/r/Error_log.html PW> mvh: Pål Wester PW> høgskoleingenør/programmerer -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 files
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 34, fax: 22 01 66 21 http://never.no - icq:103476059 - 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: Can mySQL log files be located on another server?
I wouldn't recommend this because the binary log can get very large and have a lot of data being put into it. However, if you absolutly need this, you could simply setup a NetFS share across the network and mount the share on the MySQL server then store the bin.log on that 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: 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. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - 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
Can mySQL log files be located on another server?
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. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - 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
3.22.32-log Hang when unable to create log files
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 opinion it is more appropriate that the server exits immediately so that the various monitoring facilities can detect the problem. Right now the mysql TCP port remains open and the parent process continues to run and this may fool monitoring software. This was observed on a 3.22.32-log under Debian 2.2 (Linux server 2.2.18pre21 #1 Sat Nov 18 18:47:15 EST 2000 i686 unknown) Sorry if this is known or has been fixed. I did not have the opportunity to test or follow appropriate procedures. Philip - 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 files????
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 ??? cheers Dave - 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
mysql suddenly spits out gigs of log files
We've recently converted from MyISAM to BDB tables (transactions are required and BDB is what was available), and have worked through all of our problems except this one. Every so often (up to twice per day) mysql decides to fill up gigs of space by writing out a seemingly endless stream of 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 ones on it and we're just doing simple inserts, updates, and a few cross-table joins. The transactions are used sparingly, but they work when called upon. We're running 3.23.42 on FreeBSD 4.4 (specifics are below). Let me know if there's any other information that might make the 'why' of this problem more readily known. We've been over and over the MySQL manual, and searched the mailing list again and again, and we haven't found a single mention of a problem even similar to this one. Any information would be greatly appreciated. Thanks, Ray mysql> show status; +--+---+ | Variable_name| Value | +--+---+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Bytes_received | 81843 | | Bytes_sent | 98583 | | Connections | 519 | | Created_tmp_disk_tables | 11| | Created_tmp_tables | 19| | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 2 | | Handler_read_first | 59| | Handler_read_key | 690 | | Handler_read_next| 10309 | | Handler_read_prev| 0 | | Handler_read_rnd | 138 | | Handler_read_rnd_next| 16507 | | Handler_update | 60| | Handler_write| 93| | Key_blocks_used | 50| | Key_read_requests| 833 | | Key_reads| 50| | Key_write_requests | 34| | Key_writes | 44| | Max_used_connections | 1 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 64| | Open_files | 60| | Open_streams | 0 | | Opened_tables| 84| | Questions| 1980 | | Select_full_join | 7 | | Select_full_range_join | 1 | | Select_range | 9 | | Select_range_check | 0 | | Select_scan | 47| | Slave_running| OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes| 0 | | Sort_range | 11| | Sort_rows| 78| | Sort_scan| 13| | Table_locks_immediate| 390 | | Table_locks_waited | 0 | | Threads_cached | 0 | | Threads_created | 518 | | Threads_connected| 1 | | Threads_running | 1 | | Uptime | 7131 | +--+---+ 54 rows in set (0.00 sec) mysql> show variables; +-+- --+ | Variable_name | Value | +-+- --+ | back_log| 50 | | basedir | /usr/local/ | | bdb_cache_size | 8388600 | | bdb_log_buffer_size | 32768 | | bdb_home| /var/db/mysql/ | | bdb_max_lock| 1 | | bdb_logdir | | | bdb_shared_data | OFF | | bdb_tmpdir | /var/tmp/ | | bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (September 8, 2001) | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 | | | latin5 danish hebrew win1251 estonia hungarian koi8_ukr | | | win1251ukr greek win1250 croat cp1257 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | /var/db/mysql/ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb| YES | | have_gemini
Errors on log files
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 Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED] - 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 files
> 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. Check the manual or use the search box on http://mysql.com -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 files
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 find the config file to config the log file 2. Where can i find the log file for mysql? regards, \\|// (@ @) ---oOO---(_)---OOo )( ( Krishna Manchikalapudi ) )( ( Mobile: 732-213-3103 ) ) Office: 732-817-1900 X:247 ( -- |__|__| || || ooO Ooo - 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
Log files
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 Manchikalapudi ) )( ( Mobile: 732-213-3103 ) ) Office: 732-817-1900 X:247 ( -- |__|__| || || ooO Ooo - 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: rotating binary log files...
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 flush logs command. Uhm, why are you renmaing the log at all? Let MySQL handle it. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 121 days, processed 750,421,968 queries (71/sec. avg) - 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
rotating binary log files...
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 and then open a new clean log file in its place. However, this does not happen. Flushing the logs doesn't even seem to close the current log file. Try this. Enable a binary log file, then rename it to some other name. Then execute a flush logs command. Mysql keeps the original file open and doesn't open a new one. The only way I have seen that works so far it to shut the server down and then restart it. But that really isn't an open on a frequently used server. Any ideas? Has anyone else run into this? Thanks in advance. Mike Farley JobCircle.com email: [EMAIL PROTECTED] - 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
configuring mysql log files
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, Kim Albee - 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
