Questions tagged [log]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
3answers
4k views

MySQL general log

Is there away to have MySQL dump its log to a remote MySQL server? I would like to audit MySQL connections but I don't want the server to store all the information local on its own hardware.
6
votes
1answer
23k views

The InnoDB log sequence number is in the future

Our site was getting intermittent database errors and I asked my webhost to check what's happening. After some inspection they found that the database has few issues and tried repairing it. Finally I ...
2
votes
1answer
204 views

Why is my transaction file growing when db is in simple mode and there are no waiting transactions

I noticed that my database log file has reached 160GBs. My database is in simple recovery mode and I used the following query to see if there are any waiting transactions. SELECT d.name,d....
20
votes
3answers
71k views

How to Log All mysql queries into log file?

I am using Mysql 5.6.12 under Wamp server environment. Now I want to log All queries into ".log" file, the queries which are running by PHP or from PHPMyAdmin, I want to log them...
19
votes
7answers
114k views

Error Log Location?

Does MySQL write any log file? If yes, what is the path of it (on ubuntu/Linux)?
2
votes
1answer
7k views

Analyse MySQL General Query Log in Real-time?

We want to use mysql general query log to do real-time monitoring and auditing. Currently our approach is: set general_log=on; sleep 15m; set general_log=off; scp & rm xxx.log; set general_log=...
7
votes
1answer
11k views

What is log sequence number ? How it is used in MySQL?

Can anybody give an example or scenario of log sequence number(LSN) used in MySQL
6
votes
1answer
3k views

How to log all SQL queries for a single connection or user or client host?

Is there a way to log all SQL queries in Postgres 9.3.9 for a single connection or user or client host? In other words, I want log_statement = all but only for a certain username or client hostname ...
3
votes
1answer
1k views

SQL Server Log Shipping Randomly Stops Copying and Restoring

I'm fairly new to Log Shipping but have configured a few with no issues, however I have a server sitting on SQL 2008 R2 with 6 databases on there, all 6 of these are supposed to be log shipping. The ...
3
votes
2answers
16k views

Mariadb - Variable 'innodb_log_file_size' is a read only variable

Im using mariadb 10.0.29, I need to change the innodb file size to 256M, default size 50M, My config file is located on /etc/mysql/mariadb.conf.d/50-server.cnf I have added the below line, but it ...
3
votes
2answers
4k views

Data lost in MySQL InnoDB after crash

I found a 6-days rollback in a MySQL 5.6 community edition server installation. It seems that some logs were lost, and I cannot understand why. 2013-12-22 20:38:54 380 [Note] Plugin 'FEDERATED' is ...
3
votes
1answer
9k views

Find queries executed by an user in sql server

I want to find all the queries executed by an particular user in a database over a period of time. I learnt about trace and XEvents, but these are not setup yet, Will i be still able to get the ...
1
vote
1answer
77 views

MariaDB hidden disk usage for log dir

We have a simple master/slave cluster in our environment which is sets up on Ubuntu 20.04 and MariaDB 10.5: MariaDB [(none)]> SELECT VERSION(); +--------------------------------------------+ | ...
1
vote
1answer
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. ...
1
vote
0answers
366 views

mysql.sock missing

I started my MYSQL database this morning but failed. And I tried all means I can think of: chown -R mysql.mysql /var/lib/mysql chmod g+w /var/run/mysqld chgrp mysql /var/run/mysqld chmod -R 755 /var/...