z4dUdvRa

1Mysql: What is the expected write performance on a fresh innodb table durng free server condition
2OS: ubuntu 10.04 
3Processor: 2 cores each with 2.6 GHz on same die
4RAM : 2GB RAM
5hard disc: 450GB
6Mysql version 5.1.61 
7innodb_buffer_pool_size = 8MB
8innodb_log_buffer_size = 8MB
9innodb_log_buffer_size = 1
10log-bin : YES
11rpm: 7200
12	
13Thanks in advance.
14Regards,
15UDAY
16	
17drop table if exists users;
18create table users
19(
20user_id int unsigned not null auto_increment primary key,
21username varchar(32) unique not null
22)
23engine=innodb;
24
25drop procedure if exists load_test_data;
26
27delimiter #
28create procedure load_test_data()
29begin
30
31declare v_max int unsigned default 10000;
32declare v_counter int unsigned default 0;
33
34  truncate table users;
35  start transaction;
36  while v_counter < v_max do
37        insert into users (username) values (concat('username ', v_counter+1));
38    set v_counter=v_counter+1;
39  end while;
40  commit;
41end #
42
43delimiter ;
44
45
46mysql> call load_test_data();
47Query OK, 0 rows affected (1.69 sec)
48
49mysql> select count(*) from users;
50+----------+
51| count(*) |
52+----------+
53|    10000 |
54+----------+
551 row in set (0.00 sec)