Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Matt Juszczak
arski" To: "NYPHP Talk" Sent: Tuesday, September 7, 2010 2:43:51 PM Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log MySQL does rotate the slow query log at least on my systems it is automated.  I did a quick look at the MySQL man pages just to verify if it does

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Donald J. Organ IV
Just edit the logrotate config for the mysql logs and change the create line. From: "Anthony Wlodarski" To: "NYPHP Talk" Sent: Tuesday, September 7, 2010 2:43:51 PM Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log MySQL does rotate the slow quer

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Anthony Wlodarski
ng to be on the aforementioned. -Original Message- From: "Matt Juszczak" Sent: Tuesday, September 7, 2010 2:36pm To: "NYPHP Talk" Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log But that permission won't hold if/when MySQL rotates/re-creates the

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Matt Juszczak
t;Matt Juszczak" Sent: Tuesday, September 7, 2010 2:29pm To: "NYPHP Talk" Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log Our setups are puppetized. There is a standard directory for MySQL log information. As we don't want to allow sudo for users just to see th

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Anthony Wlodarski
Then 755 should be appropriate. -Original Message- From: "Matt Juszczak" Sent: Tuesday, September 7, 2010 2:29pm To: "NYPHP Talk" Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log Our setups are puppetized. There is a standard directory for MySQL l

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Matt Juszczak
t: Tuesday, September 7, 2010 2:09pm To: talk@lists.nyphp.org Subject: [nyphp-talk] MySQL slow query log/general mysql log Hi folks, Has anyone ever seen any negative effects of changing the permissions of the MySQL slow query log (not changing umask or anything like that) once MySQL has created the file? I&#

Re: [nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Anthony Wlodarski
SQL Daemon will bark about permissions to the file as they have access to the log by default. -Original Message- From: "Matt Juszczak" Sent: Tuesday, September 7, 2010 2:09pm To: talk@lists.nyphp.org Subject: [nyphp-talk] MySQL slow query log/general mysql log Hi folks, Has anyo

[nyphp-talk] MySQL slow query log/general mysql log

2010-09-07 Thread Matt Juszczak
Hi folks, Has anyone ever seen any negative effects of changing the permissions of the MySQL slow query log (not changing umask or anything like that) once MySQL has created the file? I'd like to make it 755 to allow for global read only access. -Matt ___