ODBC query freezes server

[B F]

Hi all,

I am having a problem with MySQL and I hope some nice guru can help me.

I am running MySQL server v3.23.49a on Red Hat Linux v7.1. I also need to run queries on Microsoft Access running on my Win2K machine, using a MyODBC connection over the Internet. However when I run certain queries my whole MySQL server hangs until the query is complete (up to 10 minutes). Thus my entire website hangs while I run reports. :(

My queries use around 5 tables with <100,000 rows in total. Perhaps my query is locking too many tables or using too many threads? I am certain that I am NOT using the maximum # of MySQL network connections (it is set to 1,000 and netstat reports <100 open connections). Is there a way to limit resources so that a single query doesn't bring my server to its knees?


Any and all replies are much appreciated.
Thanks in advance!

Barry

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail


---------------------------------------------------------------------
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