Jump to content
xisto Community
Sign in to follow this  
iGuest

Mysql 5.0 Server with .NET (ASPX) - mysql database cross size limit MySQL Database Problems

Recommended Posts

Mysql 5.0 Server with .NET (ASPX) - mysql database cross size limitMySQL Database Problems

Hello,

I have a Mysql 5.0 Server. And same server I host my site coded in .NET (ASPX). My site is goes to the database and pick data from there and display it over internet. Now when my pick time starts at that movment my site is working very slow. Some times it goes time out or page can not be displayed.

 

I cant understand is this prob. Of mysql or site ?

my database size is approx 4.5 GB.

 

In advance thanks for  help

 

-question by SurajKeywords:

Share this post


Link to post
Share on other sites

There are numerous reasons that your site could be running slowly. Of course there could always be hardware concerns. Your statement seems to indicate that the database and the web server are on the same box. Checking your hardware's performance logs could reveal problems.

Though there may be hardware issues I am going to guess that the performance issues are more likely to be a result of poor database and/or query optimization. First take a look at your database design and determine of you have followed the rules of normalization or normal form. Then have someone else take a look at your data model, it never hurts to get a second opinion. Remember you can nad should check up on the health of your database as well.

If you have all your data normalized and modeled well take a look at your queries. With MySQL you can append the the EXPLAIN statement to the front of a SELECT query to see how well it is running. If your SELECT queries are not searching indexes then you will be able to determine where you need indexes based on the information given. Be sure to read the documentation topic about optimization.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.