db1's logs are currently being sent to /var/lib/mysql/.temp/ This needs to be moved to /tmp which should also be on different drives then /var/lib/mysql/ for best performance. It will require another outage.
Does this still apply now that db1 has been rebuilt? I don't remember where the logs were going before that.
Yeah, it seems it does. Though now the db1 logs are going to the default location and not .temp/
I'm not actively working on this so I'm going to unassign it.
I'll look at this as a post release thing
From what I can tell, mysql isn't currently logging queries, as the mysql user does not have write privileges on /var/log/mysqld.
The FS that /tmp and /var/log/mysqld are on different physical disks than /var/lib/mysql, so that sounds fine. After fixing the file permissions, the only thing to worry about would be log rotation, right? (I don't remember how large those logs ended up getting).
This doesn't seem to be true anymore, this ticket is superseded by #1499.
Login to comment on this ticket.