聊逍遥兮容与诚既勇兮又以武，终刚强兮不可凌！

原文: [[http://www.ubuntugeek.com/emma-graphical-toolkit-for-mysql-database-developers-and-administrators.html]]
\\
emma是一个为MySQL数据库开发人员和DBA准备的图形工具包。 它提供了对话框，创建或修改MySQL数据库，表和关联的索引。 执行一个查询的结果显示，数据可以由用户编辑，它允许执行SQL语句。 SQL编辑器和结果都集中在查看选项卡。 并且可以将结果导出到CSV文件。 可以同时打开多个MySQL连接。 emma继承了yamysqlfront。

继续阅读 »

使用兼容mysql323的方式备份 \\
mysqldump ,--compatible=mysql323 \\
Mysql表引擎更改为InnoDB \\
alter table $TABLENAME type=InnoDB \\

继续阅读 »

原文地址：[[http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html |]] (长城之外)

译文：http://tech.it168.com/a2010/1027/1118/000001118500_all.shtml

关注两个项目：
[[http://developer.cybozu.co.jp/kazuho/2009/08/mycached-memcac.html|MyCached UDF]]

[[https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL|HandlerSocket-Plugin-for-MySQL]]

===== 环境 =====

硬件环境：

|型号 |CPU |内存 |网卡 |
|Dell PowerEdge \\ R410 |双路四核 \\ Xeon E5506 2.13G |8G ECC \\ DDR3 1333 MHZ内存 |Broadcom Corporation \\ NetXtreme II BCM5716 Gigabit Ethernet |

\\ 软件环境：

| 操作系统版本 |DB |
|Debian GNU/Linux \\ Lenny 5.0 amd64 |mysql Ver 14.14 Distrib 5.1.47, \\ for debian-linux-gnu (x86_64) using readline 5.2 |

经测试，
innodb_flush_log_at_trx_commit影响较大，\\
innodb_flush_log_at_trx_commit = 1(默认)时的测试情况：
{{{
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 43.718 seconds
Minimum number of seconds to run all queries: 43.718 seconds
Maximum number of seconds to run all queries: 43.718 seconds
Number of clients running queries: 2000
Average number of queries per client: 10

User time 0.10, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15784, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 63228, Involuntary context switches 1499
}}}
innodb_flush_log_at_trx_commit = 0(改动后)的测试情况：
{{{
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 4.469 seconds
Minimum number of seconds to run all queries: 4.469 seconds
Maximum number of seconds to run all queries: 4.469 seconds
Number of clients running queries: 2000
Average number of queries per client: 10

User time 0.18, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15480, Physical pagefaults 5, Swaps 0
Blocks in 736 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 61984, Involuntary context switches 2991
}}}

一、
Firefox的附加组件SQLite Manager，把除了typecho_options的表导出

typecho_comments.sql typecho_relationships.sql
typecho_contents.sql typecho_users.sql
typecho_metas.sql

二、
然后重新安装typecho源码，安装后用phpmyadmin清空各个表的内容，最后用phpmyadmin导入先前备份的五个sql文件即可