Posts Tagged mysql

focus on security of Linux this weekend

Posted by edyliu in Linux_D on 2009-04-26

focus on security of Linux this weekend.

APF (Advanced Policy Firewall) and more tools

http://www.rfxn.com/projects/

there are all written in shell, such as APF based on iptables. good example in sys admin with shell.

OSSEC is an Open Source Host-based Intrusion Detection System.
It performs log analysis, file integrity checking, policy monitoring, rootkit detection, real-time alerting and active response.It runs on most operating systems, including Linux, MacOS, Solaris, HP-UX, AIX and Windows.
it is C/S model, just one server and server agentd, can monitor the system.

http://www.ossec.net/


Some tips on optimize the MySQL database

MySQL Performance Tuning Primer Script – http://www.day32.com/MySQL/

MySQLTuner – http://rackerhacker.com/mysqltuner/

MONyog – MySQL Monitor and Advisor – http://www.webyog.com/en/

More links:

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB

http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php

http://hackmysql.com/mysqlreport

http://www.mysqlperformanceblog.com/tools/

,

No Comments

mysqlbinlog的日志

Posted by admin in LAMP on 2009-01-19

mysql的一些事件都以binary的格式存贮，通过mysqlbinlog这个工具来实现的。
mysqlbinlog可以用于Replication和数据库的恢复
这里主要是说一下mysqlbinlog日志的清理

mysqlbinlog日志的清除
mysql -uroot
PURGE {MASTER | BINARY} LOGS TO ‘log_name’
PURGE {MASTER | BINARY} LOGS BEFORE ‘date’
用于删除列于在指定的日志或日期之前的日志索引中的所有二进制日志。这些日志也会从记录在日志索引文件中的清单中被删除，这样被给定的日志成为第一个。
eg：
PURGE MASTER LOGS TO ‘mysql-bin.030′;
PURGE MASTER LOGS BEFORE ’2009-01-10 11:00:00′; Read the rest of this entry »

No Comments