homepage Welcome to WebmasterWorld Guest from 23.23.12.202
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
Forum Library, Charter, Moderators: bill

Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10) Forum

    
WinXP how to set service process priority?
I want to set the process priority for the MySQL service to low on start up
KenB

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3116755 posted 1:38 pm on Oct 11, 2006 (gmt 0)

I am trying to figure out how to set the process priority for the MySQL service (and other services) to low on startup. Does anyone know how to do this? I can't even change the process priority of MySQL via the Task Manager bacause I am given an access denied error.

There are times that I need to start really processor intensive MySQL queries that I know will take a couple of hours to complete and I'd really prefer MySQL to really only use spare CPU cycles to work on the task at hand so that I can continue on and do other things with my computer.

 

spinnercee

10+ Year Member



 
Msg#: 3116755 posted 10:23 pm on Oct 11, 2006 (gmt 0)

I'm not sure how to do it at startup, but if you use Process Explorer (ProcEXP) at www.sysinternals.com it will allow you to change it's priority anytime after startup (even the ones TaskMan cannot). Think about it like TaskManager on steriods. Anyone who runs servers on their WinPC needs this.

You wouldn't want to do it at startup anyway, especially if you can't change it after.

KenB

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3116755 posted 12:29 am on Oct 12, 2006 (gmt 0)

Thanks, ProcEXP isn't what I'm really looking for, but it would be a good fallback position.

You wouldn't want to do it at startup anyway, especially if you can't change it after.

Actually I do. The reason is that I only use MySQL for development and every now and then I will create a bad query that will lock my system down. If MySQL was always running at low priority, I could maintain enough control over my system that I could quickly go into Windows Services and shut down MySQL. As things are now, this can take a few minutes of painstakingly clicking and patience.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved