1
vote
0answers
44 views

mysql server initialization error if I add 'log = “testfile_log.log” '

Guys I'm just trying to set my general log file set up like here http://stackoverflow.com/questions/5441972/how-to-see-log-files-in-mysql. so I added log = "testfile_log.log" as below to my.ini # ...
2
votes
1answer
281 views

mysql on freebsd makes 1GB binary log files every 20 minutes filling free disk space very fast

I have a problem with MySQL on FreeBSD. It makes a lot of 1GB binary files every 20 minutes and it's filling free disk space rapidly. -rw-rw---- 1 mysql mysql 1073741982 2013-09-14 18:26 ...
0
votes
1answer
160 views

How to disable MySQL logging?

MySQL in RHEL 5.5 logs it errors in /var/log/mysqld.log Which grows to mammoth size frequently. I need to disable it, but I failed to find any reference to do it. Finally I added below in my.cnf ...
-2
votes
1answer
134 views

.log parser (MySQL / Apache) [closed]

Is there any tool (GUI) to parse MySQL och Apache log files? to a more readable format? Have Googled a lot, can't find anything to answer my need. Appreciate your help.
0
votes
3answers
845 views

MySQL server not starting up

I have a server running CentOS 5.5 x86_64, and have recently installed MySQL Server via YUM, but when starting the server I get: [root@server etc]# service mysqld start Warning: World-writable ...
2
votes
3answers
265 views

mysql having loads

My website and server both are huge and heavy, my server is having 8GB RAM and 6 cores of processor. I got a mail from my hosting team, regarding the load of mysql database, Now-a-days my site is ...
1
vote
1answer
245 views

MySQL hangs up after binlog rotation

Been having a strange problem lately and wondered if anyone had any input. I'm running a mysql replication setup, with 1 master and 3 slaves. Every 3 hours or so the binlog on the master fills up and ...
3
votes
3answers
3k views

Can expire_logs_days be less than 1 day in MySQL?

So... yesterday I received an "after the fact email" about a campaign that has started for one of the services that I run. Now the DB server is getting hammered, hard, to the tune of about 300mb/min ...
3
votes
3answers
1k views

What are these files ,can I delete them manually?

[root@jiaoyou mysql]# pwd /var/lib/mysql [root@jiaoyou mysql]# ls -ls 338256 -rw-rw---- 1 mysql mysql 346030080 2010-04-22 08:08 ibdata1 626812 -rw-rw---- 1 mysql mysql 641222072 2010-01-26 07:17 ...
1
vote
2answers
648 views

Is there a tool to filter the MySQL slow query log based on database?

I'm currently trying to tune the performance of a single database (actually, a set of similar databases), but the slow query log has a bunch of data for other databases that I'm not currently ...
1
vote
1answer
599 views

Can't start MySql log slow queries ON

I'm trying to log mysql slow queries, but I can't turn it on, I will explain all my steps: I Edit my.cnf and add the following lines long_query_time = 1 slow_query_log_file = ...
2
votes
2answers
583 views

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a ...
39
votes
1answer
38k views

InnoDB: Error: log file ./ib_logfile0 is of different size

I just added the following lines in /etc/mysql/my.cnf after I converted one database to use InnoDB engine. innodb_buffer_pool_size = 2560M innodb_log_file_size = 256M innodb_log_buffer_size = 8M ...
0
votes
4answers
814 views

How to find out where or if MYSQL5 logs are stored on a machine WHM/Cpanel

I have a WHM/Cpanel re-seller hosting account on a virtual private server (Linux). I have root access to the machine via SSH I am trying to locate a file that contains information that will help ...
0
votes
2answers
162 views

Lots of tiny mysql-bin.NNNN files

We're using mysql 5.0.somethin with a binary log and replication. However /var/log/mysql is full of lots of tiny 141 byte sized mysql-bin.NNNNN files. using mysqlbinlog I can see that they are empty ...
18
votes
6answers
26k views

Where is my mysql log on OS X?

I checked /var/log and /usr/local/mysql and i can't seem to find the log. I am trying to troubleshoot an error establishing a database connection with a php function.