Are there any tools for finding hot spots in one's database? My screen scraper is maxing out my CPU. I'm thinking I might need some secondary indexes in some of my tables. I have a lot of two column tables consisting of integer primary key and varchar in the second column. I repeatedly search the second column and, if there is no match, return mysql_insertid.
Are there any tools to help me tell which SQL statements are gobbling up my CPU and disk? I suppose I could blindly put secondary indexes everywhere. Siegfried -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]