Still water run deep

How to calculate a good InnoDB log file size

摘要： Peter wrote a post a while ago aboutchoosing a good InnoDB log file size.Â Not to pick on Peter, but the post actually kind of talks about a lot of th... 阅读全文

posted @ 2014-12-08 01:26 Still water run deep 阅读(259) 评论(0) 推荐(0) 编辑

Measuring the amount of writes in InnoDB redo logs

摘要： Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the redo logs. You can ... 阅读全文

posted @ 2014-12-07 20:15 Still water run deep 阅读(305) 评论(0) 推荐(0) 编辑

pyzmq missing when running ipython notebook

摘要： Q:I can run iPython, but when I try to initiate a notebook I get the following error:~ ipython notebook Traceback (most recent call... 阅读全文

posted @ 2014-11-08 01:26 Still water run deep 阅读(575) 评论(0) 推荐(0) 编辑

在CentOS上安装Python

摘要：首先我们需要在服务器上安装一个比较新的 Python，CentOS 5.8 默认装的 Python 是 2.4.3。[root@nowamagic ~]# python -VPython 2.4.3我们需要自己安装Python 2.7.5。但是值得注意的是，我们必须不能破坏系统的环境。因为几个关键的... 阅读全文

posted @ 2014-11-07 22:47 Still water run deep 阅读(332) 评论(0) 推荐(0) 编辑

pip使用报错【cannot import name HTTPSHandler】

摘要： python2.7，报错如下：Traceback (most recent call last): File "/usr/local/bin/pip", line 9, in load_entry_point('pip==1.4.1', 'console_scripts', 'pip')() F... 阅读全文

posted @ 2014-11-07 22:44 Still water run deep 阅读(5623) 评论(0) 推荐(0) 编辑

Is it possible to configure PostgreSQL to automatically close idle connections?

摘要： 1、use pgbouncerAs new connections/transactions/statements arrive, the pool will increase in size up to thedefined user maximums. Those connections wil... 阅读全文

posted @ 2014-11-02 11:29 Still water run deep 阅读(544) 评论(0) 推荐(0) 编辑

How to drop a PostgreSQL database if there are active connections to it?

摘要： 1、PostgreSQL 9.1 and below:SELECT pg_terminate_backend(pg_stat_activity.procpid)FROM pg_stat_activityWHERE pg_stat_activity.datname = 'TARGET_DB' AND... 阅读全文

posted @ 2014-11-01 19:30 Still water run deep 阅读(320) 评论(0) 推荐(0) 编辑

pgbouncer配置

摘要： DESCRIPTIONpgbounceris a PostgreSQL connection pooler. Any target application can be connected topgbounceras if it were a PostgreSQL server, andpgboun... 阅读全文

posted @ 2014-11-01 16:18 Still water run deep 阅读(423) 评论(0) 推荐(0) 编辑

python命令行添加Tab键自动补全

摘要： 1、编写一个tab的自动补全脚本,名为tab.py#!/usr/bin/python # python tab complete import sys import readline import rlcompleter import atexit import os # tab completio... 阅读全文

posted @ 2014-09-27 16:20 Still water run deep 阅读(2691) 评论(0) 推荐(0) 编辑

MySQL – optimizer_search_depth

摘要： Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with fore... 阅读全文

posted @ 2014-09-13 16:46 Still water run deep 阅读(1075) 评论(0) 推荐(0) 编辑

Still waters run deep