jason

我的搜藏

文章列表

2009年07月05日星期日 01:19

在show innodb status　的结果中有这样一段信息。有些mysql系统中hash searches/s　这个值很高，有些mysql系统中就不会很高。

INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s

官方手册中有这样的

阅读全文>>

类别：数据库 | 评论(0) | 浏览()

记录下mysql innodb出错，不知道怎么解决这个问题

2009年06月26日星期五 09:55

InnoDB: End of page dump
090626 9:14:39 InnoDB: Page checksum 1782824756, prior-to-4.0.14-form checksum 117720807
InnoDB: stored checksum 517774722, prior-to-4.0.14-form stored checksum 117720807
InnoDB: Page lsn 22 3649314269, low 4 bytes of lsn at page end 3649314269
InnoDB: Page number (if stored to page already) 211,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 420
InnoDB: Page may be an update undo log page
InnoDB: Page may be an in

阅读全文>>

类别：Mysql | 评论(0) | 浏览()

“Show profile”+“Information_schema.profiling”

2009年06月23日星期二 09:44

Starting with version 5.1.28, there is a new table INFORMATION_SCHEMA.PROFILING and a new statement SHOW PROFILE(S). Basic information is in the reference manual and in an introductory article. But I don’t think that’s adequate for everyone. I’ll try here to give some non-basic informa

阅读全文>>

类别：Mysql | 评论(0) | 浏览()

bash 快捷键

2009年06月21日星期日 10:44

http://www.bigsmoke.us/readline/shortcuts

<

阅读全文>>

类别：Shell | 评论(0) | 浏览()

jpegsrc安装错误解决

2009年06月19日星期五 10:19

jpegsrc.v6b.tar.gz

# ./configure
checking host system type... Invalid configuration `x86_64-unknown-linux-gnu': machine `x86_64-unknown' not recognized

解决办法：
#cp /usr/share/libtool/config.guess .
#cp /usr/share/libtool/config.sub .
#./configure --enable-shared --enable-static
#make
#make install

类别：Linux | 评论(0) | 浏览()

awk 间接引用变量方法

2009年05月09日星期六 17:43

# num=2;echo 5164|awk -F "" '{print '\$${num}'}'
1

# num=2;echo 5164|awk -F "" "{print \$${num}}"
1

类别：Shell | 评论(0) | 浏览()

关于mysql sending data 状态

2009年05月09日星期六 14:40

最近，有两次Tomcat 响应很慢，直到宕机。期间登录mysql server ，使用show processlist均能看到大量的sending data 状态。查看官方的关于sending data说明：

Sending data

The thread is processing rows for a SELECT statement and also is sending data to the client.

意思是正在将查询结果往客户端发送。

阅读全文>>

类别：数据库 | 评论(0) | 浏览()

sed转换日期格式

2009年05月07日星期四 16:01

下面脚本是将日期格式为DD/MM/YYYY 转化成格式为yyyy-mm-dd
sed 's#$[0-9]\{2\}$/$[0-9]\{2\}$/$[0-9]\{4\}$#\3-\2-\1#g;1d'

类别：Shell | 评论(0) | 浏览()

2.6内核udev漏洞

2009年04月24日星期五 22:48

在openSUSE 10.2 (i586) 测试成功。恐怖！！！！


#!/bin/sh
# Linux 2.6
# bug found by Sebastian Krahmer
#
# lame sploit using LD technique 
# by kcope in 2009
# tested on debian-etch,ubuntu,gentoo
# do a 'cat /proc/net/netlink'
# and set the first arg to this
# script to the pid of the netlink socket
# (the pid is udevd_pid - 1 most of the time)
# + sploit has to be UNIX formatted text :)
# + if it doesn't work the 1st time try more often

阅读全文>>

类别：Linux | 评论(0) | 浏览()

detail about /proc/diskstats

2009年04月14日星期二 11:16

The command iostat can display the I/O performance and status, but sometimes the administrators needs to provide more information about the disk status. In such cases the file /proc/diskstats can be helpful. Below is a example of /proc/diskstats after issuing cat /proc/diskstats:



# cat

阅读全文>>

类别：Linux | 评论(0) | 浏览()