Optimization of mySQL Server

[btmeyer]

Hello,

 

I am worknig on BodyKits.com, running osCommerce. It seems that the website runs rather slow, compared to how it did originally. I was wondering if anyone had any experience with this, possibly could give me some ideas as to how to fix this problem.

 

I asked someone else, and they told me the best thing to do would be to optimize the mySQL datebase. Unfortunaly, I am unaware how to do this. I was wondering also if someone would be able to help me out by directing me in the right direction to accomplish this.

 

Thank You,

 

Brian Meyer

[email protected]

[custodian]

Hello,

 

I am worknig on BodyKits.com, running osCommerce. It seems that the website runs rather slow, compared to how it did originally. I was wondering if anyone had any experience with this, possibly could give me some ideas as to how to fix this problem.

 

I asked someone else, and they told me the best thing to do would be to optimize the mySQL datebase. Unfortunaly, I am unaware how to do this. I was wondering also if someone would be able to help me out by directing me in the right direction to accomplish this.

 

Thank You,

 

Brian Meyer

[email protected]

 

 

Is this your own personal server or is your site hosted elsewhere?

 

Optomizing will help but turing on cahing will be a huge benefit

 

If this is your personal server, then install more ram

Specifically you should install ECC Registered Ram - Once I got over a 1000 products in my store and had a constant 18 + shoppers at any given time the server which had 64 Mb was slow. Chaing fixed that, but I wanted it to be better, so I went to 512 ECC Register Ram -big difference - tomorrow I placing another 512 in for a total of a Gb. It's the best solution if you have control over the box.

 

Apache settings can help to. Again if you have control over them, let me know, I'll go into more detail.

[kgt]

Throwing more RAM will only make a difference up to a certain point. When you start getting a larger database, mysql will need more RAM to be able to do sorting on queries, which is limited by configuration values. So veen if there's tons of RAM available, MySQL will not use it unless you increase buffer sizes. You will need to modify the my.ini or my.cnf file to increase buffer sizes.

 

http://dev.mysql.com/doc/refman/5.0/en/ser...parameters.html

[ozcsys]

Hello,

 

I am worknig on BodyKits.com, running osCommerce. It seems that the website runs rather slow, compared to how it did originally. I was wondering if anyone had any experience with this, possibly could give me some ideas as to how to fix this problem.

 

I asked someone else, and they told me the best thing to do would be to optimize the mySQL datebase. Unfortunaly, I am unaware how to do this. I was wondering also if someone would be able to help me out by directing me in the right direction to accomplish this.

 

Thank You,

 

Brian Meyer

[email protected]

 

 

You might want to read throgh the thread found HERE

 

Are you using one of the template systems? If so then they will slow down your store

[btmeyer]

Hello,

 

Thanks for your comments. I did find one thing that I thought was interesting. Firstly, I would like to let you know, I am working on this for someone, so which had this website created by Codemystore.com. So yes, it is a template based one. The interesting thing I found was, when I looked at the source after visiting the website, I noticed in the javascript it said "onLoad="preloadImages()" which was in the body tags.

 

I would like to know, since I am assuming this is requiring every image to load 100% prior to showing the website. I would like to know if this might have something to do with this.

 

If that is something that should be looked at, where could I go to changed these fuctions. I have looked in a bunch of different files that are on the server for this shopping cart and have come up empty handed.

 

Please let me know if anyone could help,

 

Thank You

 

Brian Meyer

[email protected]