. Priority - mysql_connect() ??

2002-01-17 Thread Jon Shoberg 



Well,

Another app was launched on my mySQL server. Only this one is poorly coded
and heavily used. Is there a way to change the priority of my connection?
My entire app consists of select statements.  Once I changed everything to
SELECT HIGH_PRIORITY ..., that helped a ton.  Can I bump my db connection
higher?

Thanks


-
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

Re: . Priority - mysql_connect() ??

2002-01-17 Thread Jeremy Zawodny 

On Thu, Jan 17, 2002 at 08:27:40PM -0500, Jon Shoberg wrote:
 
 Well,
 
 Another app was launched on my mySQL server. Only this one is poorly
 coded and heavily used.

That sucks. :-(

 Is there a way to change the priority of my connection?  My entire
 app consists of select statements.  Once I changed everything to
 SELECT HIGH_PRIORITY ..., that helped a ton.  Can I bump my db
 connection higher?

Other than what you've done, nothing else comes to mind.

Any chance you can add indexes on the tables which may help the poorly
coded app?

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 15 days, processed 354,021,062 queries (267/sec. avg)

-
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