[Maria-discuss] Aria_log file
How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.
Hello, Please try setting aria-checkpoint-interval to a higher value (in seconds). Philip Stoev ----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 6:49 PM Subject: [Maria-discuss] Aria_log file
How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Thanks, Philip! That indeed was the issue -- problem solved. Richard On Sep 25, 2011, at 12:02 , Philip Stoev wrote:
Hello,
Please try setting aria-checkpoint-interval to a higher value (in seconds).
Philip Stoev
----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 6:49 PM Subject: [Maria-discuss] Aria_log file
How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Glad to hear. I have filed a bug https://bugs.launchpad.net/maria/+bug/859051 because it seems to me that those writes should not happen if there was no database activity. Philip Stoev ----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: "Philip Stoev" <philip@stoev.org> Cc: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 8:18 PM Subject: Re: [Maria-discuss] Aria_log file
Thanks, Philip! That indeed was the issue -- problem solved.
Richard
On Sep 25, 2011, at 12:02 , Philip Stoev wrote:
Hello,
Please try setting aria-checkpoint-interval to a higher value (in seconds).
Philip Stoev
----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 6:49 PM Subject: [Maria-discuss] Aria_log file
How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I compiled Maria 5.3.2 on OS X 10.7.2 yesterday and I can happily report that this bug has been fixed. Thanks! Richard On Sep 25, 2011, at 01:23 PM, Philip Stoev <pstoev@askmonty.org> wrote: Glad to hear. I have filed a bug https://bugs.launchpad.net/maria/+bug/859051 because it seems to me that those writes should not happen if there was no database activity. Philip Stoev ----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: "Philip Stoev" <philip@stoev.org> Cc: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 8:18 PM Subject: Re: [Maria-discuss] Aria_log file
Thanks, Philip! That indeed was the issue -- problem solved.
Richard
On Sep 25, 2011, at 12:02 , Philip Stoev wrote:
Hello,
Please try setting aria-checkpoint-interval to a higher value (in seconds).
Philip Stoev
----- Original Message ----- From: "Richard Dunn" <ric.dunn@mac.com> To: <maria-discuss@lists.launchpad.net> Sent: Sunday, September 25, 2011 6:49 PM Subject: [Maria-discuss] Aria_log file
How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Philip Stoev -
Philip Stoev -
Richard Dunn