Bhavin I'm doing queries to one table with 4 other smaller tables. The large table is 12-14 million records. With an index, the table select is 13-15 seconds. With a compound index, the delay is sub one second. Use explain to verify which index is being used. Read the manual to tune your index's.
The only time it is slower (4-6 seconds) is when the index is in swap. Can anyone tell me how to prevent Solaris from moving part of mysqld to swap? I'm thinking a config file - but where. David > -----Original Message----- > From: Bhavin Vyas [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 3:54 PM > To: [EMAIL PROTECTED] > Subject: Slow queries > > > Hello, > I am running mysql in our production environment, which have > a few reporting > tables with millions of rows. Certain queries cascade 2 such > tables that > have millions of rows and there by, there are extremely slow, > sometimes > taking over 10 minutes. > However, we are ok with that since the size of the data is > extremely large. > However, the problem that we are facing is that when these queries are > running, other queries, *unrelated to the 2 large tables* are > also put on > hold, so they can't be executed either and basically mysql becomes > unresponsive until I kill the SLOW query and then everything > is back to > normal. > Anybody knows why this happens and if there is a solution for > this (like > maybe, reprioritizing the slow query to a very low priority > or something). I > would think that mysql would independently try to execute the > other queries > but that does not seem to be happening. > > Thanks, > Bhavin. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
