hoverruan · September 14, 2012 14:42 · hoverruan · Sep 17, 2012
diff --git a/create_tables.sql b/create_tables.sql
 use test;

 create table rs_myisam (
  follower_id bigint(20) not null,
  target_id bigint(20) not null,
  created_at datetime not null,
  primary key(follower_id,target_id)
 ) engine=MyISAM default charset=utf8;

 create table rs_innodb (
  follower_id bigint(20) not null,
  target_id bigint(20) not null,
  created_at datetime not null,
  primary key(follower_id,target_id)
 ) engine=InnoDB default charset=utf8;
diff --git a/insert_data.py b/insert_data.py
 import MySQLdb as mysql
 import sys

 def insert_data(table):
 	try:
 		my_conn = mysql.connect(host='localhost', user='root', passwd='', db='test')
 		cursor = my_conn.cursor()

 		my_conn.autocommit(False)
 		for i in range(1000000):
 			id = i + 1
 			cursor.execute(
 				'insert into %s (follower_id, target_id, created_at) values(%d, %d, now())' %
 				(table, id, id))
 			if (id % 500) == 0:
 				my_conn.commit()
 		my_conn.commit()
 	finally:
 		my_conn.close()

 	print 'Done'

 if __name__ == '__main__':
 	insert_data(sys.argv[1])
diff --git a/log.md b/log.md
	use test;

	create table rs_myisam (
	follower_id bigint(20) not null,
	target_id bigint(20) not null,
	created_at datetime not null,
	primary key(follower_id,target_id)
	) engine=MyISAM default charset=utf8;

	create table rs_innodb (
	follower_id bigint(20) not null,
	target_id bigint(20) not null,
	created_at datetime not null,
	primary key(follower_id,target_id)
	) engine=InnoDB default charset=utf8;
	import MySQLdb as mysql
	import sys

	def insert_data(table):
	try:
	my_conn = mysql.connect(host='localhost', user='root', passwd='', db='test')
	cursor = my_conn.cursor()

	my_conn.autocommit(False)
	for i in range(1000000):
	id = i + 1
	cursor.execute(
	'insert into %s (follower_id, target_id, created_at) values(%d, %d, now())' %
	(table, id, id))
	if (id % 500) == 0:
	my_conn.commit()
	my_conn.commit()
	finally:
	my_conn.close()

	print 'Done'

	if __name__ == '__main__':
	insert_data(sys.argv[1])