这里是openkava 的blog,关注程序开发的一切技术。 ZZ 表示转载的文章,如涉及版权,请和我联系删除。 在这里你可以看到关于以下技术的文章: 移动开发技术,ANDROID ,IOS,WINDOWS PHONE平台开发,企业ERP开发,动态脚本PYTHON ,OPENGL ES 3D技术,游戏开发技术,HTML5 ,JAVASCRIPT ,MYSQL,AMAZON EC2 ,GOOGLE GAE ,GOOGLE CLOUD SQL 等 。 本站发展历程: 2010年,正式把所有的blog移到这里,租用godaddy的空间,记录生活和工作上的一些心得。 下面是关于我的个人介绍,写在这里权当凑字数啦。 职业:软件开发,开发经验6年,管理经验3年; 工作上使用的技术:C#, SQL SERVER 个人使用的技术:PYTHON,PHP, CSS, JAVA ,ANDROID ,object-c 等等 联系我请发邮件:<a href=""><img class="alignnone size-full wp-image-96" title="邮箱" src="" alt="" width="174" height="24" /></a>

zz Vtocc - Frontend of High-Performance MySQL - Open Source China

Vtocc is the first available product of vitess. It serves as a frontend for MySQL, providing an RPC interface to receive SQL statements and transform them. It offers efficient handling of multiple large-scale database operation requests, with a concurrency processing capability of over 10k+. It also provides an SQL parser that allows the server to understand and intelligently optimize queries.

Vtocc has been used in large-scale production environments and is the core of YouTube's new MySQL service architecture.

Example code:

from vtdb import vt_occ2 as db

conn = db.connect('localhost:6510', timeout=5, dbname='mydb')

curs = conn.cursor()

curs.execute('select * from mytable limit 5', {})

print curs.description

for v in curs:

print v

print curs.rowcount

Main features:

A Python DBAPI 2.0 compatible client interface (

Understanding various HTTP and TCP-based protocols

Support for query variables and query caching to avoid repetitive SQL parsing and reuse query plans

Connection pooling

Transaction management, with the ability to limit concurrent transactions and manage transaction failures

DML annotations: Each DML will be rewritten and include a comment field at the end to identify the modified row records

Built-in fault tolerance

Query merging: The ability to reuse the results of an in-flight query for any subsequent requests received while the query is still executing

Ability to limit the number of query results, with an error thrown if exceeded

Ability to delete excessively long transactions

Ability to delete excessively long queries

Automatic cleanup of idle connections

Vtocc modules:


Method to obtain the source code: hg clone

Through Vtocc - High Performance MySQL Frontend - Open Source China.

Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.