[649] in Moira
stats
daemon@ATHENA.MIT.EDU (Mark Rosenstein)
Wed Sep 8 12:13:04 1993
Date: Wed, 8 Sep 93 12:12:48 EDT
From: Mark Rosenstein <mar@MIT.EDU>
To: moiradev@Athena.MIT.EDU
In the last three weeks, there have been 82982 queries of the moira
database through moirad (i.e. NOT counting the reg_svr). Of these,
28900 of them resulted in changes to the database. Over half of the
changes are adding people to a list, and most of the remainder are
deleting members from lists.
Here are the top queries:
82982 queries total
40236 "add_member_to_list",
12032 "delete_member_from_list",
11598 "get_members_of_list",
5043 "get_alias", (the moira client uses this for control info)
2573 "get_list_info",
1939 "count_members_of_list", (the moira client uses this for control info)
1237 "get_finger_by_login",
1173 "update_finger_by_login",
885 "get_lists_of_member",
873 "get_user_account_by_name",
673 "get_user_account_by_login",
547 "get_pobox",
457 "get_filesys_by_label",
344 "qualified_get_lists", (probably "show all public mailing lists")
249 "get_server_locations",
229 "get_machine",
220 "get_machine_to_cluster_map",
191 "update_user_account",
185 "update_list",
175 "add_list",
149 "set_pobox_pop",
145 "set_pobox",
124 "add_user_account",
115 "get_cluster",
100 "get_printcap_entry",
Here's a breakdown of the queries resulting in database changes:
28900 queries total
15073 add_member_to_list
11187 delete_member_from_list
1163 update_finger_by_login
174 update_user_account
153 update_list
140 set_pobox_pop
135 set_pobox
122 add_user_account
102 add_list
I guess the lesson from all of this is: if I'm going to optimize
anything, it should be the list members queries.
-Mark
