NEW

zabbix nagios互补

  Zabbix在监控自身上,有一些不方便的地方。   比如难用的agent.ping   这些地方,可以通过nagios来实现,达到无死角的监控。nagios一直给人高灵敏触发的感觉,简单,却不失强悍。   --鸽子--  
NEW

mysqld_safe error: log-error set to ‘/xx/log/mysqld.log’, however file don’t exists. Create writable for user ‘mysql’.

  使用最新版本的MySQL 5.7.17,在Centos 7.2 1511版本上,启动mysqld时,会遭遇下面错误:   mysqld_safe error: log-error set to '/xx/log/mysqld.log', however file don't exists. Create writable for user 'mysql'.   需要手动创建一下此日志文件。   在之前的版本上,没有此问题。如5.7.14 同样的Centos版本。   --鸽子--  
NEW

mysql中的delete与truncate执行时间说明

    MySQL中,有时会发现truncate操作要比delete操作还要慢。从Oracle的角度,这是让人很疑惑的。   正常情况下,truncate table的效率要高于delete,以下是官方文档中的解释:   Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.   When used with partitioned tables, TRUNCATE TABLE ...
NEW

chronyd[747]: Source 85.199.214.100 replaced with 54.209.10.149

  Jan 20 10:05:51 centos7-100-44 dbus-daemon: dbus[707]: [system] Successfully activated service 'org.freedesktop.problems' Jan 20 10:07:06 centos7-100-44 chronyd[747]: Source 85.199.214.100 replaced with 54.209.10.149 Jan 20 10:07:06 centos7-100-44 chronyd[747]: Source 85.199.214.100 replaced with 54.209.10.149 Jan 20 10:08:28 centos7-100-44 dbus[707]: [system] Activat...

ERROR 1396 (HY000): Operation CREATE USER failed for

    在创建用户时:ERROR 1396 (HY000): Operation CREATE USER failed for   select user,host from mysql.user查询发现已经存在。   当前版本: mysql> select version(); +-----------+ | version() | +-----------+ | 5.6.31 | +-----------+ 1 row in set (0.07 sec) mysql>   刷新一下权限即可。 mysql> flush privileges; Query OK, 0 rows affected (0.06 sec) ...

max_binlog_size 1G 超过最大尺寸的说明

  If a write to the binary log causes the current log file size to exceed the value of this variable, the server rotates the binary logs (closes the current file and opens the next one). The minimum value is 4096 bytes. The maximum and default value is 1GB.   A transaction is written in one chunk to the binary log, so it is never split between several binary logs. ...

libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred” on RHEL5/OEL5 for 10.2 x86 or x86_64 install

  "Exception java.lang.UnsatisfiedLinkError: ../jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred" on RHEL5/OEL5 for 10.2 x86 or x86_64 install   APPLIES TO:   Oracle Universal Installer - Version 10.2.0.1 to 10.2.0.5 [Release 10.2] Oracle Database - Standard Edition - Version 10.2.0.1 to 10.2.0.5.0 [R...

ORA-29279 Using UTL_SMTP to Send Email via Email server Requiring Authentication

    APPLIES TO:   PL/SQL - Version 9.2.0.4 and later Information in this document applies to any platform. *** Checked for relevance on 26-Oct-2015***   SYMPTOMS   Using UTL_SMTP to send email via an email server that requires authentication when sending email to an external email address fails with following error: ORA-29279: smtp permanent error: 5...

测试udp端口状态 – nc

  对于tcp 端口,可以使用telet命令。   对于udp,可以使用nc   [root@gezi ~]# nc -u -vvv vpn.gebiji.com 1194 Ncat: Version 6.40 ( http://nmap.org/ncat ) libnsock nsi_new2(): nsi_new (IOD #1) libnsock nsock_connect_udp(): UDP connection requested to vpn.gebiji.com:1194 (IOD #1) EID 8 libnsock nsock_trace_handler_callback(): Callback: CONNECT SUCCESS for EID 8 [223...