mysql cluster 性能测试之响应时间测试用例, 请大..

　 N/A

　 N/A

　 N/A

　 N/A

Insert a record to mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to insert data for each table
mysql> INSERT INTO subscriber VALUES ('100002','100002','passwd',1,'A','A','Meil1-100002','0','0','a','0','0' );
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> INSERT INTO subscriber VALUES ('100002','100002','passwd',1,'A','A','Meil1-100002','0','0','a','0','0' );
Query OK, 1 row affected (0.06 sec)
CPU MEM IO is normal

N/A

N/A

Update records of mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to update data for each table

mysql> update schedule set add_date ='20070906' where schedule_id = '1000001';
first update the middle record,then try the foregoing record, at last try the latter record
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.5sec
mysql> update schedule set add_date ='20070906' where schedule_id = '1000001';
Query OK, 1 row affected (0.21 sec)
Rows matched: 1 Changed: 1 Warnings: 0

CPU MEM IO is normal

N/A

N/A

Delete records of mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 

mysql> delete from subscriber where drm_subscriber_id ='80005';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec

mysql> delete from subscriber where drm_subscriber_id ='80005';
Query OK, 1 row affected (0.02 sec)

CPU MEM IO is normal

N/A

N/A

Select a record to mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 
mysql> select * from subscriber where drm_subscriber_id= '999789';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> select * from subscriber where drm_subscriber_id= '999789';
Empty set (0.01 sec)

CPU MEM IO is normal

N/A

N/A

Select records of a range from mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 
mysql> select * from schedule where schedule_id like '100094%';
mysql> select * from schedule where schedule_id like '%094%';
mysql> select * from schedule where schedule_id like '94%';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> select * from schedule where schedule_id like '100094%';
11 rows in set (0.05 sec)

CPU MEM IO is normal

N/A

N/A

　 N/A

　 N/A

Insert an invalid record to mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to insert data for each table
mysql> INSERT INTO subscriber VALUES ('100002','100002','passwd',1,'A','A','Meil1-100002','0','0','a','0','0' );
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> INSERT INTO subscriber VALUES ('100002','100002','passwd',1,'A','A','Meil1-100002','0','0','a','0','0' );
Query OK, 1 row affected (0.06 sec)
CPU MEM IO is normal

N/A

N/A

Update a inexistent record of mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to update data for each table

mysql> update schedule set add_date ='20070906' where schedule_id = '1000001';
first update the middle record,then try the foregoing record, at last try the latter record
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.5sec
mysql> update schedule set add_date ='20070906' where schedule_id = '1000001';
Query OK, 1 row affected (0.21 sec)
Rows matched: 1 Changed: 1 Warnings: 0

CPU MEM IO is normal

N/A

N/A

Delete records of mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 

mysql> delete from subscriber where drm_subscriber_id ='80005';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec

mysql> delete from subscriber where drm_subscriber_id ='80005';
Query OK, 1 row affected (0.02 sec)

CPU MEM IO is normal

N/A

N/A

Select an inexistent record to mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 
mysql> select * from subscriber where drm_subscriber_id= '999789';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> select * from subscriber where drm_subscriber_id= '999789';
Empty set (0.01 sec)

CPU MEM IO is normal

N/A

N/A

Select an inexistent record of a range from mysql cluster, check response time

* use mysql monitor connect to mysql cluster
* use sentence like following to delete data for each table use primary key 
mysql> select * from schedule where schedule_id like '100094%';
mysql> select * from schedule where schedule_id like '%094%';
mysql> select * from schedule where schedule_id like '94%';

first the middle record,then try the foregoing record, at last try the latter record
* do the upper operations use other key if have
* repeat above opereations for at least 3 times

DRM work normally
there are data about at least 100000 users in databases
there are a lot of clients using database, doing updade, select ,insert, delete etc.
If without , you can use simulator to do it.

the response time is below 0.1 sec
mysql> select * from schedule where schedule_id like '100094%';
11 rows in set (0.05 sec)

CPU MEM IO is normal

N/A

N/A