http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/
Top 20+ MySQL Best Practices
Leave a reply
Self signed Web server certificate
http://www.akadia.com/services/ssh_test_certificate.html
http://wiki.nginx.org/HttpSslModule
an interesting observation about nginx location directive
We have following two location blocks in our nginx.conf file, if the block about “protected” is placed before the “.php” one, then php script inside the /protected directory wont be executed as php script.
How do I generate an .htpasswd file without having Apache tools installed?
http://wiki.nginx.org/Faq#How_do_I_generate_an_htpasswd_file_without_having_Apache_tools_installed.3F
Exclude a package from yum update
Common php compile errors and the corresponding missing lib
Common php compile errors and the corresponding missing lib
Continue reading
WordPress php upload error of “Missing a temporary folder”
When uploading an image in wordpress, got a “Missing a temporary” error?
Skype Mic static/distorted on Parallel windows 7 virtual machine
When having a audio chat on skype on Parallel Desktop Windows 7 Virtual machine. micro-phone input has a lot of static/distorted. How to fix?
Continue reading
A note on php-fpm Chroot
php-fpm is a fcgi process manager. it supports chroot of worker processes by use of chroot directive for each pool.
A note on Mysql Connectivity in Chroot
When mysql chroot and web server chroot are different, we can still connect to mysql in our web app using 127.0.0.1, i.e. via tcp/ip. But localhost/socket will not work, since the two chroots are different.
If mysql chroot is under web server chroot, We can then use localhost/socket to connect to mysql from within webserver chroot in our web app.
Performance wise, socket is better than tcp/ip due to the overhead of tcp/ip.