We help IT Professionals succeed at work.

MySQL Performance - Server Configuration

KOvitt
KOvitt asked
on
Hello,
Is there anything I can do with my current MySQL settings that would improve my performance?

Note: I use xampp as my webserver however I do not use the MySql bundled with xampp.

See attached files for server config/MySql Configuration and current performance.

Any suggestions are welcome, Thanks soo much!!

ServerStatus.txt
commandStats.bmp
Comment
Watch Question

The fact that update, replace, and select are using much of your resources doesn't indicate anything necessarily wrong with your settings - it means your queries themselves are intensive, and thus you need to tune your actual databases, not the MySQL server.

Have you ever indexed the fields that  you most commonly search upon?

Author

Commented:
I apologize for leaving the question unattended. Thank you for the suggestions, I hope you had a great Christmas. Have a great new year!