For Mysql, you can have better performance using the ARCHIVE engine (data are compressed but delete queries aren't available and select queries take much more time than Myisam..) combined the partionning feature (based on the day of year's parity or something...) in
5.1 version.<br>You won't need to lock any table, just drop the partition and recreate it.<br><br>It doesn't change anything about password security issues ;-)<br><br>Regards<br><br>Erwan<br><br><div><span class="gmail_quote">
2007/9/6, Alexander Clouter <<a href="mailto:ac56@soas.ac.uk">ac56@soas.ac.uk</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br><br>Alexander Clouter <<a href="mailto:ac56@soas.ac.uk">ac56@soas.ac.uk</a>> [20070906 14:15:58 +0100]:<br>><br>> Hi,<br>><br>> [snipped]<br>><br>> ======<br>> USE cheese-database;<br>> LOCK TABLES chedder READ;
<br>> DELETE........;<br>> UNLOCK TABLES;<br>> ======<br>><br>replace 'READ' with 'WRITE', or even 'LOW_PRIORITY WRITE'.<br><br>D'oh :)<br><br>> Then 'echo -e "[client]\npassword=<password>\n" > ~/.my.cnf' and then you
<br>> run (in a cron job):<br>><br>> $ cat cmds.sql | mysql -u <user><br>><br>just so you know, this all came from:<br><br><a href="http://dev.mysql.com/doc/refman/5.1/en/password-security.html">http://dev.mysql.com/doc/refman/5.1/en/password-security.html
</a><br><br>Cheers<br><br>Alex<br><br>> > -----Original Message-----<br>> > From: <a href="mailto:syslog-ng-bounces@lists.balabit.hu">syslog-ng-bounces@lists.balabit.hu</a> [mailto:<a href="mailto:syslog-ng-bounces@lists.balabit.hu">
syslog-ng-bounces@lists.balabit.hu</a>] On Behalf Of Geller, Sandor (IT)<br>> > Sent: Thursday, September 06, 2007 6:10 AM<br>> > To: Syslog-ng users' and developers' mailing list<br>> > Subject: Re: [syslog-ng] Log Rotation
<br>> ><br>> > Hello,<br>> ><br>> > > I am logging locally to<br>> > ><br>> > > destination hosts {<br>> > > file("/opt/log/HOSTS/$YEAR/$MONTH/$DAY/$HOST/$PROGRAM"
<br>> > > owner(root) group(root) perm(0600) dir_perm(0700) create_dirs(yes));};<br>> ><br>> > Why do you want to rotate these??? New files will be created every<br>> > day. Simply delete the old ones if you need to reclaim space.
<br>> ><br>> > > I am also logging to a mysql database<br>> > ><br>> > > destination d_mysql { pipe("/tmp/mysql.pipe" template("INSERT<br>> > > INTO logs (host, facility, priority, level, tag, date, time,
<br>> > > program, msg) VALUES ('$HOST', '$FACILITY', '$PRIORITY',<br>> > > '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC',<br>> > > '$PROGRAM', '$MSG');\n") template-escape(yes)); };
<br>> ><br>> > Sorry, I still don't understand what do you want to achieve.<br>> ><br>> > Log rotation or log retention ?<br>> ><br>> > regards,<br>> ><br>> > Sandor<br>
> > --------------------------------------------------------<br>> ><br>> > NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.
<br>> > _______________________________________________<br>> > syslog-ng maillist - <a href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a><br>> > <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">
https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>> > Frequently asked questions at <a href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a><br>> ><br>> > _______________________________________________
<br>> > syslog-ng maillist - <a href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a><br>> > <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng
</a><br>> > Frequently asked questions at <a href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a><br>> ><br>> ><br>> _______________________________________________
<br>> syslog-ng maillist - <a href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a><br>> <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng
</a><br>> Frequently asked questions at <a href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a><br>><br>><br>_______________________________________________<br>syslog-ng maillist -
<a href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a><br><a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>Frequently asked questions at
<a href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a><br><br></blockquote></div><br>