Sunday, May 27, 2012

Mysql 5.0 Function and Operator Reference


Too long to paste here... please refer to the following link
http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html

Check open files setting of Fedora 13

1. List all the settings
ulimit -a

2. change the limit of maximum open files setting
ulimit -n [number]

The smaller open files number will cause a JAVA procedure throw exception like

 Java.net.SocketException: Too Many Open Files?

Checkout the current open files number per process in fedora


lsof -p [pid]