0
votes
1answer
32 views

My local MySQL server was temporary down for unknown reasons

My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details: This could be because you hit a bug. It is also possible that this ...
0
votes
1answer
70 views

mysql.slow.log is not created even though it's configured in /etc/my.cnf , what could be the reason?

This is the relevant section from /etc/my.cnf: [mysqld] slow-query-log = ON long_query_time = 2 log_slow_queries = /var/log/mysql-slow.log The problem is that file is ...
0
votes
0answers
20 views

Logging Apparently Not Working - Can't Set Configure Replication

I'm using a tutorial to set up a master (single) slave setup. When I run the command show master status; I get Empty set (0.00 sec). I have done a lot of research and believe that the log file I have ...
0
votes
1answer
105 views

Mysql general query log tool to play back queries in time?

I am trying to reproduce production activity in time for benchmarking purposes from the mysql general query log. I'd like to be able to use the date data from the log to reprduce the time intervals ...
0
votes
3answers
615 views

Why does MySQL Slow Queries Log not exist?

I was looking today on my CentOS server for a MySQL Slow Queries Log, but have had no luck finding the log. I even did a "SELECT SLEEP(2)" test in hopes to have this file created. Take note, I am not ...
0
votes
1answer
89 views

How make MySQL slow query log get the actual query param instead of N?

I'm seeing queries in my MySQL slow query log that have the character "N" instead of a specific value. Can I change that? I need in logs the real value with witch the query was executed. I'm using ...
0
votes
1answer
269 views

Daily queries log file

Has MySQL a daily log rotation system? like Apache that creates daily log files? I'm having a very hard time to find any good info about this. Win Server 2008 R2 MySQL 5.1.11 I'm logging all ...
0
votes
2answers
230 views

MySQL Error Log purge / log rotate

My MySQL enterprise server has limiting disk space for logging. Error log file increasing size day by day and difficult to limit the size of error log. Can I Limit MySQL Error Log file size? Is ...
1
vote
1answer
41 views

Mysql slow.log user specific

I use a slow.log logging on my MySQL server, to catch bottlenecks in my script, but at the same time, i use phpmyadmin on this server. My script and phpmyadmin has different MySQL user accounts and ...
0
votes
1answer
225 views

Limiting the MySQL error log file size

I'm using MySQL enterprise edition for large database. When running several queries following error message logged into error log file. Unsafe statement written to the binary log using statement ...
0
votes
1answer
62 views

Add causing php-script to mysql-slow.log

If you enable the line log_slow_queries = /var/log/mysql/mysql-slow.log in /etc/my.cnf or /etc/mysql/my.cnf then that will log all queries, that take longer than the setting in long_query_time. ...
0
votes
1answer
150 views

How can I estimate binlog size and whether binlogs should be on a separate disk?

We are about to setup MySQL Master-Slave replication on our production database. We intend to run backups from the slave (at the moment our master lags out for 15 mins every day whilst backups are ...
0
votes
1answer
50 views

Find source of failed mysql logins

I've been seeing the following log entry in /var/log/mysqld.log and am trying to pinpoint the source of the request: 130313 10:10:48 [Warning] Access denied for user 'admin'@'localhost' (using ...
0
votes
1answer
111 views

Mysql stops with no visible reason

Third day in a row I find my sites down. Reason: mysql not running. Doing sudo mysql restart — and everything is up again (for few hours). But why the hell mysql has stopped? Here are the last lines ...
1
vote
2answers
483 views

MYSQL logs of user activity by IP address [duplicate]

I have a website to which I have allowed someone to enter to make some modifications. However, I have discovered that they made changes that compromised the security of the website and I know that the ...
1
vote
1answer
185 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 ...
1
vote
2answers
2k views

MySQL log file disable

My question is how to stop logs on mysql log_error = /var/log/mysql/error.log i have commented already. with slow queries too. But i have one more log file in /var/lib/mysql/hostname.log with ...
0
votes
1answer
60 views

SSH logging to MySQL Database parallel to auth.log

As the title says, is there any way to force sshd logging (of authentication failures) to a MySQL table in addition to the /var/log/auth.log file ? *My Server is Debian Squeeze, openssh, mysql5, ...
2
votes
1answer
153 views

Why is MySQL writing hundreds of 125 byte binary log files?

My MySQL Master (with no connected slaves right now) writes out a 125 byte file every minute or so: -rw-rw---- 1 mysql mysql 125 2012-12-28 16:46 snapshot-mysql-v2-bin.004876 -rw-rw---- 1 ...
3
votes
1answer
2k views

Confirm that mysqli extension is not installed

Recently I discovered that mysqli extension is not installed in my server Centos version 2.6. I confirm it because I change the driver of db connection from mysqli to mysql and now works fine. So, is ...
0
votes
1answer
422 views

mysql log Queries for specific user

A number of database users have been configured on MySQL Server. Is there a way to log the queries of just one or some specific users and not all queries run on the server.
0
votes
1answer
79 views

Count large file downloads from apache logs in mysql

I want to count file downloads for about 10 different files that a client has asked for. We've generated a separate log format for the apache logs that can be loaded into a MySQL database. For such a ...
0
votes
3answers
107 views

MySQL and User level logging

I have been looking at logging only certain users activity in MySQL. I found that the logging could be enabled or disabled for all users but one of the service using the db does a lot of queries and ...
0
votes
1answer
755 views

MySQL slow query log logging all queries

We have a MySQL 5.1.52 Percona Server 11.6 instance that suddenly started logging every single query to the slow query log. The long_query_time configuration is set to 1, yet, suddenly we're seeing ...
0
votes
1answer
150 views

Where to find the terminal logs in Mysql

I connect to mysql client using the command mysql -uroot -p And I execute queries there. If I press the up arrow, i could see the history of almost all the queries there. Where will this query ...
3
votes
2answers
229 views

log slow queries killed before completion

Apparently, one of my colleagues killed a webserver which was making MySQL hang (locking other queries), rather then killing the specific query, and special great care was taken by him to forget any ...
1
vote
1answer
350 views

Mysql remote connections logging

I need to allow remote connections to my mysql server running on latest stable CentOS. I don't like this idea at all so I want at least to collect as much relevant information as possible. To be ...
2
votes
1answer
43 views

Want to establish what MySQL DBs are “old”

I want to put some (minimal) logging on our MySQL server, with the aim of determining which DBs on the server aren't being regularly accessed. We intend to log for approximately a month, and any DBs ...
2
votes
2answers
59 views

MySQL server database log

I have a website with MySQL database. Someone deleted 1,000 records from a table. Is there any way to find out who have deleted the records and when from the website? And from where the records were ...
0
votes
1answer
779 views

How do I view MySQL slow log?

# ls error.log mysql-slow.log.1.gz mysql-slow.log.3.gz mysql-slow.log.5.gz mysql-slow.log mysql-slow.log.2.gz mysql-slow.log.4.gz mysql-slow.log.6.gz This is what I see. How do I view ...
2
votes
0answers
244 views

Logging mysql queries under MAMP Pro (MAC)

I am using MAMP Pro 2.0.5 (latest) and copied the my-medium.cnf file and placed it into /mamp/conf/ and renamed it to my.cnf under the [mysqld] i placed log = ...
0
votes
2answers
742 views

Enabling general_log in MySQL 5.1.52 on RHEL6

So I am a bit on the fresh side of things when talking about Linux server management. I am currently trying to enable general logging for MySQL on a box I am managing that is running RHEL6. Based on ...
7
votes
2answers
1k views

Logging hurts MySQL performance - but, why?

I'm quite surprised that I can't see an answer to this anywhere on the site already, nor in the MySQL documentation (section 5.2 seems to have logging otherwise well covered!) If I enable binlogs, I ...
1
vote
1answer
212 views

Proftpd user-auth with mod_sql/mod_sql_passwd

I'm reading up how to interface ProFTPd with MySQL for an implementation I'm working on, I noticed it seems like all the example code or instructions I see have the user login field in MySQL set as ...
2
votes
1answer
200 views

Monitoring Innodb Lock Monitoring output?

I've found plenty of tools that will monitor the output of SHOW PROCESSLIST and SHOW INNODB STATUS but haven't really found much that indicates it will log, digest and summarize (optionally enabled) ...
1
vote
6answers
2k views

Free Web Based Server Log Viewer/Monitor [closed]

I'm not much of a server guy, but do need to monitor logs for my web server. Preferabbly, PHP, Apache and MySQL error logs. Could you guys offer any advice for free web-based solutions for monitoring ...
2
votes
1answer
193 views

How to stop logging activity from MySQL workbench?

I have enabled the query and slow_query logging in MySQL, but I'm getting new entries every second of the type: 2 Query show global status 110925 21:18:18 1 Query select 1 I've ...
-4
votes
2answers
456 views

Web server crashes after RAM memory gets exhausted at 99%?

I'm running an ecommerce website and it's been running fine for a while now, but lately it keeps on crashing on me. It seems like the RAM gets exhausted on the server and then the server stops ...
0
votes
1answer
350 views

How can I cap the MySQL query log size?

I have Investigated enabling MySQL query logging. At some point, soon, it would be nice to enable this on my companies production server so that if there is ever a question about queries run against ...
5
votes
2answers
1k views

How to log all the MySQL queries that waited for a table lock?

We are trying to diagnose a deadlock problem MySQL 5.0. Currently all the tables are MyISAM tables and so all the locks are table locks. We have a good table_locks_waited to table_locks_immediate ...
2
votes
2answers
1k views

MySQL - log every connections

I'd like to monitor a MySQL 5.0.77 server and log every incoming connection for a day. I need to know who is connecting to the database. I tried with the general logging but it's logging way too much ...
-4
votes
1answer
137 views

I got Putty installed need to SSH to my webhost to get MYSQL Error logs [closed]

I need the exact commands to type from the beginning in putty to first connect to my db and then to get the error logs contained in /var/lib/mysql/HOSTNAME.err file. Thanks
0
votes
1answer
222 views

A pseudo-Sql server to intercept and see all MySQL queries

I would like to setup a "pseudo-server" to intercept all the SQL queries made by my local application. The reason for that is that I can't administer the Mysql server, and it's difficult for me to ...
1
vote
1answer
68 views

MySQL Query log not getting purged

I had enabled MySQL Query Log for checking which queries are getting executed from our application at certain time interval. I wanted Logs to be refreshed for 3 days once, So I had enabled Expiry Log ...
5
votes
2answers
1k views

best practice for fixing mysql slow query log error 13

CentOS 5.5 MySQL 5.5 installed via a yum repository [ERROR] Could not use /var/log/mysqld.slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. ...
3
votes
1answer
145 views

MySQL Logging - Is it worth it?

If I were to enable MySQL logging by doing the following, what are the advantages and disadvantages? What do you do personally? general_log_file = /var/log/mysql/mysql.log general_log ...
1
vote
2answers
2k views

MySQL Binary Log activated = high-end server damn slow

On MySQL 5.1(.57-1.dotdeb), I have a ~2.0Gb database, and an average of ~350 requests per second. All is running fine if I don't activate the binary log. The CPU usage is decent (~15% of 1 CPU ...
3
votes
1answer
5k views

How can I get MySQL 5.5 to log warnings to one of the log files?

I have found various things that say that you can log warnings to the MySQL error log, but I have not been able to actually make it happen. I do have the error log working, and MySQL prints stuff to ...
2
votes
1answer
459 views

slow query logging in mysql server

I have installed MySQL Community Edition 5.1.41 on a windows 2000 server. In my.ini file I have enabled slow query logging and have redirected the output to a table.I have set the long_query_time to ...
0
votes
1answer
69 views

How to track down why my shared web host is losing data bound for mysql?

I use shared web hosting for a couple of Drupal sites, using my hosting provider's MySQL database server for storage. One of the sites recently sent me a few emails that should have been written to ...