Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
45
questions
117
votes
5
answers
233k
views
How to safely change MySQL innodb variable 'innodb_log_file_size'?
So I'm fairly new to tuning InnoDB. I'm slowly changing tables (where necessary) from MyIsam to InnoDB. I've got about 100MB in innodb, so I increased the innodb_buffer_pool_size variable to 128MB:
...
- 23.4k
14
votes
3
answers
38k
views
How do I output MySQL logs to syslog?
I want to use syslog for logging MySQL(5.1.41) on Ubuntu(10.04 LTS).
I found information that output error log to syslog.
[mysqld_safe]
syslog
But I want to use syslog for logging general logs and ...
- 345
4
votes
1
answer
15k
views
How to enable MySQL general log?
I would like to enable the MySQL General Log to view all the (slow) queries. I'm using XAMPP as server and have no idea how to enable it. I can't find a good guide on the internet.
Can someone help ...
- 143
5
votes
3
answers
4k
views
Log MySQL DB changing queries and users
For security reasons I need a server-side (running Debian 6.0 Squeeze) logging of all queries that may have changed the content of a MySQL DB (v. 5.1) and the user who issued it. I had to rule out
...
- 205
2
votes
2
answers
7k
views
Stress test MySQL with queries captured with general log in MySQL
Is there any tool available which can do stress testing using the log file created by MySQL general log?
After a lot of search on google I found few stress testing tools which only use some benchmarks ...
- 241
9
votes
3
answers
768
views
Need Help Troubleshooting Sql Server 2005 Deadlock Scenario
I am running into a deadlock scenario where the only participants in the deadlock appear to be a single table and a single stored procedure that deletes from that table. I drew that conclusion based ...
- 93
6
votes
1
answer
7k
views
MySQL Slave Relay Logging but not logging Binary Log
I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
- 63
2
votes
1
answer
546
views
mysql emits BINLOG rows even though binlog_format=STATEMENT
We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)
According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
- 175
70
votes
6
answers
205k
views
Disable MySQL binary logging with log_bin variable
Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled:
log_bin = /var/log/mysql/mysql-bin.log
When I want to ...
- 2,328
7
votes
2
answers
4k
views
Investigate peak in MySQL throughput
Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
- 349
3
votes
1
answer
10k
views
Mysql master-master replication auto flush old logs
I have mysql-5.1.41 master-master setup running on ubuntu machines and below is the configuration of a master:
skip-host-cache
skip-name-resolve
event_scheduler = ON
max_connections = 500
...
- 165
3
votes
1
answer
2k
views
How to do MySQL User Accounting
I can't seem to find any information on this anywhere. I found a question here called Monitor MySQL activity per database? but that's not quite the answer either.
I'd like to be able to log the ...
- 241
3
votes
2
answers
686
views
Shrinking log file
Some of my SQL Server's log files (ldf) are huge, like 5GB. I Found an article about shrinking, but am not sure why the author repeated DBCCSHRINKFILE 6 times.
Can someone please confirm and suggest ...
- 53
2
votes
2
answers
3k
views
What is running right now?
I know I can use "show processlist" to see what is running when I'm in the office. How can I see what is running when I'm not there.
Something is running on my server at 3am every morning that is ...
- 87
23
votes
1
answer
24k
views
log_min_duration_statement setting is ignored
I am running Postgresql 9.1 on Ubuntu. Exact Postgresql version is 9.1+129ubuntu1 as my package manager shows.
I have 2 databases that are actively in use and they are used from a remote server.
I ...
- 459
21
votes
1
answer
56k
views
What exactly are iblog files in mysql
I would like to understand these ibdata files as these play vital role in the crash recovery procedure. I could not find proper resources over the web for this.
- 804
13
votes
3
answers
17k
views
How best to maintain SQL log file sizes
I'm somewhat of a new DBA and I'm managing a SQL Server 2012 instance that has a fair amount of activity. I'm running in Full Recovery mode because we need point in time recovery.
Right now, I'm ...
- 705
11
votes
1
answer
52k
views
mysql logging activity from specific user or ip
I have mysql server.
The server is accessed by my application, and by external auditor (person using mysql workbench).
The auditor has specific user and password and dedicated IP and it is granted ...
- 223
9
votes
3
answers
24k
views
Transaction Log Maintanance While Using AlwaysOn Availability Group
We are using HADR ( AlwaysOn Availability Group) feature of SQL Server 2012.
Server and AG Configuration as below:
SQL12_SRV1
--> AG1(PRIMARY) - SYNC
-->> DBTest
SQL12_SRV2
--> AG1(SECONDARY)
...
4
votes
1
answer
2k
views
How are binlogs updated for MySQL temporary tables?
If I use CREATE TEMPORARY TABLE, can I write and update this MySQL table and know that none of it will be stored to the binlogs?
If I use data from the temp table to write to a non-temp table, is the
...
- 675
3
votes
2
answers
1k
views
Redirecting MySQL errors and slow logs into another database
I am running a number of MySQL servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into an external database.
...
- 741
3
votes
1
answer
11k
views
Very Large Log Files
I'm running Windows Server 2008 R2 and executed a large query by accident. Next, the sever ran out of hard drive space.
I now have a file in my administrtor documents (log.log) that is over 18GB. I ...
- 31
2
votes
1
answer
7k
views
log_warnings doesn't seem to work for aborted connections in MySQL 5.1
The docs for 5.1 say that I can set log_warnings = 2 to capture Aborted_connects in the error log. This bug report suggests that this was only merged into 5.5 and 6.0 (and maybe 5.2) but not into 5.1....
- 162
1
vote
2
answers
4k
views
MySQL (on Windows) general log too large to rotate properly?
First off, I'm not sure if this should go to Server Fault or Database Administrators. It could be a Windows Server 2008R2 problem. But I am asking here first in the chance that someone else running ...
- 123
1
vote
1
answer
287
views
Why am I able to create MV logs using PK — even though there is no PK?
I have a table that does not have a primary key:
I'm able to create MV logs on the table — without specifying whether to use the primary key or the rowid:
create materialized view log on maximo....
- 1,447
23
votes
3
answers
58k
views
MySQL InnoDB page_cleaner settings might not be optimal
Seeing this note in mysqld.log:
[Note] InnoDB: page_cleaner: 1000ms intended loop took 15888ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
There seems to be ...
- 342
10
votes
2
answers
13k
views
MySQL binary logs - skip a table
Is there a way to skip a specific table in the binary logs?
I've got binary logs configured as my incremental backup strategy between nightly backups. But we have one huge reference table that we're ...
- 531
8
votes
2
answers
59k
views
Flush/Clean MySql ib_logfile0 ib_logfile1
Is there a way to flush ib_logfile0 and ib_logfile1 without dumping the tables to a .sql file, deleting, then re-inserting? Somebody entered a couple plain text credit card numbers into the customer ...
- 183
5
votes
2
answers
6k
views
Large files in wamp\bin\mysql\mysql5.5.24\data directory
I have discovered these files located in the wamp\bin\mysql\mysql5.5.24\data folder on my Windows 2008 server.
They are consuming about 22 GB on a 40 GB drive.
I am using a LMS called moodle, that ...
4
votes
2
answers
12k
views
SQL Server : log folder too large
Please note that I'm not talking about transaction logs. I'm referring to a folder within SQL Server called 'Log' where ErrorLog and SQLDrmp files exists.
Well, the fact is that this folder is ...
- 217
4
votes
1
answer
3k
views
Why do I have to backup a transaction log twice for it to shrink?
This question was attempted twice on experts-exchange with no real answer.
I know that I should not shrink the log file - that is not the question.
If you feel like answering that one should not do ...
- 1,365
3
votes
2
answers
7k
views
INT or TIMESTAMP for the change time column in a logging table?
We're having an argument over what to use for storing change date in a new log table for our site.
One side says, use INT for the timestamp, storing the UNIX timestamp. We can convert the datetime ...
- 642
3
votes
3
answers
1k
views
Trace and analyze logs on SQL Server
I am using an SQL Server 2012 on windows datacenter 2012
I have encountered a situation where i think some virus/sql injection had heart my database,
Some data on my table had changed to weird link'...
- 287
3
votes
2
answers
17k
views
mysql bin-log.index not found
I moved my bin-logs to a different folder:
log-bin = /storage/mysql/bin-log
log-bin-index = /storage/mysql/bin-log.index
When I try to start mysqld I get this:
/usr/libexec/mysqld: File '/storage/...
- 161
3
votes
1
answer
4k
views
What does the base64 BINLOG statements in mysqlbinlog output mean?
I have looked over the mysqlbinlog command as a candidate for rollback method from MySQL 5.5 to MySQL 5.0.
When I ran the command on one of the bin-log files in the MySQL 5.5 server, I've noticed ...
- 175
2
votes
2
answers
4k
views
MySQL flush logs, unknown error
I gave been trying to solve this for few days now, and cant seem to figure this out.
I have been trying to set log rotation for mysql slow using linux logrotate feature, and my script seems to get ...
- 741
2
votes
1
answer
3k
views
Can an active Postgres serverlog be truncated?
Running Postgres 9.1 on Ubuntu 14.10 LTS.
I've got an application running on a machine that's going to run out of diskspace soon. However, the application is in the middle of a crucial run that has ...
- 123
1
vote
1
answer
3k
views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
1
vote
1
answer
1k
views
How can I change SQL Agent Log file to use unicode format?
I've created a database with tables that heavily leverages nvarchar for most of the columns. One of the challenges I'm running into is that when I go to view the SQL Server Agent Log files, I get the ...
- 373
1
vote
1
answer
393
views
How to keep MySQL general_log after I restart my computer?
I use a statement set global general_log = 'ON' to enable the general_log on my computer.
After I restart or shutdown it, I have to run the statement again.
How can I config MySQL write general log ...
- 256
1
vote
2
answers
2k
views
Warnings: Why are statements with limit clause unsafe even if there isn't a limit?
I'm a bit irritated because of some warnings in mysql errorlog.
Example 1:
[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
The statement ...
- 637
1
vote
2
answers
10k
views
DB2 ROLLFORWARD option "TO END OF LOGS" - does it read archive logs?
I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find ...
- 685
1
vote
1
answer
2k
views
DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?
we must set our database from CIRCULAR to ARCHIVE mode in order to enable ONLINE backups.
Backups will be done every 1 day.
Database is now almost 30GB.
Database grows approximately 1GB per month.
...
- 685
1
vote
3
answers
7k
views
How to change the expiration date of binlog files?
I have a server with Ubuntu 18.04 and MySQL 8.0.11
I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate.
How to change the expiration date of binlog files ?
...
- 83
1
vote
1
answer
1k
views
How I create backup with backup by dump and WAL files in PostgreSQL?
I have a backup and WAL files, I like update my backup with WAL files. Anyone know how to do it?
Thanks
- 25