[rt-users] rt-2-1-85: mysql performance ?

[Michael K. Brown]

Sorry for the HTML mail... it was the easiest way to show the data.
We're having similar performance issues with rt-2-1-88.  The following
is a process list query in phpMyAdmin, after I had hit "Create a new
ticket in".  The create page only turns up after I kill the mysql
process below, or after it runs it's course.  It usually runs for more
than 200s.  Below that is the imported info from rt2, into the rt3
database.  rt2 is on the same server, and it's lightening fast compared
to rt3.  Is there any way to improve the performance?
 
New install of rt3, import of dumpfile via the 1.5 version of import
script.  MySQL 3.23.45, perl 5.8, all dependencies satisfied.
 
/Mike
 
 
75843	 rt_user	 localhost	 rt3	 Query	 196	 Copying
to tmp table	 SELECT DISTINCT main.* FROM Users main, Principals
Principals_1, CachedGroupMembers CachedGroupMembe	
 

Database
<http://labnetmgr1/phpMyAdmin/db_details.php?lang=en-iso-8859-1&convchar
set=iso-8859-1&server=2&db=rt3> rt3 running on labs 

 Table 	 Records	 Type	 Size	
 ACL   	64 	 MyISAM  	 8.9 KB 	
 Attachments   	2,238 	 MyISAM  	 3.7 MB 	
 CachedGroupMembers   	8,107 	 MyISAM  	 748.4 KB 	
 CustomFieldValues   	325 	 MyISAM  	 23.2 KB 	
 CustomFields   	21 	 MyISAM  	 4.4 KB 	
 GroupMembers   	2,651 	 MyISAM  	 93.7 KB 	
 Groups   	3,129 	 MyISAM  	 442.8 KB 	
 Links   	83 	 MyISAM  	 28.7 KB 	
 Principals   	3,453 	 MyISAM  	 130.4 KB 	
 Queues   	3 	 MyISAM  	 4.4 KB 	
 ScripActions   	15 	 MyISAM  	 3.7 KB 	
 ScripConditions   	9 	 MyISAM  	 2.9 KB 	
 Scrips   	22 	 MyISAM  	 6.6 KB 	
 Templates   	9 	 MyISAM  	 5.0 KB 	
 TicketCustomFieldValues   	2,532 	 MyISAM  	 146.5 KB 	
 Tickets   	695 	 MyISAM  	 149.7 KB 	
 Transactions   	8,005 	 MyISAM  	 628.2 KB 	
 Users   	323 	 MyISAM  	 97.1 KB 	
 sessions   	1 	 MyISAM  	 9.9 KB 	
 19 table(s)  	31,685 	-- 	6.1 MB 	
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030313/e4b9ea75/attachment.htm>