[SOLVED] MySQL priority in Windows

[Azu]

How can I increase the priority of MySQL in Windows? When I try to in the task manager, it errors..

[Azu]

Bump.. this should be an easy question..

[Illusion]

U can try these

> mysqld_safe --key_buffer_size=<XX>M

                    --table_open_cache=<xx>M

                    --sort_buffer_size=<x>M

                      --read_buffer_size=<x>M &

                       

refer documentation for more info about system variables.

 

[sspoke]

You should open a program called MySql Administrator im pretty sure you'll get it easy than.

 

its under  Startup Variables -> General Parameters  Memory Usage.

and check out Advanced Tab also got good stuff.

[fenway]

Which OS? Why do you care?

[Azu]

Why are you all going on about memory usage? My question has nothing to do with memory usage.

I want to set mysql-nt.exe to realtime(or high) priority but it won't let me do it in the windows task manager. How do I do it?

[sspoke]

I would use RunPrio  I think the maker's website of this utility is gone but you can always google it.

 

i used this program back when my java since it's GUI was too slow

 

runprio -x runtime mysql-nt

[Azu]

Thank you