Performance Monitor on Windows2003

[karche168]

How do I monitor the mysql performance on Windows 2003?
I know I can use perfmon to look at CPU, Memory, other than that how can I know how many active transcation, transaction/sec, memory usage for mysql, etc

Thanks

 

[vanekl]

For low-level status, try
show status;

For high-level status, check out
mysqladmin -u root -p proc stat

And for MySQL memory usage, you can use Task Manager.

 

[karche168]

is there a way to see the pattern means keeping the history for review? Thanks

 

[vanekl]

You can use Windows "Scheduled Tasks" manager to run a
DOS shell script to save the results of 'show status'
or mysqladmin into a text file.

@echo off
set filepath=c:\mysql\data\log.txt
now >> %filepath%
mysql -u root --password=mypassword --database=mydatabase -b < test.dat >> %filepath%


I'm not familiar with any programs that do this for you
automatically.