Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Windows Hosting : Mysql Server Load

[Shirish]

Hey,
I am new to webhosting.
I need to know when mysql has heavy load average what else can be done rather than restarting mysql service.

[RSNET-John]

Have you tried optimizing your queries? Also, are you using ODBC or OLEDB to access MySQL?

[Shirish]

Originally Posted by RSNET-John

Have you tried optimizing your queries? Also, are you using ODBC or OLEDB to access MySQL?

Hey well as i told i am new to this so i dont know how to check whether the server is using ODBC or OLEDB to access MySQL. Can you shed some light on this?

[xnada]

well optimize is the best of suggestion's

[tanfwc]

Originally Posted by Shirish

Hey well as i told i am new to this so i dont know how to check whether the server is using ODBC or OLEDB to access MySQL. Can you shed some light on this?

Since you are using Windows, there is two option to connect to MySQL using ODBC & OLEDB.

What driver did you use to connect to the database in your script?

Have you optimize your MySQL using my.cnf?

[BizB]

run this script
http://day32.com/MySQL/tuning-primer.sh
on your mysql server
it will help you on how to optimize your my.cnf

[findhost32]

optimizing your queries is the key here, or even make some JOIN to the tables.

Do not keep large no of rows in the same table. Try to oprimize your database too.