在128M的VPS上配置mysql+Tornado+Nginx笔记

Linux-128-Yearly
Guaranteed RAM 128MB
Burstable RAM 128MB
Disk Space 5GB
Bandwidth 250GB/Month
$10.00 USD/Annually

Instant Setup!
1vCPU
1 IP Address
SolusVM Control Panel

apt-get --purge remove apache2
apt-get --purge remove apache2.2-common

apt-get update

apt-get install mysql-server

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#
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
language	= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16K
max_allowed_packet	= 1M
thread_stack		= 64K
thread_cache_size       = 4
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 16
table_cache            = 8
thread_concurrency     = 2

sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
#
# * Query Cache Configuration
#
query_cache_limit	= 256k
query_cache_size        = 4M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin		= /var/log/mysql/mysql-bin.log
#expire_logs_days	= 2
#max_binlog_size        = 10M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name

#important
#skip-innodb
innodb = OFF
default_storage_engine = MyISAM

#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

service mysql restart

mysqladmin -u root -p var | grep have_innodb
| have_innodb   | DISABLED   |

apt-get install python-tornado

apt-get install nginx

# -*- coding: utf-8 -*-
from tornado import httpserver
from tornado import ioloop

def handle_request(request):
   message = "You requested %s\n" % request.uri
   request.write("HTTP/1.1 200 OK\r\nContent-Length: %d\r\n\r\n%s" % (
                 len(message), message))
   request.finish()

http_server = httpserver.HTTPServer(handle_request)
http_server.listen(8080)
ioloop.IOLoop.instance().start()

python tornado_test.py

You requested /

You requested /test

free
把free 结果输出到一个文件
free > freefile

total       used       free     shared    buffers     cached
Mem:        131072      34128      99944          0          0          0
-/+ buffers/cache:      34128      99944
Swap:            0          0          0

发表第一条评论！

提交

相关推荐

• 在国外vps 上配置nginx 作反向代理访问国外网站

  通过国外vps 上配置nginx 反向代理来访问国外网站，原理是利用反向代理。

  国外 vps nginx 反向 访问
• 基于tornado.websocket 的websocket 客户端

  一个简单的基于 tornado.websocket 的 websocket 客户端

  websocket tornado 客户端
• Tornado subprocess 系统调用非阻塞示例

  使用Tornado 子线程做非阻塞系统调用

  示例 Tornado subprocess 阻塞 调用
• tornado 实现服务器消息推送功能

  这篇文章介绍tornado 服务器消息推送功能服务器端与客户端实现的的方法。

  tornado 推送 服务器 功能 消息
• 关于Tornado asynchronous gen 的示例

  Tornado 请求异步非阻塞在3.0 前后写法稍有不同，下面对Tornado 请求异步非阻塞作一下总结学习。

  示例 asynchronous Tornado gen
• tornado websocket 客户端与服务器端示例

  最近在网上找了些websocket的资料看了下，node和tornado等等本身已经实现了websocket的封装，所以使用起来会比较简单，php如果想要写websocket还需要自己跑一整套流程，比较麻烦。

  服务器端 示例 websocket tornado 客户端
• 基于Comet的技术的Tornado 长连接实现

  基于Comet的技术主要分为流（streaming）方式和长轮询（long-polling）方式。

  Comet Tornado 连接 技术 实现
• tornado ajax 跨域处理

  下面介绍使用 tornado 做后端处理 ajax 跨域问题

  tornado 跨域 ajax 处理
• Tornado long poll & websocket 实现服务器推送技术

  这篇文章介绍用Tornado 通过long poll 和 websocket 两种方式实现服务器推送技术的经验。

  websocket long Tornado poll 推送
• Tornado 搭建基于 WebSocket 的聊天服务

  这年头 Python web 框架是有点泛滥了. 下面要介绍的是 facebook 的开源框架 tornado. 这东西比较简单, 而且自带 WebSocket 支持, 可以用它做个简单的聊天室.

  Tornado WebSocket 搭建 聊天 服务