MySQL Forums
Forum List  »  InnoDB

Slower Query Execution
Posted by: development
Date: July 18, 2005 04:52AM

Dear all,

we are using mysql 4.1.11 (innodb) on our server with optimized my.cnf file. we are having dual processor power with HT and 4 GB of RAM. we are running our business support system on it. The total database size is 16 GB including blob data.

Our some of the query takes 50-70 seconds for execution (that is usual). Now my question is if from one client i m running this slow query, so can i expect other queries slower?

what can be the solution of the problem? actually we are using large blob tables for storing email contents and sometimes we are searching some 'words' thru that tables.

I want some sugg for optimizing our system. Earliar our system was running on MyISAM tables at that time table locking was the big problem. thus we'd shifted to innodb tables. our locking problem is solved but now the performance is the big issue. i can send you the my.cnf file if required. Any type of optimization suggetions are welcome. Let me tell you one thing that our all major tables are well indexed.

Thanks
Rushik.

Options: ReplyQuote


Subject
Views
Written By
Posted
Slower Query Execution
2692
July 18, 2005 04:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.