我用Django编写了一个服务器应用程序,并使用Tastypie向移动应用程序提供API,使用本地MySQL服务器来提供数据库。
似乎查询结果会在进程被关闭或结束之前一直被缓存。如果我在后端创建新用户,则只有在重新启动uWSGI或MySQL,或从不同的浏览器登录到后端时,该用户才会首次出现在列表中。
Mysql进程列表
似乎查询结果会在进程被关闭或结束之前一直被缓存。如果我在后端创建新用户,则只有在重新启动uWSGI或MySQL,或从不同的浏览器登录到后端时,该用户才会首次出现在列表中。
Mysql进程列表
41 example localhost:58747 example 13 Sleep
42 example localhost:58748 example 16 Sleep
如果我杀死处于“Sleep”状态的进程,它也将触发数据的刷新。
uWSGI配置
[uwsgi]
vhost = true
plugins = python
socket = /tmp/example.com.sock
master = true
enable-threads = true
processes = 2
wsgi-file = /var/sites/example-server/example/example/wsgi.py
virtualenv = /var/sites/example-server/PYTHON_ENV
chdir = /var/sites/example-server/example
touch-reload = /var/sites/example-server/example/reload
nginx配置
server {
client_max_body_size 20M;
listen 80;
server_name example.com;
access_log /var/log/nginx/example.com_access.log;
error_log /var/log/nginx/example.com_error.log;
location / {
uwsgi_pass unix:///tmp/example.com.sock;
include uwsgi_params;
}
location /media/ {
alias /var/sites/example-server/example/example/media/;
}
location /static/ {
alias /var/sites/example-server/example/example/static/;
}
}
my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
transaction-isolation = READ-COMMITTED
!includedir /etc/mysql/conf.d/
我该怎么做才能解决这个问题?
谢谢 Morten