FW: sysmaster slow

You need to know what is in your rootdbs. With a default installation, your logical logs and physical log will be in your rootdbs - and these are all system tables/spaces. On a busy system this can kill you. In my case I have my logical logs in separate dbspaces, and these spaces are even on separate physical disks. Just a matter of understanding your system layout, and how busy your system is. And from my experience, queries on sysmaster has never been quick on a busy system ... ________________________________________ From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Floyd Wellershaus Sent: 21 January 2005 02:02 AM To: informix-list@iiug.org Subject: sysmaster slow Can anyone tell me why my rootdbs is being hit so hard ? Below is a partial output, sorted by io, of an onstat -g iof. ' When I try and query tables in sysmaster, it takes forever, and am wondering if the heavily used rootdbs has something to do with it. Is there a way of finding out what is going on in that rootdbs ? ' Thanks, IBM Informix Dynamic Server Version 9.40.FC3'''' -- On-Line -- Up 2 days 20:00:12 -- 4585232 Kbytes171 prod_root_c2''''' 2771643' 2757214''' 14429 175.6 ' 3 prod_root_c1''''' 2141522' 2138057'''' 3465 135.7 191 prod_stpx2c1'''''' 861237'' 854256'''' 6981' 54.6 201 /dev/prod_stx_c1'' 553963'' 550476'''' 3487' 35.1 202 /dev/prod_stx_c2'' 306934'' 299433'''' 7501' 19.4 102 /dev/prod_tmp3c1'' 303168''' 14233'' 288935' 19.2 ' 9 prod_stpf6c1'''''' 298403'' 296762'''' 1641' 18.9 160 prod_gsid_c4'''''' 294784'' 292434'''&! nbsp; 2350' 18.7 '74 /dev/prod_tmp1c1'' 291313''' 25583'' 265730' 18.5 138 prod_gsid_c1'''''' 283731'' 281398'''' 2333' 18.0 100 /dev/prod_tmp2c1'' 262428''' 26478'' 235950' 16.6 '86 prod_stpf3c1'''''' 257166'' 247665'''' 9501' 16.3 159 prod_gsid_c3'''''' 243128'' 241057'''' 2071' 15.4 '85 prod_stpf2c1'''''' 233882'' 231671'''' 2211' 14.8 '48 prod_tsub_c4'''''' 226468'' 120469'' 105999' 14.3 '87 prod_stpf4c1'''''' 216517'' 210033'''' 6484' 13.7 199 /dev/prod_stu_c1'&n! bsp; 203175'' 200798'''' 2377' 12.9 '11 prod_stpf9c1'''''' 204380'' 199285'''' 5095' 12.9 143 prod_gsid_c2'''''' 200564'' 198569'''' 1995' 12.7 ' 7 prod_stpf7c1'''''' 194700'' 193566'''' 1134' 12.3 '84 prod_stpf1c1'''''' 185105'' 181710'''' 3395' 11.7 ' 8 prod_stpf5c1'''''' 161562'' 160275'''' 1287' 10.2 212 prod_gsid_c5'''''' 135067'' 132928'''' 2139'' 8.6 '10 prod_stpf8c1'''''' 129790'' 129127''''' 663'' 8.2 208 prod_slog_c1''''''' 98419''' 98000''''' 419'' 6.2 273 prod_dtlf6_c2'''''' 95255''' 95255''''''' 0'' 6.0 195 prod_rptq_c1''''''' 90133''' 32219''' 57914'' 5.7 '68 prod_ssub_c3''''''' 89936''' 57358''' 32578'' 5.7 252 prod_dtlf1_c1'''''' 84076''' 83846''''' 230'' 5.3 274 prod_dtlf6_c3'''''' 80845''' 80743''''' 102'' 5.1 257 prod_dtlf2_c2'''''' 79902''' 79902''''''' 0'' 5.1 217 prod_gsid_c6''''''' 80946''' 78658'''' 2288'' 5.1 256 prod_dtlf2_c1'''''' 79018''' 79018''''''' 0'' 5.0 254 prod_dtlf1_c3'''''' 79160''' 79160''''''' 0'' 5.0 275 prod_dtlf6_c4'''''' 77842''' 74610'''' 3232'' 4.9 253 prod_dtlf1_c2'''''' 76954''' 76954''''''' 0'' 4.9 259 prod_dtlf2_c4'''''' 73451''' 73451''''''' 0'' 4.7 ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email:'''''''''' fwellers@yahoo.com Work:'''''''''' 703-733-4126 Pager:''''''''' 703-705-9241 Email Pager: 7037059241@my2way.com Home:''''''''' 703-430-0805 Cell:'''''''''''''703-477-6045 ======================== sending to informix-list